Manish Solanki
Manish Solanki
  • 10
  • 2 012
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
Переглядів: 128

Відео

Process Invoice Document without Setting up Custom AI Builder Model
Переглядів 260День тому
Learn to extract data from structured content in JSON format using custom #gpt prompt. 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 f...
Copilot feature to build & edit cloud flow in teams
Переглядів 5614 днів тому
Learn leveraging AI to create a flow in MS teams using natural langauge. The #CoPilot feature will create #PowerAutomate cloud flow 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...
How to update value of a work queue item in power automate desktop?
Переглядів 12821 день тому
Learn to update the value of work queue item without changing the status of an item in #powerautomatedesktop 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 takeaways from this tutorial: ▶...
How to extract data from datagrid in legacy application?
Переглядів 104Місяць тому
Learn how to extract data from table or data grid in legacy application using new "𝗘𝘅𝘁𝗿𝗮𝗰𝘁 𝗱𝗮𝘁𝗮 𝗳𝗿𝗼𝗺 𝘁𝗮𝗯𝗹𝗲" action introduced in Power Automate Desktop V2.49. 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 ...
How to set up fallback Mechanism for UI elements in Power Automate Desktop?
Переглядів 107Місяць тому
Learn to set up fallback mechanism for UI elements in automation to reduce errors. 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). In this video, I have demonstrated the image fallback solu...
Secure HTTP Request EndPoint In Power Automate
Переглядів 426Місяць тому
Learn to set up a #secure #http request end point in power platform to exchange data with external or third party applications or systems. 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...
Auto Retry Work Queue Item in Power Automate Desktop
Переглядів 229Місяць тому
Learn the concept for setting up retry mechanism for work queue items in #automation project. 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...
Use Azure Key Vault Secret Key In Power Automate Desktop
Переглядів 3452 місяці тому
Learn how 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 password in Vault also allows ...
Describe with Copilot in Power Automate Desktop
Переглядів 2532 місяці тому
Learn how to leverage AI copilot feature to create power automate desktop flow using simple natural language. 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...

КОМЕНТАРІ

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

    Great tutorial.. Concepts explained very well here..

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

    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 6 днів тому

    Good one Manish

  • @jadha_ravi
    @jadha_ravi 8 днів тому

    Excellent

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

    This example was very easy to understand.

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

    its amazing video and it is very helpful

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

    This is top stuff.. explained very nicely

  • @jadha_ravi
    @jadha_ravi 25 днів тому

    Excellent 👌

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

    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 25 днів тому

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

  • @jadha_ravi
    @jadha_ravi 28 днів тому

    Excellent 👌

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

    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 Місяць тому

    is admin access mandatory?

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

      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 2 місяці тому

    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.