{"id":776,"date":"2019-02-06T09:18:26","date_gmt":"2019-02-06T17:18:26","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/build-more-powerful-conditions-in-flows-and-more\/"},"modified":"2019-02-06T09:18:26","modified_gmt":"2019-02-06T17:18:26","slug":"build-more-powerful-conditions-in-flows-and-more","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/build-more-powerful-conditions-in-flows-and-more\/","title":{"rendered":"Build more powerful conditions in flows and more"},"content":{"rendered":"
It’s now easier than ever to write conditional logic in Microsoft Flow by using the new advanced condition builder. Previously, you could write complex conditions using expressions, but now it’s possible to build conditions with the Microsoft Flow designer’s simple point-and-click UI.<\/p>\n
<\/p>\n
You can add a condition to your flow by selecting New step<\/strong> and then the first action available to you: Condition<\/strong>. There is a new Add<\/strong> button that you can select that presents two options:<\/p>\n <\/p>\n You can have however many rows or groups you need to build out your logic, and can continue adding rows (or groups) both at the top level of the condition, and inside groups using their Add<\/strong> buttons. If you want a simplified view of the condition there is a button at the top-right of each group to collapse<\/em> it.<\/p>\n Additionally, there is a Sometimes, there may be an expression that is more complex than what you want to model in even the advanced condition builder. Previously, you could select Edit in advanced mode<\/strong> and then enter the expressions in a text box. However, this old mode was difficult to work with as it did not give you access to IntelliSense for expressions or Dynamic content. There is no longer an Edit in advanced mode<\/strong> – instead if you want a very complex expression you can use the regular Dynamic Content expression builder to enter your expression on the left side of the row. Then, select Equals to<\/strong> and enter <\/p>\n The advanced condition builder is available for all new conditions that you add to your flows. It will not be enabled for existing conditions, so if you would like to use it with existing flows you will need to add a new step and drag the actions from the old condition to the new condition.<\/p>\n Personal productivity is essential to teamwork. SharePoint lists and libraries have long allowed to you defined custom metadata columns to track dates. We now are releasing a new capability that lets you set reminders for any of these dates. You\u2019ll be able to receive a personal email alert To create the reminder flow, your list or library should have at least one date\/time column in the current view. You\u2019ll then able to create a reminder by selecting the Flow -> Set a reminder<\/em> menu item.<\/p>\n <\/p>\n You can enter the number of days in advance for the reminder, based on the selected date column.<\/p>\n <\/p>\n Based on your selection, you\u2019ll get an email from Microsoft Flow for any items or documents <\/p>\n Once the flow is created, it can be edited from the Microsoft Flow portal. You can modify days in advance<\/strong>, or add additional actions. Read more about this feature in the SharePoint documentation<\/a>.<\/p>\n If you have a large action with a many different inputs, sometimes it can be difficult to understand exactly what will be sent to the Connector from your flow. We have added a new Peek code<\/strong> option in the <\/p>\n When you select this option you will see the full JSON representation of that action. This includes all of the inputs to the action, such as the text you entered directly, and expressions used. For example, you can select expressions here and paste them into the Dynamic Content expression editor. This can also give you a way to verify that exactly the data you expect is present in the flow.<\/p>\n <\/p>\n Simply select Done<\/strong> at the bottom of the action to return to the normal action view.<\/p>\n This week there are two new connectors available:<\/p>\n Use a new advanced condition builder to have conditional logic based on And \/ Or statements in a flow. Peek into the JSON code of actions in the Microsoft Flow designer. There is a new feature built-in to SharePoint: if a list or library has a date\/time column, Microsoft Flow can be used to set up alerts based on upcoming dates. Finally, there are two new connectors: Microsoft Graph Security and XooaDB.<\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2752],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-776","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates"],"yoast_head":"\n\n
Test<\/code>) creates a new row<\/em> in the condition builder.<\/li>\n
...<\/code> menu at the right side of each row and group. This contains options for moving rows up or down (which can move them in and out of groups), and an option to Delete<\/strong> a row or group. Also, there are checkboxes on the left side of each row or group. This allows you to select several different rows, and then select Group<\/strong> from the
...<\/code> menu at the right to combine the rows into a single group.<\/p>\n
true<\/code> in the right side.<\/p>\n
SharePoint Remind Me<\/h2>\n
x<\/code> days in advance of a date on any document or item in SharePoint.<\/p>\n
x<\/code> days in advance of the selected data column value.<\/p>\n
Peek code in the Microsoft Flow designer<\/h2>\n
...<\/code> menu of all triggers and actions in the Flow designer.<\/p>\n
Two new connectors<\/h2>\n
\n