Answered

Condition Failed

(0) Share

Report

Posted on by Nuiii

Hi Guys,

I have a problem with flow with a condition, the flow check the number of date that users selected (using switch) and then the flow check the Date in form with date+30 days, then if the condition is true create the event to users.

then I got failed on condition after every run.

see attached screenshot

Conditions 2.png

My expression code is

formatDateTime(items('Apply_to_each_2')?['End_x0020_Date'],'d/M/yyyy')

is equal to

addDays(utcNow(),30,'d/M/yyyy')

Thank you

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Nuiii

Can you post a screen shot of the actual error message that is generated?

Was this reply helpful? Yes No
Nuiii 65 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer

ActionConditionFailed. The execution of template action 'Condition' failed: an unexpected exception encountered when evaluating branching condition.

Thank you,

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Nuiii

I don't see anything obviously wrong.

Can you verify that you are referencing the end date column properly by doing the following:

Open a previous run from run history

Scan the output of the Get Items action for a reference to end date

Verify that the reference to end date looks like End_x0020_Date

On another note, your Flow would be more quicker and more efficient if you were to use a filetr query in Get items (OData filter) rather than a condition.

Was this reply helpful? Yes No
Nuiii 65 on at

Like (0)

Report
Copy link

Link copied!

Yes, the column is corrected

and the data from get items is corectted too,

by the way, thank you for your advice,

Nuiii

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Nuiii

Try this:

Remove the expression from the left side of your condition and reference the column directly from Dynamic properties

Change the date format in the right side of the condition to the following: yyyy-MM-dd

Please let me know if this helps.

Was this reply helpful? Yes No
Nuiii 65 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer

it's still failed on condition.

Was this reply helpful? Yes No
Nuiii 65 on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer

I just tried to change something in my flow,

I've removed the switch (control) out, then the condition working well.

I think maybe from that point.

Just let you know, if you have any information about that point please share.

Thank you.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Nuiii ,

Have you tried changing End_x0020_Date to EndDate?

Currently in Flow, if there is a space in the middle of the field name, you could ignore the space.

Also if you change the field name, you need to configure the expression with the initial field name.

Best Regards,

Was this reply helpful? Yes No
Nuiii 65 on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft

I've tried but not help,

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Nuiii

Have you tried using another Date field in the List to do similar tests?

Please try to recreate a similar Flow and change d/M/yyyy to yyyy-MM-dd and check if the issue still exists.

Best Regards,

Was this reply helpful? Yes No