Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Check dates in multipl...
Power Automate - Building Flows
Unanswered

Check dates in multiple columns

(0) ShareShare
ReportReport
Posted on by viktorklingberg 7

Hello,

 

We've a sharepoint list with our staff and some other information.

Our staff get qualifications with a expiry date and we've a hard time keeping track to rescheduling them for a new training.

I would like to add a date-column for each qualification and put in the expiry date and use Flow to send a email to remind us to book that particular training for the specific person.

We will need somewhere between 20 and 30 diffrent colums and probably add more columns in the future why I would like a very adaptable Flow.

 

All other Flow solutions I've seen uses several conditions to check the dates on each specific column.

Is it possible to have a flow that check all columns in one go? or does anyone have a good suggestions to solve this?

 

Thank you!

Regards,

Viktor

  • Sua Profile Picture
    Sua 5 on at
    Re: Check dates in multiple columns

    I have the exact same scenario I am trying to find a solution for. Had there been any further ideas or MS capability to address this problem? 

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Check dates in multiple columns

    Hi @viktorklingberg ,

     

    As far as I know, there seems to be no way to get the column in the list through Flow. I am afraid we really need to edit Filter Query when adding a new column.

    This does not seem to be automated.

     

    Best Regards,

  • dbro Profile Picture
    dbro 194 on at
    Re: Check dates in multiple columns

    @viktorklingberg ,

     

    I would first try to set up a list view using or statements.  For example:

    'YourDateColumn' = Today 

    or

    'YourDateColumn2' = Today

    or

    'YourDateColumn3' = Today

     

    Etc, etc.  Then create an alert on your view to send you an email anytime an new item is added.  The benefit of doing it this way is you just need to edit your list view when you add or remove an item instead of your odata parameters in the flow.  You may need to create 2 different views if you have 20-30 date columns.

  • viktorklingberg Profile Picture
    viktorklingberg 7 on at
    Re: Check dates in multiple columns

    Hello @v-bacao-msft,

    Thanks for your reply.

     

    That'll work. But then I'll have to edit the filter query each time we add a column in the sharepoint list.

    Is there no way to filter something like this: "All columns except [created date] and [edit date] le utcNow()" ?

    That way it doesn't matter what we do in the sharepoint list, the flow will always remind us.

     

    Regards,

    Viktor

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Check dates in multiple columns

    Hi @viktorklingberg ,

     

    Please try to use 'and' in Filter Query to check the values of multiple date fields.

    Image reference:

    31.PNG

     

    Best Regards,

  • viktorklingberg Profile Picture
    viktorklingberg 7 on at
    Re: Check dates in multiple columns

    Hi @dbro,

    Thanks for your reply!

     

    1.) That could work. But I would need to set a new alert for each new column, right?

     

    2.) Sounds interesting! I would want the alert maybe 30 days before the expiry date, but that's not a problem.

    Can i do a odata filter on all columns? I thought i needed to choose one column to filter.. How would that code look like?

     

    Thanks!

  • dbro Profile Picture
    dbro 194 on at
    Re: Check dates in multiple columns

    Hi @viktorklingberg ,

     

    Couple of thoughts:

    1.) could you use an out of the box alert?  For example could you create a view that shows all items where Expiry Date equals today or Date2 equals Today or Date3 equals today?  Then you can set an alert to you and your team any time a new item gets added to that view.

     

    2. Using the FLOW mechanism you could use an odata filter on the get items action to show you all items where your expiry column equals today. then you could do a for each loop and send email action.  I think for this to work your email would have to be generic and link to the sharepoint item and not include the column date in the body as you wouldn't know which column to include without doing a conditional check that you're trying to avoid.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans