The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
Our Chicago sales team exports web orders into a SharePoint list, and every order ID arrives padded like [ORD-2026-10-4471] . Their lookup flow kept returning nothing, because a bracket and two spaces don’t match a clean ID. Power Automate has no single remove() function. You combine slice(), substring(), replace() and trim(), and one wrong index … Read more >>>
You pick a template or import a flow, sign in when asked, and Power Automate throws a long error with a GUID in it. Nothing gets saved, and the message doesn’t say which account or setting is wrong. In this tutorial, I’ll walk you through how to fix failed to create connection for connection id … Read more >>>
Megan Bowen manages our Boston, Chicago and Seattle offices, and she wanted an email every time someone logs a facilities request in SharePoint. That took me about five minutes, because the template gallery already has a flow for exactly that job. Power Automate templates are ready-made flows: the trigger, the actions and the connections are … Read more >>>
When Contoso moved its file shares to Microsoft 365, the first question from the project team was simple: “Which kind of SharePoint site do we create?” The marketing group wanted a place to publish news, the finance team wanted a private workspace, and IT wanted all the department sites tied together. Each of those needs … Read more >>>
Have you started working with the Power Automate OData filter query? In this tutorial, I have explained how to use the Power Automate filter query boolean value, especially an example of “Power Automate OData Filter Query Yes/No“. Quick answer: SharePoint stores a Yes/No column as 1 or 0, so in the Get items Filter Query … Read more >>>
Power Automate Get items action retrieves all the item information from a SharePoint list. It also allows you to filter items based on condition while retrieving items from the SharePoint list. In this Power Automate tutorial, I will explain how to get last & first item ID from SharePoint list in Power Automate. Moreover, we … Read more >>>
The Power Automate getPastTime() function returns the current UTC time minus a number of time units, for example getPastTime(7, ‘Day’) for exactly one week ago. It’s the quickest way to build “in the last 7 days” or “older than one year” conditions without first getting the current time. I use it mostly in SharePoint filter … Read more >>>
To count the rows in a SharePoint list with Power Automate, use Get items and wrap its output in length(), or read the list’s ItemCount property with Send an HTTP request to SharePoint. The first method can also count only the rows that match a filter, and the second is the fastest on big lists. … Read more >>>
The Power Automate getFutureTime() function returns the current UTC time plus a number of time units, for example getFutureTime(3, ‘Day’) for exactly three days from now. Use it to set due dates, expiry dates and reminder windows without getting the current time first. In my projects, it fills the Due Date of new Contoso support … Read more >>>
To upload a file from Power Apps to a SharePoint document library, let users pick the file with an Attachments control and send it to a Power Automate flow that runs the SharePoint Create file action. Power Apps can’t write files to a library on its own, because a library isn’t a list with an … 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