Filter records in Get item function

(0) Share

Report

Posted on by ajithd6368

496

Dear Experts ,,

i'm extracting data from ULDDetails1 list using below Get Items function .. There is a field(ULDStandardFlag) in ULDDetails1 . I just want to filter records if the ULDStandardFlag is empty .. Would you pls help me to write a filter expression .

rgds

Categories:

General topics

All responses (5)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ajithd6368,

Do you want to filter records including empty ULDStandardFlag field?

Could you please tell me the column type of the ULDStandardFlag field?

Please check the flow as below:

ULDStandardFlag eq null

Here is the result:
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,
ULDStandardFlag is a string .. and i get below screen when i use ULDStandardFlag eq null .. Its prompting for some inputs .. pls advice

rgds
Ajith
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry , pls ignore the above error message ..

Can we use length function here .. its also a requirement to check the length whether it greater than 15
I tried this way .

but it gives me a message "The expression is invalid" .. would you pls help me on this

rgds
AD
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ajithd6368,

Actually, in my first reply, I have added a Compose to test this length() function.

However, you could not use the length() in the filter query from the Get items action, you could only add a Compose or condition, and write the length() in the expression tab.

Here is a simple demo:
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi ,

Sorry for late response , not in the country for couple of days .. Yes it worked fine
Thanks for ur help
rgds
AD