Manish Solanki
Manish Solanki
  • 10
  • 1 825
Create Word document from template with a repeating section in Power Automate Desktop
Learn to create MS word document from a template in Power Automate Desktop flow.
In this video, I demonstrated the detailed steps to create a word document from a template with a repeating section directly in #PowerAutomateDesktop. I used power fx function as a substitute for "𝗦𝗲𝗹𝗲𝗰𝘁" action to avoid adding loop and improve the efficiency of the flow.
𝗞𝗲𝘆 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀 𝗳𝗿𝗼𝗺 𝘁𝗵𝗶𝘀 𝘃𝗶𝗱𝗲𝗼:
▶️ Create word document with a repeating section or table directly in PAD
▶️ Use #powerfx to transform data table to a list of custom objects without using loop
▶️ Leverage SharePoint cloud connector in desktop flow for integrating with libraries or lists
🔔 𝘋𝘰𝘯'𝘵 𝘧𝘰𝘳𝘨𝘦𝘵 𝘵𝘰 𝘭𝘪𝘬𝘦 & 𝘴𝘶𝘣𝘴𝘤𝘳𝘪𝘣𝘦 𝘵𝘰 𝘮𝘺 UA-cam 𝘤𝘩𝘢𝘯𝘯𝘦𝘭 @manishsolanki01 𝘪𝘧 𝘺𝘰𝘶 𝘧𝘪𝘯𝘥 𝘵𝘩𝘪𝘴 𝘷𝘪𝘥𝘦𝘰 𝘶𝘴𝘦𝘧𝘶𝘭.
#MicrosoftPowerPlatform #PowerPlatform #SharingIsCaring #powerautomatedesktop
Переглядів: 25

Відео

Process Invoice Document without Setting up Custom AI Builder Model
Переглядів 243День тому
The introduction of adding images or documents (in preview) as input parameter in custom #GPT prompt makes it easier for non technical users to extract specific fields without the need for pre-training models with sample data. This reduces the time and effort spent on preparing and fine-tuning custom models for document processing. Features & Benefits: ✅ Save time on automating document related...
Copilot feature to build & edit cloud flow in teams
Переглядів 56День тому
Using #CoPilot feature, you can use natural language to create #PowerAutomate in #MicrosoftTeams. The "𝗪𝗼𝗿𝗸𝗳𝗹𝗼𝘄 𝗕𝘂𝗶𝗹𝗱𝗲𝗿" feature allows generating a cloud flow based on the input description and thereby eliminates the need to build flow from scratch. Benefits: 📌 Ease of building cloud flow in teams when the prebuild template does not fit the scenario. 📌 Uses #AI to generate and suggest a cloud ...
How to update value of a work queue item in power automate desktop?
Переглядів 11214 днів тому
The recent release of #PowerAutomateDesktop (v2.50) allows updating value of work queue items without changing the status of an item. Through this tutorial I have explained the process to update the value of 'Queued' invoice items with the latest values stored in an input csv file. The value of work queue items is being replaced with JSON object using "𝗨𝗽𝗱𝗮𝘁𝗲 𝘄𝗼𝗿𝗸 𝗾𝘂𝗲𝘂𝗲 𝗶𝘁𝗲𝗺" action. Key takeaw...
How to extract data from datagrid in legacy application?
Переглядів 96Місяць тому
The new "𝗘𝘅𝘁𝗿𝗮𝗰𝘁 𝗱𝗮𝘁𝗮 𝗳𝗿𝗼𝗺 𝘁𝗮𝗯𝗹𝗲" action introduced in Power Automate Desktop V2.49 enables extraction of tables and data grids from target applications. It allows extraction in 2 ways - in a excel worksheet or in a variable. ✨ In this video, I have explained steps: - To extract table from data grid of a legacy window application - Collect data in a datable variable - Create csv file from the v...
How to set up fallback Mechanism for UI elements in Power Automate Desktop?
Переглядів 105Місяць тому
Microsoft has introduced a feature to provide a reliable solution for UI and browser automation actions. With this feature, users can set up a fallback mechanism for UI automation actions in case the UI element cannot be found through the set selector(s). I will demonstrate the image fallback solution by taking an example of click link action. The class of link element on web page has been upda...
Secure HTTP Request EndPoint In Power Automate
Переглядів 416Місяць тому
It is a common scenario to exchange data between applications. In Power Platform, this is done through “HTTP” request trigger that supports exchange of data with external or 3rd party applications but the request end point should be secured to prevent breach. In this video, I am going to demonstrate the 2-step process to invoke HTTP request endpoint from postman (external party). You can export...
Auto Retry Work Queue Item in Power Automate Desktop
Переглядів 221Місяць тому
This Video demonstrates how to set up retry mechanism for work queue items. It shows the detailed steps to 1. Create a work queue & enable auto retry feature 2. Use work queue actions in Desktop flow 3. Verify retry count in every iteration 4. Validate the output In automation, setting up retry policy make sure the task doesn't fail entirely at the first exception thus reduces the error & impro...
Use Azure Key Vault Secret Key In Power Automate Desktop
Переглядів 328Місяць тому
This video demonstrate the method to securely sign in to an application in Power Automate Desktop with the password stored in Azure Key Vault repository. 💼 Use Case: In UI automation, it is a standard process to sign in to an application (desktop or web) to process data in power automate desktop flow. Azure Key Vault is the safest place to securely store the application password. Storing passwo...
Describe with Copilot in Power Automate Desktop
Переглядів 2512 місяці тому
This video demonstrates "Describe to Copilot" feature in Power Automate Desktop introduced in version 2.48. With this feature, citizen developers or person without technical know-how can easily automate their day-to-day activities by simply providing instructions to create desktop flows. I have shown a use case to extract tabular data from a pdf file & save the extracted data in csv format by p...

КОМЕНТАРІ

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp 18 годин тому

    Great tutorial.. Concepts explained very well here..

  • @manishsolanki01
    @manishsolanki01 19 годин тому

    Power fx used for transforming data table to list of custom objects: =ForAll(DataFromTable,{ID:Text(ThisRecord.ID),AccountName:Text(ThisRecord.'Account Name'),PrimaryContact:Text(ThisRecord.'Primary Contact'),ContactEmail:Text(ThisRecord.'Contact Email')})

  • @sayedsuhail9513
    @sayedsuhail9513 2 дні тому

    Good one Manish

  • @jadha_ravi
    @jadha_ravi 4 дні тому

    Excellent

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp 5 днів тому

    This example was very easy to understand.

  • @miniwebcard5571
    @miniwebcard5571 10 днів тому

    its amazing video and it is very helpful

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp 11 днів тому

    This is top stuff.. explained very nicely

  • @jadha_ravi
    @jadha_ravi 21 день тому

    Excellent 👌

  • @manishsolanki01
    @manishsolanki01 21 день тому

    FetchXML Query in 'Get work queue items by filter' action to filter Queued items: <attribute name="statecode" /> <attribute name="workqueueitemid" /> <attribute name="workqueueid" /> <attribute name="name" /> <attribute name="input" /> <filter > <condition attribute="statecode" operator="eq" value="0" /> </filter> Set 'InvoiceJsonObject' variable value: { "InvoiceId":"%FilteredDataTable[0]['InvoiceId']%", "InvoiceDate":"%FilteredDataTable[0]['InvoiceDate']%", "AccountName":"%FilteredDataTable[0]['AccountName']%", "ContactEmail":"%FilteredDataTable[0]['ContactEmail']%", "Amount":%FilteredDataTable[0]['Amount']%, "Status":"%FilteredDataTable[0]['Status']%" }

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp 21 день тому

    Very insightful and neatly explained so that beginners like myself can understand. Great help. Thanks

  • @jadha_ravi
    @jadha_ravi 24 дні тому

    Excellent 👌

  • @jshankar3457
    @jshankar3457 26 днів тому

    Hi Sir I have interview Questions which is, once extracted data from the web in future if some fields will add or less in web how do we find and how to extract those fields data..

  • @-RajaRam-fo4yk
    @-RajaRam-fo4yk 28 днів тому

    is admin access mandatory?

    • @manishsolanki01
      @manishsolanki01 26 днів тому

      Yes, it is mandatory to have admin consent to grant service principal appropriate persimmon to trigger the flow.

  • @siachmad
    @siachmad Місяць тому

    Thank you for sharing Sir

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp Місяць тому

    This is very helpful. Thanks for uploading the tutorial

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp Місяць тому

    Superb

  • @Raj-true
    @Raj-true Місяць тому

    Is flow instance executes with service principle credentials?

    • @manishsolanki01
      @manishsolanki01 Місяць тому

      This will allow service principal to trigger the flow. All actions inside the http request flow will run under the context of user as specified in the connection.

  • @shilpisolanki3219
    @shilpisolanki3219 Місяць тому

    Good

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp Місяць тому

    Great stuff

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp 2 місяці тому

    Thanks for sharing this content, Manish. This is very helpful.

  • @mohammedm2018
    @mohammedm2018 2 місяці тому

    Great tutorial to show case Copilot's capabilities to help alleviate repetitive tasks by automation. Wish you the very best with your channel. I saw the post about the channel on the LinkedIn Power Platform community group. 👍

    • @manishsolanki01
      @manishsolanki01 2 місяці тому

      Glad it was helpful! Thank you so much ☺️

  • @jadha_ravi
    @jadha_ravi 2 місяці тому

    Keep it Up

  • @ranatahirtahir9980
    @ranatahirtahir9980 2 місяці тому

    Nice 👍

  • @ashu49
    @ashu49 2 місяці тому

    Great work. All the best. 👍

  • @Premankurmusic
    @Premankurmusic 2 місяці тому

    Great start Sir!! 🎉

  • @SudeepGhatak
    @SudeepGhatak 2 місяці тому

    Great start Manish! All the best!

    • @manishsolanki01
      @manishsolanki01 2 місяці тому

      Thanks, Sudeep for your words of encouragement!

  • @deepalijagtap2016
    @deepalijagtap2016 2 місяці тому

    Short and sweet video, made it easy to understand. Looking for more such tutorials.

  • @mandeep086films3
    @mandeep086films3 2 місяці тому

    It is very useful for me. Thanks manish ji

    • @manishsolanki01
      @manishsolanki01 2 місяці тому

      I am glad to know that you find it useful :)

  • @shilpisolanki3219
    @shilpisolanki3219 2 місяці тому

    Wow , u are amazing bro , u have explained very beautifully,keep up the good work , waiting for more

  • @RamandeepSingh-tf8vp
    @RamandeepSingh-tf8vp 2 місяці тому

    Thanks Manish, for giving this comprehensive tutorial of co-pilot. I was hoping to find useful resources on web.. thank God I came across this video. Great tutorial. Massive help for me.