Desktop Data Crunching
Desktop Data Crunching
  • 182
  • 587 871
Using Subflows in Power Automate Desktop
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to leverage Subflows to better organize your work and make repeatable flow parts.
Building a Basic Desktop Flow with Power Automate Desktop (Part 1): ua-cam.com/video/NXCA9pjd-2o/v-deo.html
Using Variables in Power Automate Desktop (Part 2): ua-cam.com/video/jTqMjnfC5FA/v-deo.html
Passing Variable Values into Power Automate Desktop Flows (Part 3): ua-cam.com/video/Kilhsq76PMI/v-deo.html
Looping Over Values in Power Automate Desktop (Part 4): ua-cam.com/video/GtCrO0ey8cA/v-deo.html
Sign up for our free RPA in a Day class: www.pragmaticworkstraining.com/on-demand-learning-rpaiad/
RPA in a Day class files: aka.ms/RPAinaDayPackage
Getting Started with RPA using Power Automate Desktop: ua-cam.com/video/_tGJvK3iaqg/v-deo.html
Переглядів: 6 529

Відео

Looping Over Values in Power Automate Desktop
Переглядів 10 тис.3 роки тому
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to implement a solution that leverages the For Each looping capability in Power Automate to iterate over multiple values from an Excel spreadsheet. Building a Basic Desktop Flow with Power Automate Desktop (Part 1): ua-cam.com/video/NXCA9pjd-2o/v-deo.html Using Variables in Power Auto...
Passing Variable Values into Power Automate Desktop Flows
Переглядів 11 тис.3 роки тому
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to pass values into your Desktop Flow from a Cloud Flow solution using variables. Building a Basic Desktop Flow with Power Automate Desktop (Part 1): ua-cam.com/video/NXCA9pjd-2o/v-deo.html Using Variables in Power Automate Desktop (Part 2): ua-cam.com/video/jTqMjnfC5FA/v-deo.html Sig...
Using Variables in Power Automate Desktop
Переглядів 11 тис.3 роки тому
In this video Devin continues building on a previously created Power Automate Desktop Flow design to show how to leverage variables to make solutions dynamic. Building a Basic Desktop Flow with Power Automate Desktop (Part 1): ua-cam.com/video/NXCA9pjd-2o/v-deo.html Sign up for our free RPA in a Day class: www.pragmaticworkstraining.com/on-demand-learning-rpaiad/ RPA in a Day class files: aka.m...
Building a Basic Desktop Flow with Power Automate Desktop
Переглядів 1,6 тис.3 роки тому
In this video Devin covers the the beginning design of a Power Automate Desktop Flow that will be used over the course of the next several videos. This basic video guides you through create a Desktop Flow leveraging the Desktop Recorder. Sign up for our free RPA in a Day class: www.pragmaticworkstraining.com/on-demand-learning-rpaiad/ RPA in a Day class files: aka.ms/RPAinaDayPackage Getting St...
Publishing your Chatbot in Power Virtual Agents
Переглядів 6733 роки тому
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you will learn how to publish your bot and share a demo site with your colleague to test your work.
Monitoring your Chatbot in Power Virtual Agents
Переглядів 1153 роки тому
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you will learn how to monitor how successful your chatbots are at answering your users questions. Using the monitoring capability you will uncover areas of your chatbot that can be improved.
Using Suggested Topics in Power Virtual Agents
Переглядів 1,4 тис.3 роки тому
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you will learn how to easily create new topics by leveraging the suggested topics feature.
Getting Started with Power Virtual Agents
Переглядів 2193 роки тому
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you'll get a quick overview of how to get started with Power Virtual Agents.
Power BI Monthly Digest - March 2021
Переглядів 4833 роки тому
Quick review of some of the top Power BI features released in March 2021: •Azure Map Update •Small Multiples Update •X-Axis Constant Line •IF.EAGER •CALCULATE improvements
Power BI Monthly Digest - February 2021
Переглядів 5773 роки тому
Quick review of some of the top Power BI features released in February 2021: •New search bar •Model view sync with theme •Fields pane update •Small multiples changes •Mobile layout updates •Enhanced dataset metadata now generally update
Merging PDFs with Power Automate Desktop
Переглядів 11 тис.3 роки тому
In this video Devin covers shows how you can use the Power Automate Desktop for a common task like merging PDF files together. Sign up for our free RPA in a Day class: www.pragmaticworkstraining.com/on-demand-learning-rpaiad/
Getting Started With Robotic Process Automation (RPA) Using Power Automate Desktop
Переглядів 16 тис.3 роки тому
In this video Devin covers the basics of what Robotic Process Automation is and how using Microsoft's Power Automate you can build Desktop Flows to automate tasks you previously thought could only be done by a human. Sign up for our free RPA in a Day class: www.pragmaticworkstraining.com/on-demand-learning-rpaiad/
Power BI Monthly Digest - November 2020
Переглядів 3063 роки тому
Quick review of some of the top Power BI features released in November 2020: •New Field and Model View (Preview) •Filters Pane - Apply all filters button •Data Lasso now available in maps •Visual Zoom Slider •Anomaly Detection (Preview)
Power BI Monthly Digest - October 2020
Переглядів 1673 роки тому
Quick review of some of the top Power BI features released in October 2020: •Personalized visuals now GA •Visual lasso tool updates •Export data from Q&A Visuals •Excel connector update to find suggested tables
Power BI Monthly Digest - September 2020
Переглядів 2003 роки тому
Power BI Monthly Digest - September 2020
Power BI Monthly Digest - August 2020
Переглядів 3464 роки тому
Power BI Monthly Digest - August 2020
Power BI Monthly Digest - July 2020
Переглядів 5864 роки тому
Power BI Monthly Digest - July 2020
Power BI Monthly Digest - June 2020
Переглядів 2954 роки тому
Power BI Monthly Digest - June 2020
Power BI Monthly Digest - May 2020
Переглядів 1464 роки тому
Power BI Monthly Digest - May 2020
Power BI Monthly Digest - April 2020
Переглядів 1604 роки тому
Power BI Monthly Digest - April 2020
Power BI Monthly Digest - March 2020
Переглядів 3234 роки тому
Power BI Monthly Digest - March 2020
Power BI Monthly Digest - February 2020
Переглядів 3764 роки тому
Power BI Monthly Digest - February 2020
04 Power BI Hiding Visual Interactivity Completed
Переглядів 2,6 тис.4 роки тому
04 Power BI Hiding Visual Interactivity Completed
03 - Power Automate Documenting Flow Logic
Переглядів 2,9 тис.4 роки тому
03 - Power Automate Documenting Flow Logic
Power BI Monthly Digest - November 2019
Переглядів 1644 роки тому
Power BI Monthly Digest - November 2019
Power Platform Quick Tips - Episode 02: Dynamic Power Apps Form Headers
Переглядів 8664 роки тому
Power Platform Quick Tips - Episode 02: Dynamic Power Apps Form Headers
Power Platform Quick Tips - Episode 01: Fixing Power BI Column Sorting
Переглядів 3754 роки тому
Power Platform Quick Tips - Episode 01: Fixing Power BI Column Sorting
Power BI Monthly Digest - October 2019
Переглядів 3834 роки тому
Power BI Monthly Digest - October 2019
Power BI Monthly Digest - September 2019
Переглядів 2785 років тому
Power BI Monthly Digest - September 2019

КОМЕНТАРІ

  • @Victor-yn6lv
    @Victor-yn6lv 2 дні тому

    Thank you for creating and sharing such amazing Power BI interview videos.

  • @gintomino4136
    @gintomino4136 16 днів тому

    you're a lifesaver!

  • @Konfiskation
    @Konfiskation 3 місяці тому

    Hey, is there any chance you could reshare the file for the custom visual? I have not found a good successor yet :(

  • @lajwanti3049
    @lajwanti3049 6 місяців тому

    I have built an organizational chart for my company with the visual Hierarchy Chart by Akvelon. Now i would like to filter for a specific team: basically, i would like (with a slicer or other solution) to start the tree at a lower point in the hierarchy.

  • @Lennings82
    @Lennings82 7 місяців тому

    In the desktop verson. Can i send variables from one flow to another?. And not a sub flow.

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 7 місяців тому

      You can but you'll need a cloud flow to orchestrate sending the variable values between flows.

  • @user-nv1je1yn8n
    @user-nv1je1yn8n 7 місяців тому

    Hi, please the link to the consumer dataset used isnt working. Can you share a working link?

  • @TechRevivalist
    @TechRevivalist 8 місяців тому

    very helpful

  • @shazja25
    @shazja25 9 місяців тому

    Hello! Need help, suddenly the flow crash and I think theres something wrong in the connector (Merge PDF Adobe), and it always says: No input was provided for combining files, but I use array file and it works on the previous runs. anysuggestion? Thank you so much.

  • @ashwinkumar5223
    @ashwinkumar5223 11 місяців тому

    please activate the link to get dataset.

  • @Dorak1005
    @Dorak1005 11 місяців тому

    Hello Devin, is there also a flow to create in Power Automate Desktop to merge several documents with different extensions (.pdf, .doc, .txt, .tiff, .jpg) to one PDF file? So not only PDf files, but all kind of files. Hopefully you can help me with this. Looking forward to your reply. With regards. Diana

  • @ashwinkumar5223
    @ashwinkumar5223 Рік тому

    please provide dataset file. Thanks

  • @bhaskaraggarwal8971
    @bhaskaraggarwal8971 Рік тому

    This is awesome✨✨ A complicated concept explained in such a lucid way. Big thank you!!

  • @piyushchaudhari2635
    @piyushchaudhari2635 Рік тому

    Training Completed.xlsx not working

  • @moeaung729
    @moeaung729 Рік тому

    can you create a condition for the loop so it only copies data from visible cells in an excel table?

  • @pratapchitdumrongsakul2167

    Love this video, thanks a lot.

  • @shubhabratadey
    @shubhabratadey Рік тому

    Great video on RLS

  • @mmbcampus
    @mmbcampus Рік тому

    How we can apply loop through each column ?

  • @charlescaison4376
    @charlescaison4376 Рік тому

    Fantastic video for a first time user of Power Automate. I used it directly in a project and it saved me a ton of time. Thank you for making this.

  • @kristian4805
    @kristian4805 Рік тому

    Woah!! Thank you! now i know how to pass values in both directions. Just need to remeber to make input and output values in desktop and have a little patience or refresh in cloud to have them show up as options. Sweet!

  • @jfrlawal4
    @jfrlawal4 Рік тому

    I want to use power automate desktop to fill a web page with the content of an excel table . First, I will have to match the beneficiary Id from the web and Excel tabe then take each item of the Mother DoB column of the excel table then click on update on the web page and populate. Kindly provide me with step by step guide

  • @mirrrvelll5164
    @mirrrvelll5164 Рік тому

    Nice video. Question, what are the dimensions and size of your images? Seems quite big, and I am getting blurry and cant see anything, I tried couple of ways to resize it. I am sure the size plays a huge role, is it?

  • @ChrisLoth
    @ChrisLoth Рік тому

    At about 11min in, is there a reason that you use the OR operator for the county filter as opposed to an IN operator?

  • @andrewlu8432
    @andrewlu8432 Рік тому

    can use this visuals build custom slicer use html & CSS?

  • @weebcentral1534
    @weebcentral1534 Рік тому

    Glad that i found this video, i was stuck in a specific point where I couldn't loop my flow but Thanks your %CURRENTITEM%['name'] tip saved my flow. 👍

  • @cristianbasaez6270
    @cristianbasaez6270 Рік тому

    Awesome video, thank you very much

  • @ash2989
    @ash2989 Рік тому

    Thanks guys!!

  • @denwo1982
    @denwo1982 Рік тому

    Can you import topics from an excel spreadsheet?

  • @patrudunaidu
    @patrudunaidu Рік тому

    bci calendar don't have a tooltip. how can we add report level tooltip for bci calendar

  • @kovurudivya1277
    @kovurudivya1277 Рік тому

    Is that work for us state and drill down for US city as drill down

  • @thomascole1782
    @thomascole1782 Рік тому

    I want to use input and output variables to build tiny desktop flows that can be assembled into larger flows using "Run Flow". All within Desktop Flows. I know that I can use subflows similarly to what Im describing, but subflows are not reusable outside of the flow where the sub-flow lives. I can't figure out how to pass input variables to a desktop flow, from a calling desktop flow. Am I thinking about this wrong? One example might be a tiny flow called "get logged in". It has an output variable called "WasSuccessful". That flow is not useful by itself, but is handy for living within a whole set of my larger flows.

  • @FrankLeeYing
    @FrankLeeYing Рік тому

    Excellent video, well thought out and delivered thank you :)

  • @edtignor4235
    @edtignor4235 Рік тому

    Great info!

  • @MissMe1111
    @MissMe1111 Рік тому

    Can you embed a virtual agent chatbot on a native app?

  • @dalpatmistry5571
    @dalpatmistry5571 Рік тому

    How can I run/schedule this (power automate flow) flow from excel VBA? - Please advise! Thank you and appreciate it

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 Рік тому

      I'm not aware of a way to run flows from Excel VBA. You would need a cloud flow to schedule these as of right now.

    • @dalpatmistry5571
      @dalpatmistry5571 Рік тому

      @@desktopdatacrunching4032 Thank you so much! - I will try cloud flow. Again, this is awesome clip - I tried and works much better. Appreciate it! have a great day!

  • @thebhaskarjoshi
    @thebhaskarjoshi Рік тому

    Json files are not available

  • @edtignor4235
    @edtignor4235 Рік тому

    BOOM! I just got through debugging and cleaning some of my code and I look up and see that I haven't created any input or output variables and had no clue what they were for. I created regular variables in my flow as easy as washing my hands but didn't know about this other method. This is going to be a game changer my friend! Drinks on me if you make it to Nashville!

  • @edtignor4235
    @edtignor4235 Рік тому

    HO LEE SH... Crap! This is a game changer! In my current setup, I get structured PDFs in my email. I save them to a synched OneDrive folder which triggers the AI I build on PA to scrape the PDF for items I need from the doc. Then it emails the values to me in an excel sheet but they are all on one row and not very user friendly to read. My next step is a PAD flow that converts the PA excel sheet into my final customer data sheet in the preferred cells before extracting the values to use to fill in a website where I enter order information into my proprietary real estate software. Using this knowledge, YOU HAVE SAVED ME QUITE A HASSLE!!! Since it's already almost 11pm, I plan to use tomorrow to set up all the new output and input variables into my existing system and give it a whirl!!! Fingers crossed!

  • @dalpatmistry5571
    @dalpatmistry5571 Рік тому

    This is awesome! Can we use VBA to execute this automation?

  • @cylam1474
    @cylam1474 Рік тому

    Thaks for the video, I would like ot ask: "can I convert many many PDFs in a folder into Words documents?"

  • @maryparkers2970
    @maryparkers2970 Рік тому

    Thanks for this Brilliant tutorial. Just a good one amongst many. Thank you

  • @triloksingh693
    @triloksingh693 Рік тому

    Great but what if we need to merge identical PDFs file into single pdf separately...

  • @LuckyLikeGaming
    @LuckyLikeGaming 2 роки тому

    sound and video when not at the same time for me

  • @decoeflavianews
    @decoeflavianews 2 роки тому

    I was able to achive my test just watching the video. Thank You.

  • @nssdesigns
    @nssdesigns 2 роки тому

    This is great but..... i have a folder with 2000 pdf files and I need to merge certain files to create test packs. Several hundred test packs. Each files has a unique #3234 id number and I want to use Excel to parse the files to merge in each test pack. I've tried concatenating file addresses and when I paste this string into the merge files it works BUT when i pass it using a variable it fails. I was thinking if I get a list of ALL 2000+ files in a folder and parsing the files needed using an IF function IF the folder contain files starting with #3234,#3230"1987,#30 then merge theses files and Excel drives this IF variable using currentItem variable.

    • @mrchrishewitt
      @mrchrishewitt Рік тому

      HI Nssdesigns, did you ever resolve your issue? I have a similar requirement

  • @Khanjaslera117
    @Khanjaslera117 2 роки тому

    Please support

  • @Khanjaslera117
    @Khanjaslera117 2 роки тому

    ua-cam.com/video/VA0zyIo211s/v-deo.html

  • @PeterPanQuails
    @PeterPanQuails 2 роки тому

    Thank you Devin. Can we trigger the start of the process by events like time of the day, rather than to have the user click the "Run" in Power Automate?

    • @desktopdatacrunching4032
      @desktopdatacrunching4032 2 роки тому

      You can but you would have to use a cloud flow that then later runs the desktop flow to do that.

  • @happy9955
    @happy9955 2 роки тому

    very details thank you

  • @latiefahmad920
    @latiefahmad920 2 роки тому

    Sir in which software we can make flow map ?? And can we do it in excel, ms word or paints ?? Plz i need to make migration flow map..!!

  • @therichardchannel
    @therichardchannel 2 роки тому

    Do you know how I can iterate over a list of powerpoint files that need to be converted to MP4 videos? I can retrieve the files and then place a recorded action of exporting by clicking on UI elements in a for each loop, but it always repeats the recorded action for the first file only. How can I have a recorded action apply to each file's own UI elements (file tab, export button, save button, etc.) ?