Power Automate can can query a Power BI dataset to return an array of values. This is very useful for retrieving large datasets quickly and summarizing them by count and sum. Writing the query to do this is very simple…
The Power Automate functions body, actions and outputs allow you to get any inputs & outputs you want from a previous action. These functions are useful because inputs, status codes and headers information do not appear in the dynamic values…
The Power Automate items functions returns the current item in an apply to each loop or a do until loop. Whereas the item function refers to the current item in a repeating action such as the Filter Array action or…
Power Automate cloud flows can be used to extract data from a web page. You can get the web page HTML by using an HTTP action and output its details with an AI Prompt. This technique will only work on…
The Outlook – Get Emails (V3) action in Power Automate can get a maximum of 25 emails. To get over 25 emails you can use the Outlook – Send An HTTP request action instead and call the messages endpoint. This…
Power Automate can be used to display a web-page or even a single-page web application in a web browser. To do this, the flow must be triggered when an HTTP Request is received and output HTML back to the web…
Happy New Year 🥳 As another year of blogging draws to a close I would like to say thank you to all of my subscribers at MatthewDevaney.com. Each week in 2024 I’ve shared a new Power Automate or Power Apps…
Wishing You A Merry Catmas & Happy Mew Year 😺🎄 I’m looking forward to sharing new Power Platform tutorials with you in 2025. Thank you for subscribing to MatthewDevaney.com. Did You Enjoy This Article? 😺 Subscribe to get new Power…
An Entra security group linked to a Dataverse Team can be used to grant access to Power Platform Environments, apps, and automations all at once. The challenge is User will not appear in the Dataverse Team unless they have logged…
The Power Automate syntax to update a lookup column in Dataverse is difficult to memorize so I have written a quick-guide on how to do it. It requires you to know the entity set name of the lookup table and…