FlowJoe

FlowJoe

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.

Пікірлер

  • @ACatCalledSnow
    @ACatCalledSnow7 күн бұрын

    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!

  • @Candy-mb3wn
    @Candy-mb3wn14 күн бұрын

    How to pass data from the adaptive card to power automate.

  • @FlowJoeVideos
    @FlowJoeVideos9 күн бұрын

    If you’re using the adaptive card in copilot studio, you pass the response to power automate as a parameter.

  • @timzelikovsky5302
    @timzelikovsky530215 күн бұрын

    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?

  • @FlowJoeVideos
    @FlowJoeVideos9 күн бұрын

    You would need to orchestrate it via power automate cloud.

  • @timzelikovsky5302
    @timzelikovsky53023 күн бұрын

    @@FlowJoeVideos I don't think Power Automate Cloud allows you to alter that setting

  • @pinupolukavya9410
    @pinupolukavya941020 күн бұрын

    How to cancel a running flow

  • @FlowJoeVideos
    @FlowJoeVideos9 күн бұрын

    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

  • @scottthompson4513
    @scottthompson451324 күн бұрын

    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

  • @FlowJoeVideos
    @FlowJoeVideos24 күн бұрын

    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.

  • @MrTC-rv3jo
    @MrTC-rv3jo25 күн бұрын

    can you do this with Power Automate on the cloud?

  • @FlowJoeVideos
    @FlowJoeVideos24 күн бұрын

    Yes the logic will be similar

  • @makaveli2183
    @makaveli218326 күн бұрын

    What if I would like to sort descending?

  • @denji3397
    @denji339727 күн бұрын

    Is it possible to embed this in a azure cloud web application?

  • @iGuide_net
    @iGuide_netАй бұрын

    These would be great if they weren't so expensive. flat $200/mo for 12,000 q/a pairs. $200/mo for each 12,000 additional.

  • @mirzatanjic
    @mirzatanjicАй бұрын

    Thank you. How to calculate duration between two dates in format Y M D ?

  • @Wasyk
    @WasykАй бұрын

    it gets only first 50 items. But what if you have 1000.

  • @FlowJoeVideos
    @FlowJoeVideosАй бұрын

    You can add a loop with an if inside, if the items returned are zero set the loop item to 1 else leave it at 0 and keep cycling through.

  • @ZeeNoorTrip
    @ZeeNoorTripАй бұрын

    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

  • @ZeeNoorTrip
    @ZeeNoorTripАй бұрын

    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.

  • @kadinamkulam
    @kadinamkulamАй бұрын

    @Flow Joe, do u have video on how to handle conditions eg, thumbs up /thumbs down ?

  • @myherbs
    @myherbsАй бұрын

    What if I want to convert a Text Formula to Number in Power Apps, say, "1/2" and I expect to have 0.5?

  • @FlowJoeVideos
    @FlowJoeVideosАй бұрын

    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.

  • @myherbs
    @myherbsАй бұрын

    @@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

  • @tareqhameed7208
    @tareqhameed7208Ай бұрын

    Can we pass HYPERLINK over teams via power automate?

  • @anubislockward3750
    @anubislockward3750Ай бұрын

    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?

  • @mikepowers4767
    @mikepowers4767Ай бұрын

    Great video. Thank you!

  • @lsuremusic3787
    @lsuremusic37872 ай бұрын

    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
    @FlowJoeVideos2 ай бұрын

    Is it a list or table you’re working with?

  • @lsuremusic3787
    @lsuremusic37872 ай бұрын

    @@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,

  • @bruno5601
    @bruno56012 ай бұрын

    Spend already threee days creating an overcomplicated solution to do something like this. Didn't worked until now, but you did man.

  • @shubhabratadey
    @shubhabratadey2 ай бұрын

    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.

  • @DaniloSange
    @DaniloSange2 ай бұрын

    How Can I add extra objects in a custom object?

  • @VANDIK01
    @VANDIK012 ай бұрын

    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 👋

  • @DavidWhite-ci2tc
    @DavidWhite-ci2tc2 ай бұрын

    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 😀

  • @FlowJoeVideos
    @FlowJoeVideos2 ай бұрын

    I used my phone and just recorded it’s screen, the audio is all from my mic. You’re correct there’s no voice input on desktop yet unfortunately!

  • @henrychoi3809
    @henrychoi38092 ай бұрын

    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?

  • @davetw
    @davetw2 ай бұрын

    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.

  • @freedomandfun
    @freedomandfun2 ай бұрын

    hi, how do I check first or last day of the sprint in Azure?

  • @joernbuelow1498
    @joernbuelow14982 ай бұрын

    Thank you for the video. What I do not understand is where get the Thumbs up / down their function in Copilot Studio so the new request is generated?

  • @FlowJoeVideos
    @FlowJoeVideos2 ай бұрын

    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.

  • @digivod6897
    @digivod68973 ай бұрын

    How to disable reference links or documents from the generative answers? Want to see only answer text without links.

  • @joernbuelow1498
    @joernbuelow14982 ай бұрын

    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.

  • @Inno94709
    @Inno947093 ай бұрын

    Great content. Buy vidbseems to be 360p and super blurry on my screen. I tried to upscale, but keeps dropping back to unreadable 360p. Any ideas?

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    Hi! If you click on Settings>Quality on KZread you should be able to select 1080p, just tried it while signed out and it appears to be working!

  • @ajayrathod7777
    @ajayrathod77773 ай бұрын

    How can we add now function in date picker in powerapps?we want to record date and time submission both

  • @grilo7805
    @grilo78053 ай бұрын

    Hi can I do this somehow in a "text imput"field ?

  • @ammadkhan4687
    @ammadkhan46873 ай бұрын

    I never could thought that of my own. your are a genius.

  • @markevans3026
    @markevans30263 ай бұрын

    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

  • @smanzoli
    @smanzoli3 ай бұрын

    I use Power Automate Desktop and it's a 100% different app... it's crazy Microsoft has created 2 completely different versions of the same app

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    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.

  • @smanzoli
    @smanzoli3 ай бұрын

    I use Power Automate Desktop and everything is like 100% different, better and easier

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    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.

  • @NileshThonte
    @NileshThonte3 ай бұрын

    what if i integrate it in custom website and website is password project how ai will extract this information from this website to provide response

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    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.

  • @rrawat9026
    @rrawat90263 ай бұрын

    Thanks.. struggling for it since 2 hrs..thanks a lot

  • @SagarS-nb9ek
    @SagarS-nb9ek3 ай бұрын

    how about creating a matrix and providing checkbox ? will it need gallaery inside gallery ?

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    Just to clarify; So you’re looking at providing a check box for multiple relationships from one record in a gallery?

  • @SagarS-nb9ek
    @SagarS-nb9ek3 ай бұрын

    @@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

  • @MarwaYasser1
    @MarwaYasser13 ай бұрын

    Thank you for such an informative video!

  • @user-fl1bk3th4s
    @user-fl1bk3th4s3 ай бұрын

    Thanks Joe, is there any difference between substring() and Slice() ? Or specific case to use Slice () function

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    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.

  • @jatinparmar852
    @jatinparmar8523 ай бұрын

    Hi Joe, thanks for the video! How did you remove citations from your Generative AI response?

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    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.

  • @JM-db1jy
    @JM-db1jy3 ай бұрын

    thanks a lot!! you've been a great help!

  • @user-co5cy4ei9t
    @user-co5cy4ei9t3 ай бұрын

    Do a google search for "Microsoft learn Cancel flow runs in bulk" and look at the 2nd half of the page that comes up.

  • @anandasanyal
    @anandasanyal3 ай бұрын

    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.

  • @FlowJoeVideos
    @FlowJoeVideos3 ай бұрын

    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/

  • @anandasanyal
    @anandasanyal3 ай бұрын

    @@FlowJoeVideos Tried with Adaptive Cards version 1.2 , but same results. Thanks

  • @sammi1651
    @sammi16514 ай бұрын

    ⭐ Promo-SM

  • @user-mz6zy2fl2p
    @user-mz6zy2fl2p4 ай бұрын

    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.

  • @FlowJoeVideos
    @FlowJoeVideos4 ай бұрын

    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.

  • @RyanSmith-mh1lj
    @RyanSmith-mh1lj4 ай бұрын

    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

  • @user-dw2er1mx9f
    @user-dw2er1mx9f4 ай бұрын

    Can this be used when authentification is on?

  • @zkorduba
    @zkorduba4 ай бұрын

    Great video! Do you happen to have a link to the Microsoft API documentation? I would love to see what else is in there. Thanks!