web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter date query skip
Power Automate
Unanswered

Filter date query skip

(0) ShareShare
ReportReport
Posted on by 18

Hi, I am creating a flow which reads information from an excel sheet and places it inside the diary.

I have most of it working however one last little niggle I cant get my head round.

NiallOB01_0-1676897264590.png

In this attachment you can see that I am only skipping cells which have been diarised. 

 

However due to the way this document is I need it to ask skip if the excel data contains an invalid selection.

NiallOB01_1-1676897338708.png

 

 

Essentially if the column on the far right is blank then it should skip that whole row?

 

Is there a way round this?

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @NiallOB01 ,

     

    Do you want to add another filter to Filter Query? If so , I'm afraid that is not available , cause only 1 filter function can be applied on a column for list rows.

     

    vbofengmsft_0-1676946618418.png

     

    You could add a 'Filter array' action to filter the table.

     

    Best Regards,

    Bof

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 224 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 181 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard