Filtering Get Item

(0) Share

Report

Posted on by thejdofva

Hi All

Creating a flow and using the following query:

"UnitLeaderApprovalDate eq null"

It works up to this part but I need to add a second part where it looks at the list column and if it contains the word "Reject", exclude it. I can't figure out how to do it.

TIA

All responses (1)

Answers (1)

Verified answer

v-yamao-msft on at

Like (0)

Report
Re: Filtering Get Item

Hi @thejdofva ,

To check if the list column contains the word “Reject”, I guess that you’ve already created a column for Reject/Approve selection.

If you would like to get items that Approval date is null and a column doesn’t contain Reject, please try with the following function:

Date eq null and Review_x0020_Status eq 'Approve'

Note: please use the extract column name in the function. generally, if there is a space in the column name, you should replace the space with “_x0020”.

The following configuration is working properly.

Best regards,

Mabel