Many organizations are using Power Automate to automate their business processes. As a Power Platform developer, you should have expertise in Microsoft Power Automate. Learn Power Automate from our list of helpful and practically implemented tutorials. Feel free to contact us if you still have any questions and doubts.
Recently, while working on a Leave Management Application for one of our clients, I came across a requirement to automatically save responses from Microsoft Forms to a SharePoint list. I have faced an issue while saving multiple checkbox values to SharePoint multiple-choice values; it stores the values in the form of an array [“Parental Leave,” … Read more >>>
After every internal training session, our training coordinator sent a feedback form built in Microsoft Forms. The responses piled up in Forms, but nobody saw them until the end of the month. Attendees wanted to know their feedback had arrived, and trainers wanted to hear it while the session was still fresh. A short Power … Read more >>>
Alex Wilber wanted his weekly Contoso order email to say “Regions with orders: East, West, Central, South”. His flow already had the regions in an array, but when he dropped the array into the email body, the message showed brackets and quotes: [“East”,”West”,”Central”,”South”]. That’s the moment you need to convert an array to a string … Read more >>>
Megan Bowen runs the order desk at Contoso. Every Monday she wants a short email that lists which sales regions had orders that week. The orders live in a SharePoint list, so the region column has East, West, East, Central, West and so on. She only wants each region once. In this post, I’ll show … Read more >>>
I hit this one while building a flow that matches incoming emails to rows in a Dataverse table called IT Issue Resolutions. The List rows action had a simple filter on the Sender column, yet every run stopped with “Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’”. The column clearly exists, so the … Read more >>>
![Power Automate Trim customer name Compose in code view with @trim(triggerBody()?['text']) as input](https://www.enjoysharepoint.com/wp-content/uploads/2026/11/power-automate-trim-compose-code-view.png "power automate trim compose code view")
Text that people type is rarely clean. A customer name copied from an email arrives as ” Megan Bowen “, and suddenly your Condition says it doesn’t match “Megan Bowen” in the SharePoint list. The Power Automate trim() function fixes that by removing the extra spaces at the start and end of a string. In … Read more >>>
A sales coordinator at Contoso kept finding the same order twice in her Excel tracker. Her flow added a new row every time an order came in, even when the order was already there. The fix is to check if a row exists in Excel with Power Automate first, then either update that row or … Read more >>>
A support team at Contoso asked me for a simple rule: if a customer’s remarks mention a refund, send the request to Billing, otherwise send it to Support. That’s a classic Power Automate condition that checks whether a string contains a value, and it’s easy to get slightly wrong. The catch is case. A customer … Read more >>>
The Power Automate chunk() function cuts a string or an array into pieces of the length you choose, and returns them as an array. To split an 18-character activation code into blocks of four, put this in a Compose action: It returns [“M7Q2″,”K9X4″,”P8R3″,”T6W1″,”B5”]. The last piece holds whatever is left over, so it can be … Read more >>>
Say you’re automating web orders for a Chicago outdoor store, and every order ID looks like ORD-2026-10-4471-CHI. You need the year, the month, the order number and the store code in separate columns, and the substring() expression pulls each piece out by position. In this tutorial, I’ll show you how to use the power automate … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to