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.
Forms are much quicker to fill in when the obvious values are already there: today’s date, the current user, the usual department. In Power Apps, you set these defaults on the data cards of the form. Quick answer: Select the control inside the data card and change its default property to If(Form1.Mode = FormMode.New, <default … Read more >>>
A client of mine tracks Power Platform training in a SharePoint list. Every time an employee enrolls in a course, the HR team used to paste the link to the course material by hand. We automated it: a flow now builds the right link for the selected course and saves it in the list. Quick … Read more >>>
When you build business solutions with SharePoint lists, you soon need to connect lists instead of typing the same data again and again. A lookup column does exactly that: it lets you pick a customer, product or project from another list, and it can show extra details from that list automatically. Quick answer: Open the … Read more >>>
Splitting text is something I do in almost every flow: email addresses separated by semicolons, a comma-separated list from Microsoft Forms, lines from an email body, or a file name and its extension. In Power Automate, the tool for all of this is the split() function. Quick answer: split(‘text’, ‘delimiter’) returns an array of the … Read more >>>
You build a table of sales by region, and some regions are simply missing. They’re not wrong; they just had no sales, so Power BI left them out. The same thing happens with months that had no orders on a column chart. Quick answer: Select the visual, go to the Build visual tab, open the … Read more >>>
You add a Get items action to a flow, point it at a SharePoint list with hundreds of items, and the flow only processes 100 of them. No error, no warning. It’s one of the most common surprises in Power Automate. Quick answer: Get items returns 100 items by default. To get up to 5,000, … Read more >>>
“Unable to process template language expressions” is one of the most common Power Automate errors, and it looks scary. The good news: the second half of the message always tells you exactly what went wrong. Quick answer: An expression in the action got a value of the wrong type, or no value at all (null). … Read more >>>
I built a simple flow for a SharePoint list: when a new item is created, send an email to the person in the Approver column. The flow failed on the first test run with OpenApiOperationParameterTypeConversionFailed and this message: Quick answer: The To, CC or BCC field received something that isn’t a valid email address: an … Read more >>>
A site member tried to share a meeting recording with a colleague and got this message instead of the usual share box: “Sharing is limited on this item. You can only copy links for people who have existing access and you can’t invite anyone new.” The dialog title changes to Ask owner to share, and … Read more >>>
Free guide
A practical, step-by-step blueprint to build a project management system in SharePoint Online. Tell me where to send it.
Your free SharePoint Project Management Guide is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to
