It is useful to know how to patch all items in a gallery when you want to update several items in a SharePoint list at once. To perform batch updates you can use a little-known variation of the patch function.…
Happy New Year 🥳 As another year of blogging draws to a close I would like to thank everyone who has subscribed to MatthewDevaney.com. Each week in 2023 I’ve shared a new Power Apps tip, trick or technique that I…
Wishing you a Meowy Christmas and a Catty New Year. Thank you for subscribing to my website – Matthew Devaney
A SharePoint document library is often the better choice for storing files in an app vs. Dataverse file storage. The cost of SharePoint file storage is much cheaper ($0.20/GB vs $40/GB), it has versioning built-in and you can take advantage…
A SharePoint document library can be embedded in a Power Apps custom page by using an iFrame. This technique allows us display to SharePoint document library as if we were on SharePoint.com. It also gives access to the full range…
Power Automate text functions are frequently used when writing expressions. It is important to understand all of them and what they do. In this article I will list all of the Power Automate text functions and show examples of how…
Power Automate can perform document classification with the help of Azure AI. Document classification is when AI reviews a document and determines what type of document it is. The result also includes a confidence score. Once a document is classified…
Power Automate can use AI Builder’s prebuilt model to effortlessly identify and extract the details from an invoice. Then additional actions can be added to write the invoice data to an Excel spreadsheet, a SharePoint document library or even use…
Power Automate can send a free text message to a mobile phone by using something called an email to text gateway. Every mobile phone company has one. You can send an email to a 10 digit phone number and the…
The Power Automate error message file <filename> is locked for shared use by <user email> is caused by attempting to update SharePoint file properties after performing an Excel action. I have encountered this message many times and I will share…