Answered

condition choice value comparison not working

(0) Share

Report

Posted on by xianng88

I have a transport list to keep track "CheckedIn" "CheckedOut" of transport.

Every 6pm the flow will be triggered and if any of the transport with a Choice Option of "CheckedOut" in the list, flow will be triggered to send an email to users.
However in Flow the result always returns False.

Here is the setup of the flow:

Before the condition check steps, i used Recurrence and Get Item.

1) Previously i used "Checked Out" with a space, changed to "CheckedOut" still not working.

2) I have used "Transport Status Value" for dynamic content as per advised. Not working.
3) I have used string('CheckedOut') in the right column as well and it is not working.

I'm out of ideas.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @xianng88 ,

It could be a capitalization issue or have extra spaces.

Best Regards,

Wearsky

Was this reply helpful? Yes No
xianng88 19 on at

Like (0)

Report
Copy link

Link copied!

Got this error:
Is this correct?
replace(toLower(items('Apply_to_each')?['Test/Value']),' ','') <<< for left
concat('CheckedOut') <<< for right

btw, the column name is "Transport Status", choices are "Checked In", "Checked Out".

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

Like (0)

Report
Copy link

Link copied!

Hi @xianng88 ,

'Test' is my choice column name.

Please use your column name instead.

Best Regards,

Wearsky

Was this reply helpful? Yes No
xianng88 19 on at

Like (0)

Report
Copy link

Link copied!

Same error:
replace(toLower(items('Apply_to_each')?['Transport Status/Value']),' ','')

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

Like (0)

Report
Copy link

Link copied!

Hi @xianng88 ,

There is none space in actual name.

Best Regards,

Wearsky

Was this reply helpful? Yes No
xianng88 19 on at

Like (0)

Report
Copy link

Link copied!

same error 😵

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

Like (0)

Report
Copy link

Link copied!

Hi @xianng88 ,

What's the actual name of the column? Please use the dynamic content and move the cursor over the parameter.

Was this reply helpful? Yes No
xianng88 19 on at

Like (0)

Report
Copy link

Link copied!

Dynamic Content here:
I change
replace(toLower(items('Apply_to_each')?['Transport Status/Value']),' ','')
to
replace(toLower(items('Apply_to_each')?['Status/Value']),' ','')
and still get the error but it ran

In the composed steps, all the input results are "Checked In", but I have 1 row with "Checked Out" value.

Was this reply helpful? Yes No
xianng88 19 on at

Like (0)

Report
Copy link

Link copied!

Any workaround on my case?

Was this reply helpful? Yes No
Verified answer

xianng88 19 on at

Like (0)

Report
Copy link

Link copied!

Found out the issue is not with the Value Return but with the "Get Items" limit threshold of 100 items.
Solve it by expanding this limit.
How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” actions – NateChamberlain.com

Was this reply helpful? Yes No