In Microsoft Dynamics 365 I needed to get a list of member’s email addresses in a team. To do this I had to use Fetch XML Query on a List Rows Action in Power Automate. First I created a compose action to get the owner ID...
Read MoreI created an instant flow and set an input field to optional however anytime it was left blank I would get the following error: InvalidTemplate. Unable to process template language expressions in action ‘Compose_3’...
Read MoreOn an instant flow I added a File input and named it PDF File (we only use PDFs but the code explained below will dynamically grab any extension of a file uploaded) Next I created a compose action and entered the following...
Read MoreThere seems to be a little trick needed to filter CRM 365 ID GUIDs when using OData style filter expressions in the filter rows field In my example I will use the CRM Orders entity and I am trying to get the following list of...
Read MoreScenario Two onsite installation teams are working on a project at different locations and they need to fill out daily reports An excel sheet has been shared to each team supervisor for filling out the daily report from a...
Read MoreThis example will show you how to assign an item in a SharePoint list to someone. When that is done it will send them an email with the item information to the user AND update the item in the list to the assigned user The...
Read MoreThis walk through will show you how to set a certain label to a task in planner depending on how a question was answered in Microsoft Forms This example with have a question called project value with the following options:...
Read MoreLet’s say you get emailed a random daily automated report between 3am-11am and you want to be alerted if you did NOT receive that email In my example my daily report always has this specific email subject: Daily Automated...
Read MoreIn this example I want to be emailed ANY time a file called Technical.txt is modified in a folder called Documents/Backup First I will create an automated flow with the following trigger: When a file is created or modified in a...
Read MoreThese were very good videos on how to extract complex nested JSON elements...
Read MoreIn 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. THIS CAN ONLY WORK ON...
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 More
