'For_each' contains an invalid expression - but I got the expression from Dynamic Content

(1) Share

Report

Posted on by jorgy556

I am really at my wits end here.

My flow was working, but I had to adjust some date values so that an empty field would stop inputting today's date.

Now when I try to save the flow, I get an error message saying "The input parameter(s) of operation 'For_each' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'For_each'."

Problem is, I got the expression from Dynamic Content, and nothing in the 'For_each' flow was changed.

Flow check shows no errors as well:

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

wskinnermctc 6,519 Moderator on at

Like (1)

Report
Copy link

Link copied!
~~Delete all of the steps, including the trigger, and recreate the flow. It will remove the need for a For Each.~~

~~Don't make a new flow, just delete the trigger and re-add it.~~

You can't initialize a variable inside of an apply to each. I don't know how it let you do that in the first place.

How about this since you already made the variables.

Delete Create Item

Clear the initialize variable fields, so that they aren't referencing anything.

Move the initialize variable actions outside of the For Each.

Delete get response details

Delete the trigger

Re-add the trigger

Re-add get response details

Now refill the variable fields

Re-add Create Item

Was this reply helpful? Yes No
jorgy556 7 on at

Like (0)

Report
Copy link

Link copied!

Ah, yeah, that seemed to do it.

However, I'm now running into this error:

"OpenApiOperationParameterTypeConversionFailed
The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/PurchaseDate' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'."

I have the Dynamic parameter set to: "
item/PurchaseDate": "@{body('Get_response_details')?['r798aa527047d4848a55f37d494327b23']}",

Do I need a function in there too?

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!
That is happening because you are using a form response that is a text string and it is "" empty/blank. You can't put a blank "" into a date field.

So you need to use an expression to check the value and see if it is empty/blank, and if so use null, else use the form response.

I don't know exactly the expression to use since I don't want to make a form and test it. But it will be something like one of these below.

If the form response is empty, then put null, else use the form response:

if(empty(trim(body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])),null,body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])

If the form response equals null, then put null, else use the form response:

if(equals(trim(body('Get_response_details')?['r798aa527047d4848a55f37d494327b23']),null),null,body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])

If the form response is equal to '' blank, then put null, else use the form response:

if(equals(trim(body('Get_response_details')?['r798aa527047d4848a55f37d494327b23']),''),null,body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])

If the length (number of characters) of the form response is equal to 0 zero, then put null, else use the form response:

if(equals(length(trim(body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])),int(0)),null,body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])

The last one should work for sure, but it has the most extra functions. The trim() function in all of the expressions is to remove any leading or trailing spaces, sometimes that helps clear a blank value.

Try these until one of them works. If none of them work, you could also try using '' instead of null and see if that helps. So it would be if the form response is empty then '' , else form response.

If the form response is empty, then put '', else use the form response:

if(empty(trim(body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])),'',body('Get_response_details')?['r798aa527047d4848a55f37d494327b23'])

See if one of those works for you.

Was this reply helpful? Yes No
jorgy556 7 on at

Like (0)

Report
Copy link

Link copied!

Hmm, alright, I seemed to have worked that detail out; but now it's just putting 01/25/2024 into the column for every entry; instead of blank if the response is left blank. None of the above expressions worked, I kept getting the same error; so I'm not sure if I'm doing something wrong with my PurchaseDate variable?

Also, do you know how to get the Submission Time other date/time fields to go into local time zone at all?

Was this reply helpful? Yes No