Description When a new customer is created in CRM this flow will automatically create the document folder structure on SharePoint AND create a relationship to the document location. Sub folders in CRM was tricky to understand...
Read MoreHere is an example of a long if expression: if(equals(variables(‘SaleMonth’), 01), ‘January’, if(equals(variables(‘SaleMonth’), 02), ‘February’,...
Read MoreExample of a long replace function: replace(replace(replace(replace(‘[{“Value”:”Maintenance/Warranty”},{“Value”:”Product”},{“Value”:”Other...
Read MoreThis expression will find the difference between two dates: div(sub(ticks(‘2019-05-13’),ticks(‘2019-05-04’)),864000000000) The date areas above can be dynamic content as well like so:...
Read MoreFlow when a SharePoint Column is updated
Read MoreTesting this soon: https://powerusers.microsoft.com/t5/General-Power-Automate/microsoft-flow-get-all-items-with-distinct-Assigned-to-User-and/td-p/113348
Read MoreI always think of using trim when I want to do this action but you don’t use trim you use substring to remove characters from a string like so: substring(‘hello world’, 6, 5)...
Read MoreI wanted to create an instant flow triggered by a SharePoint item. When executing the flow the following inputs show up asking for information: Task Due Date Assigned By Assigned To Notes When you click run it then will update a...
Read MoreI will be explaining how to automate adding a task to a certain bucket in planner with power automate High view look at the flow: The first part List buckets is pretty simply you need to select the group Id and plan Id you are...
Read MoreSome great examples on how to use the filter query option in Sharepoint Power Automate: Every Power Automate (MS Flow) Filter Query You Ever Wanted To Know As A...
Read MoreGreat info on using the Microsoft Graph Rest APi to interact with Office365 apps like planner, tasks, ect. https://docs.microsoft.com/en-us/graph/api/resources/planner-overview?view=graph-rest-1.0 Get to know the api...
Read MoreThis looks really cool and I want to try it very soon: Create a Microsoft Graph JSON Batch Custom Connector for Power Automate https://docs.microsoft.com/en-us/graph/tutorials/power-automate
Read More
