Hi I’m Joe! I'm a Microsoft Power Platform MVP, MCT & Power Automate FastTrack Architect. I’ve been working in the Software Development industry for over 10 years in roles ranging from Automation Testing to Software Architect.
I love to help and teach other and I love to learn, I’m currently on a mission to learn the Microsoft Power Platform products. This channel is to provide easy to understand content for the Power Platform that I've experienced working as a Power Platform Senior Solution Architect and Capability Lead.
Hey, Joe what authentication option should I choose for my copilot to perform this automated testing as I have troubles doing it using Microsoft Entra ID authentication and without authentication, should it be the manual one? thanks
Thank you for your video on this, Joe. Do you know how I can convert a user choice variable to a String and pass that to the Generative Answers action? It seems to require a String to work. Thank you!
Power Automate Desktop has a 6hour limit of waiting for desktop flow to run while it waits for another desktop flow to run. Any idea on how to increase that limit or remove it?
I have a video in my channel showing you how to cancel a lot of flows, but if you want to just cancel a single run, open the run from the information screen and press cancel
I'm super annoyed that PA automatically creates the loop without asking. when I'm trying to use a "join" or something on a collection it instead creates a loop, and the only way to avoid it is to manually type out the action name. So stupid, ticks me off every time....and with there not being an "undo" capability, then it totally screwws up your flow
It’s annoying sometimes, however you can modify the action that has had the loop auto-added to do something similar to what I e done then drag that action back out of the loop. You can then delete it as a work around.
Hi, I command in your other video as well. I literally like the content you show. I was actually making same way but i want to have two option where i can select one of it like website then I want a user can ask anything relating to that source data. so i am wondering how can i make an option and make two generative answers with different documents
Hi, Thank you for the video. I want to know what If i use a document instead of a message. for example when you add the website and start conversation and asking query regarding the url and you get answers. what If i upload two url and each one in different topic, when i select one then i start making conversation related to that url only.
You could create a switch statement to handle that such as Switch( value, “1/2”, 0.5, “1/4”, 0.25, “3/4”, 0.75) for example. You can then find and replace in the original text the output of the switch.
@@FlowJoeVideos , thanks for your replied. But seems not what I want. I’m using data verse collecting data, say Data point A, Data point B and Data point C. I want to do calculations in Power Apps Canvas App, once user input the value of A and B, the it can use the formula column to calculate A/B or B/A or any latest need for this formula and save as Data point C’s value. Your suggestion is good idea for static assumption of prediction. And I need dynamic. Anyway, thanks for your reply again
Greetings. First of all, really informative video. I managed to implement this in Copilot Studio and it is working really well. But the simulated prompt is not working when I publish the bot in Microsoft Teams. It just says that my "response was sent to the app", but then does nothing else. The prompt is correctly triggering the Topic when used in Copilot Studio, but does nothing when used in Microsoft Teams. Do you have any idea why?
hello, i want to iterate over the html elements, and want to extract multiple data based on id of any other attribute in UIPath there is a findChildren() function which gets me the child elements and iteratable, how to achieve the same in power automate?
@@FlowJoeVideos its not a list or table, its just a webpage having multiple pages(next->), i have to extract data from it, since the tags and element inside it are not structured, i am not able to get everything, i thought to loop over some tags and extract the data one by one and paste in my template but not able to iterate over any UI element,
Hi, I need to perform some actions on SharePoint excel files located in a specific folder based on their names. The file names are always in 'ABCD_ddmmYY.xlsx' format. I need to create the Flow based on the Conditions below: Condition 1: If the file is not more than 14 days from today then it should be kept as it is Condition 2: If the file belongs to the last day of every month or it is the last file of that month whether it is on last day or not then it should be kept as it is, it may have come on the very last day of that specific month or it may have come prior to that but that was the last file for that particular month. I am able to address Condition 1 completely and Condition 2 partially i.e. if it has come on the very last day of the month or not. But I can't seem to address a scenario like if I have received the file on 21st and that was the last file for that particular month. Then this file will become the last file as it is the MAX date. Can you please help? I just need help in identifying the MAX date for a specific month based on ddMMyy portion from each of the file names.
Hi Joe, great step-by-step, it's possible to cancel a Flow based on the ID item? Example, I have many requests created from SharePoint list, and I need to cancel the flow that it's associated with the ID of the list, it's possible to achieve this one? thanks in advance 👋
Quick quetion: how did you activate the top left hand box with animation of conversation, was that on a desk top window or your phone? I worked out voice assistant only relly works on mobile presenly, so I guess it's synching your mobile and desktop actions as best you can 😀
Thanks for the video. I need the solution to workaround bypass the SharePoint list, I just need a simple upload from Power Apps to Azure blob storage. I have downloaded the zip file you provided but I cannot import to my sandbox environment. Are you able to explain which step you skipped in your current video to do the bypass SharePoint list?
This was a great solution, helped me over a similar problem. I'd really like to be able to do this within the table and save the rank as a new column in the table. Calculated columns and formulas don't seem to cut it. Using this method and writing back but feels unnecessarily clunky.
The thumbs up/down is part of the adaptive card using an image as a trigger that passes back a chat using the data tag when the user presses it. For example if I press the thumbs up as the user I would then say ‘yes this helped’ or something.
in the generative anwsers task just go to Data soruces edit and left at the bottom "Advanced" and disable Send a message - then you can set the variable to the answer and place a message just with the answer text.
Hello, before I give up do any of your videos cover the following. Form/ power automate multi choice option in the form and let’s say it’s 3 options. Whatever option Is selected an email gets sent to the email attached to that option. All options have different emails attached. Please can you point me to the correct video. At present every email comes to me even when it’s set for another email address. Cheers
Power automate desktop and cloud are the same brand but one is API cloud based and one is RPA. Power Automate and Power Automate Desktop are two different products under the same branding, they’re not so much different versions but rather different products for different purposes.
Power automate desktop and cloud are the same brand but one is API cloud based and one is RPA. Power Automate and Power Automate Desktop are two different products under the same branding, they’re not so much different versions but rather different products for different purposes. Things for API based approaches are faster and easier on Power Automate cloud whereas Desktop is an RPA based product.
If it’s a custom website that’s behind a password, it will not have access to the information so it will not work, you will need to pivot and make api requests for the information.
@@FlowJoeVideos Horizontally i hv list of roles, vertically user list Checkbox against each combination. Something like we experience when we add/remove privileges while editing security role in model driven app
Slice returns a substring by specifying the starting and ending position of the string inclusive of the Starting Index. Substring returns a substring starting from the specified index and goes till the number of characters that you want in the substring. So the difference is being able to set an amount of characters from the initial index for x amount of characters vs taking two specific points with a start and end. So they’re similar, but have different use cases.
At the time of recording, when you place the response variable into an adaptive card, it removes the references. You can however use PowerFX to remove elements from the returned response as they’re just referenced. So, for example you could target everything up until a http and remove the rest.
Great post Joe. An observation, when I use the same in team, the images are not showing. but it's showing in copilot studio. Is it some issue with adaptive card.? many thanks.
I believe Microsoft Teams only supports Adaptive Cards version 1.2 so you will have to use that if you were wanting to push adaptive cards to teams; Check out; www.flowjoe.io/2021/05/25/getting-started-with-creating-adaptive-cards-for-microsoft-teams/
Fantastic video; thank you; how about covering topic ... create custom answers properties as it is not clear whether one can add a public website which is additional to the 4 public website max; also should like to see if the topic you create confine answer to the added public website.
The topic specific generative answer node is completely separate so it won’t count towards the maximum used in the Generative Ai section. The answer is the confined to that specific topic unless you reroute to the end of conversation topic and conduct the gen answers call there.
Hi Joe, I have followed through your steps (I am using SharePoint), it works get what I need but then every time Flow runs; it gives me the same name/value. For example if I want to accomplish a user name, it always gives me the same user's name instead giving me the correct name, any idea, how I can fix this? I have been working on this for past 2 days but nothing until I saw your video, any assistance, much appreciate it. Thanks