Filtering Get Item

Like (0) Share

Report

Posted on 27 Feb 2019 17:01:07 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

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yamao-msft on 28 Feb 2019 at 05:19:34

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

Was this reply helpful? Yes No