Power Platform Community Forum Thread Details

I created an automated flow that is triggered when a requester makes updates to 1 or more entries in their request which sends an email to the request reviewer and includes a table with the values of the original request and values of the updated request.

Below is my flow with the following error message

Categories:

Building flows

All of the actions in your flow are for a single item. The Select action is designed to work with the Get items or Get files (plural) actions. If you are trying to use it on your HTTP request, I think first you will need to use a Parse JSON action to get values. You look like you're doing something I am working on:

If you don't know how to generate the scheme, run the flow and then open the run and copy the body of the output of the HTTP request to use as sample data to create the scheme. This is where problems often occur when the HTTP request doesn't always return the same data every time because you have fields in the list that are not required. You can then manually update the type to allow for null values as shown above. However, I would also recommend updating the Uri of the HTTP request to specify just the fields you need to make this much easier.

You can get the values out of the parse JSON with this type of expression: body('Parse_JSON')?['value'][0]?['YourField']