You can remove the duplicates from a Power Automate array in two easy steps: add a Compose action and insert a Union function. The Union function combines two arrays together and returns only unique items. Example #1: Remove Duplicate Emails…
I prefer to send Power Automate approval reminders as an email with a list of past due items. A single reminder email is much better than receiving one reminder email per late approval. Power Automate does not do this automatically…
Logging the Power Automate approval history for a specific SharePoint file or list item is helpful for auditing purposes. We can show a timeline of events for the document, who approved the document and when they approved it. Then we…
Power Automate approval comments can retrieved from an approval action and copied into a SharePoint list or document library. The tricky part is comments are stored inside of an array due to approvals having multiple potential approvers. We must convert…
The Power Automate select action can be used to do more than simply selecting the specified columns of an array. With it we can add new columns to an array, update existing values in an array, add an index number…
Power Automate approval flows can include attachments from Dataverse file columns file attachments. The approver is able to open the file and review it before choosing to approve or reject it. File columns and attachments lists must be handled different…
Power Automate approval flows can include attachments from SharePoint lists and document libraries. The approver is able to open the file and review it before choosing to approve or reject it. Document libraries and list attachments must be handled different…
Column level security in Dataverse allows app makers to restrict access to specific columns in a table while granting access others By creating a column security profile you can choose to give read, write or create permissions to the column.…
I built an app that builds Power Apps and the best part is it’s 100% freaking real. No, seriously! It generates Power Apps YAML code that you can copy and paste into Power Apps Studio. And it’s amazing. Absolutely no…
You can use a Power Automate flow to request manager approval in many different scenarios. There are two popular ways to determine a user’s manager. The Get Manager (V2) action can look for the user’s manager in the Office 365…