I had a task where I wanted to create a flow (power automate) that took a file uploaded in MS forms and copied it to a SharePoint document location. When you create a Upload file question there is a new folder that gets added...
Read MoreSometimes I find OneDrive actions in power automate to not work at all or take a long time to trigger. I have better luck using SharePoint actions for OneDrive and this post will explain how to do that. First go to your OneDrive...
Read MoreI ran into a scenario where I needed to populate a word document which could contain a varying number of images from the output. I found this great video which showed me how to create content controls in the word document to act...
Read MoreThis example will show a case where I want to run a reoccurring flow to go through a document library and any folder marked for Archiving it will move it and all files in the directory into a new document library If you want to...
Read MoreI wanted to make a flow that when a task was created the bucket name was appended to the end of the task name First create a new Automated Cloud Flow and use the trigger called When a new task is created Next create an action...
Read MoreIn 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 More
