cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Resident Rockstar
Resident Rockstar

Re: Filter Array with Excel

@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
Highlighted
Resident Rockstar
Resident Rockstar

Re: Filter Array with Excel

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!


Highlighted
Helper III
Helper III

Re: Filter Array with Excel

Thanks

Screenshot as requested.

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

 

Capture.PNG

Highlighted
Resident Rockstar
Resident Rockstar

Re: Filter Array with Excel

@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

Highlighted
Helper III
Helper III

Re: Filter Array with Excel

Perfect, thank you!

Highlighted
Resident Rockstar
Resident Rockstar

Re: Filter Array with Excel

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
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (9,257)