Answered

Condition that looks for a specific field value in Get Item action

(0) Share

Report

Posted on by Melio

Sorry for the long title.

Hi there, I am trying to make a Condition that evaluate a specific field value in Get item, for example: Status is equal to "Present". So, if the value is null or "Present" then Create a new item otherwise stop.

Most solutions were using "@equals(length(body(‘Get_items’)?[‘value’]), 0)" in the condition which wasn't specific.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Brad_Groux 4,556 on at

Like (0)

Report

The condition would look something like this:
You would simply have the item is equal to Present or the item is equal to null expression. To add the second condition item, click the +Add button and choose Add row. And change the And condition to an Or via the dropdown.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Melio 14 on at

Like (0)

Report

Thank you for your help. Sorry, I meant to say "Get items" with "s."

The output of SP "Get items" is a big chunk of data of all items. But, I need the condition to look for specific fields in that output all the items. Let's say 3 items out of 10 contain Status "Present, " Flow should then copy them to the second SP.

Was this reply helpful? Yes No
Verified answer

Brad_Groux 4,556 on at

Like (1)

Report

If you add a condition after a Get items (or any multiple item action, like Get files or Get rows), Flow will automatically create an apply to each each loop. I just created this, and as soon as I added a parameter to the condition, it automatically created the Apply to each while nesting the condition automatically:
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No