In Power Automate if you enter the dynamic content value from a lookup column typically you just get the GUID or if you select the dynamic value of a choice column you just get the ID number for that item. Here is an example...
Read MoreI am referring to these columns when creating an add row action in Power Automate: You don’t put the dynamic value of the related entity in there by itself. Instead you need a format like /entityset (keys) If you...
Read MoreGood website reference: https://sharepains.com/2018/08/28/sharepoint-rest-api-power-automate/ Rename a Folder You will need to know the following info: Site Address SharePoint Document List Name Folder Location Metadata Type...
Read MoreEntity location for Note Attachments is the annotation table which is called Notes in Power Automate Entity location for Email Attachments is the activitymimeattachment table with is call Attachments in Power Automate (The first...
Read MoreIn a flow I wanted to stamp the full name of the user that created a note in the beginning of a description like so: Below are the trigger outputs of interest: _createdby_value (Created By) _ownerid_value (Owner)...
Read MoreDescription 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 More
