the new updated power automate Cloud flow designer is now generally available which means when we create a new Cloud flow we will begin with the new designer.
Experience in make. powermate.com on the home screen we have the co-pilot experience where we can simply describe in detail the automation that we are trying to build and co-pilot will.
Suggest a power automate flow for us that we can select and we will land in the new designer experience or we can go to create and create a flow from scratch when we start.
From blank we can pick the trigger for our workflow for the demo I will pick an instant Cloud flow and I will select manually trigger.
Overdue and send it out in an email the flow will be triggered manually to name the flow flow top left simply click and provide a name to the flow the center area is the canvas I can.
Select move around the canvas I can zoom in zoom out or fit view to add an action we simply click plus and say add an action directly sets the focus we can see all the top used.
Actions I'm trying to query a SharePoint list so I can simply search for SharePoint here is the SharePoint connector I can see the top three actions here can also click see more.
This will list out all the actions related to that specific connector I'm trying to get items from a SharePoint list so I will select get items my SharePoint site.
Address I'll select my SharePoint list name I'll search for issue the name of my list is a show tracker so I'll select it these were the two required properties for this specific.
- How To Create Your Own Tournament Generator With Leaderboard In Excel Free Download + Masterclass
- DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions Office
- How To Create BMR Calculator Using HTML, CSS & JavaScript Part 1 BlogSpot
Action actions and flow can have - ID Card Make
Additional Advanced parameters if I open this drop down I can pick and choose those parameters or I can simply click show.All to list out all those options I will add my o data filter query which is status equal to in single quotes in progress I need to add another condition to this that's an and.
Condition due date less than here I would like to put today's date and time and for that I need to write an expression to get to the.
Expression here we have FX that's the insert expression action simply selected here is the expression box I can increase its height or I can also go full screen.
Mode here I can simply type my Expressions we've got the list of all the expression functions here there is also Dynamic content so if I want to pick any properties from.
Preceding actions I can easily pick it right here in this single expression box experience itself on the top we have a small info icon if you select that it will take us.
To the documentation for the expression functions for power automate in my case I need today's date and time notice as I start typing.
Intellisense will guide me through we have an expression function called UTC now that gives the current date and time I simply enter my expression click add and it will add that expression in.
The filter query property get items if I want to rename this I can simply click on its name and update the name of the action I can also go to the three.
Ellipses more commands
And I can add a note so this specific action notice it has a command and if I simply hover over it it will give me that.Command the link here is the connection for that specific connector that is being leveraged to delete the action I can simply select three ellipses and.
Delete I can close the properties panel next I would like to check if the item count that it's returned is greater than zero so I'll add another action condition under control here is.
The condition action I'll select it so here once again I'll go to expression I'll use the Expression function length off right in the expression editor.
Itself I can go to Dynamic content and pick the value Dynamic content property coming from the get items action I'll click add that adds the expression is this greater than the.
Value zero if true I would like to send an email and the email needs to include the items that I have captured in an HTML Table Fashion so I'll insert a new new.
Step in the true condition add an action here when you're adding actions there's also a drop down for runtime so if you pick builtin this will list out all the builtin actions that.
You can leverage I can pick standard which will list out all the standard licensed connectors I can pick premium this will list out all the premium licensed.
Connectors and if there are any custom connectors that built in this environment they would list up right here in my case search for the action HTML table and under the data operation.
Action here is the create HTML table action I will select this from I need to use Dynamic content the Thunderbolt symbol here if I select it it will open all the dynamic.
Content from expects an array the only array Dynamic content property that get items exposes is value additionally if I simply select forward slash it will open up those same.
Options for me so I want to insert Dynamic content I'll pick value here I have the advanced option for columns my columns I'll pick custom here.
I can Define my table header and the values that it will include my first header would be issue title and in the value I would like to pick the title column value from my.
SharePoint list Dynamic content and pick title I would like to show the priority the due date and assign to so prior priority priority value assign to I picked the display name and.
Due date once again I leveraged an expression to transform the due date in the specific format now I have the HTML table I also want to add some HTML styling so I'll.
Add another action I'll pick compose rename this to HTML style I have a style tag ready that I'll just plug in.
And right after this I would like to go ahead and send an email this email I'll send to myself subject would be overdue tasks.
Information and in the body I'll insert Dynamic content I'll pick my style the body has Rich Text enabled so I can add some additional Styles here.
I can select make it bold indent have different font options to choose from and right here I will go and insert the dynamic content output from my HTML.
Table action if I also want to add a link let's say a link to my SharePoint list I'll enter the text open list I'll select it click insert.
Link click edit type the URL save and this I will change its text color to Blue so that's a.
Link Advanced parameters or simply say show all so I can see all the properties that I can set let's say the importance of the email I'll set it to.
High now each action also has settings this is where you can Define the action timeout run after settings you can also go to code view to see the entire code associated with that.
Specific action you can also add static values for testing purposes and about will basically give you information about that specific.
Connector so this completes my flow I'll go ahead and click save so this will go and save my flow I can test the flow right here or if I click back this will take me to the.
Flow Details page from here if I click edit I'm back in the new flow designer experience I can test the flow right here I'll click.
Run the flow has triggered you can see all the actions that are executed you can also see how long each action has taken if I select the action will give.
Us all the details the inputs the outputs if I click show raw outputs I can see the entire output Json of the get items action my condition was true so it does.
Have records that are overdue and it's gone ahead and send the email here is the email that I have received here is the HTML table here are all the details of the tasks that are.
