Answered

Conditional statement doesn't find all of the records

(0) Share

Report

Posted on by ME-14102049-0

The values in the Status field are from a Choice list. If I check for "Reviewed" or "Cancelled" it finds the records but it doesn't find the records that have a value of "Submitted". Can someone suggest how to correct this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

David_MA 15,062 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Use an expression instead to evaluate if it returns true. This is more reliable than trying to use is equal to on a string.

This is the expression on the left, which you may need to revise based on your field: equals(items('Apply_to_each')?['Status/Value'],'Submitted')

Was this reply helpful? Yes No
ME-14102049-0 43 on at

Like
a
(0)

Report
Copy link

Link copied!

I just downloaded the output from the Get Items step. There aren't any records in the output that have a status of "Submitted". Is there a limit on the download of the output or does this seem like the source of the problem. Why would the records with a Status value of "Submitted" seem to be missing?

Was this reply helpful? Yes No
Verified answer

ME-14102049-0 43 on at

Like
a
(1)

Report
Copy link

Link copied!

I believe I found the issue. The Get Items step has a default limit of 100 items. I increased it to 4000 and now the conditional statements work because they are getting all of the records.

Was this reply helpful? Yes No