- 10
- 1 825
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
Переглядів: 25
Відео
Process Invoice Document without Setting up Custom AI Builder Model
Переглядів 2439 годин тому
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...
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 :)