Format your data with examples is a feature available in the cloud flow builder of Power Automate. It simplifies flow building experience by reducing the need for you to write your own expressions from scratch.

Screenshot of providing examples of date value in Power Automate

If you want to change how data is returned in your flow, typically you would need to write an expression- which can be complex and time consuming. With format your data with examples, you don’t need to be an expert on expressions. Now, as you provide examples of how you want the data returned, Power Automate will generate the expression for you.

An example of this might be if you need to change how a date value is returned. Let’s say you’ve trained an AI Builder model to extract information from a form. One of the fields is a date, and on the form the date is written in the format of DD/MM/YYYY.

Screenshot of how a date may appear on a form
Screenshot of how a date may appear on a form

You want to build a flow that will extract this date from the form, and add it to Dataverse. In order to store a date value in Dataverse/Dynamics 365, it needs to be in the US date format, with month before day (e.g. MM/DD/YYYY). Without formatting the date to match this format first, you will receive an error.

In your flow, click on the Expression tab and select Format data by examples.

Screenshot of finding Format data by examples in Power Automate
Screenshot of finding Format data by examples in Power Automate

Select the value you want to convert. In this case, it is the date value extracted from an AI Builder model, called Filed Date value. Then, provide examples of what the extracted date would look like VS what it should look like in order to be compatible with a Dataverse date column.

Screenshot of providing examples of date value in Power Automate
Screenshot of providing examples of date value in Power Automate

After you’ve provided a few examples, click Get expression. You’ll then have an expression generated for you and ready to use. Click Apply, and it will be added to your flow.

Screenshot of the generated expression
Screenshot of the generated expression

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s