cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Filter Array with Excel

I am trying to setup a condition for when I fillter an array returned from looking up data in an Excel table.

Can anyone tell me what the condition should say when applied to the filter array body if it is empty/null/blank/etc?

I.e. when nothing is returned.

 

I am using this to optionally set a variable that allows me to branch the flow later on.

i.e. if nothing is returned enter a new record, if something is returned update a record,

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions

@MartinHutchcpa Try this for your condition

Capture-073.png

If you, the reader has found this post helpful, please help the community by clicking thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

5 REPLIES 5
Resident Rockstar
Resident Rockstar

Hi @MartinHutchcpa

Generally speaking the use of the '?' in an expression allows null.

items('Apply_to_each')['date'] - doesn't allow null.

items('Apply_to_each')?['date'] - does allow null.

 

Can you please post some pictures and some detail of your condition and your Flow and I can advise in more detail?

 

If you, the reader has found this post helpful, please help the community by clicking thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Thanks

Screenshot as requested.

It is the condition I am having trouble with as this returns false every time.

 

Capture.PNG

@MartinHutchcpa Try this for your condition

Capture-073.png

If you, the reader has found this post helpful, please help the community by clicking thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Perfect, thank you!

You're welcome, I'm glad to be of assistance.


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,316)