- 10
- 2 012
Manish Solanki
India
Приєднався 18 лют 2008
Manish Solanki is a technology enthusiast with vast experience in Microsoft technology stack. I specialize in designing and implementing solutions using low-code tools like Power Apps, Power Automate, AI builder, Dataverse etc. Experience in leveraging O365/M365 services such as SharePoint, Planner, Forms etc. to drive efficiency and innovation. I love writing technical blogs, collaborating in technical communities & basically anything & everything in technology.
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
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
Переглядів 26019 годин тому
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...
Great tutorial.. Concepts explained very well here..
Glad it was helpful! ☺️
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')})
Good one Manish
Thank you so much!
Excellent
Thank you! Cheers!
This example was very easy to understand.
Glad you found it easy to understand :)
its amazing video and it is very helpful
Glad it was helpful!
This is top stuff.. explained very nicely
I'm glad you found it helpful!
Excellent 👌
Thanks for watching
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']%" }
Very insightful and neatly explained so that beginners like myself can understand. Great help. Thanks
I'm so happy this tutorial helped you!
Excellent 👌
Thanks a lot 😊
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..
is admin access mandatory?
Yes, it is mandatory to have admin consent to grant service principal appropriate persimmon to trigger the flow.
Thank you for sharing Sir
You're welcome! Glad it was helpful.
This is very helpful. Thanks for uploading the tutorial
Glad it was helpful!
Superb
Is flow instance executes with service principle credentials?
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.
Good
Thanks 🙏
Great stuff
Thanks for sharing this content, Manish. This is very helpful.
Glad it was helpful!
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. 👍
Glad it was helpful! Thank you so much ☺️
Keep it Up
Thanks :)
Nice 👍
Glad you liked it!
Great work. All the best. 👍
Thanks a lot 😊
Great start Sir!! 🎉
Thanks a ton :)
Great start Manish! All the best!
Thanks, Sudeep for your words of encouragement!
Short and sweet video, made it easy to understand. Looking for more such tutorials.
Thanks. Glad you liked it! :)
It is very useful for me. Thanks manish ji
I am glad to know that you find it useful :)
Wow , u are amazing bro , u have explained very beautifully,keep up the good work , waiting for more
Thank you so much 😀
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.
Glad to hear that :)