Forum Discussion

Iron Contributor

Sep 17, 2020

Compare excel data with actual date in Power Automate

I have a list of all upcoming Teams live events with date and time within an excel sheet. The idea is to compare the current date with the ones in the excel sheet and if there is a schedule...

Microsoft Flow

Power Automate

stormin_30

MVP

Sep 19, 2020

Hi Thomsch,

Add an OData filter to the Excel "List rows present in a table" action to find events that are occurring today.

Here is the expression:

div(sub(ticks(utcNow('yyyy-MM-dd')),ticks('1899-12-30T00:00:00')),864000000000)

Important: there are single quotes (' ') around the expression.

I hope this helps.

Norm

Thomsch
Iron Contributor
Sep 22, 2020
stormin_30 thanks. This helps me out a lot!

I actually have two appointments each Tuesday. And the meeting link is different for both of them.
How would you proceed to check which one of the meetings is the right one for the link to change.
- stormin_30
  MVP
  Sep 22, 2020
  Hi Thomsch,
  
  You will need something to further filter or connect the meeting to the link. Perhaps a unique meeting name? I don't think ID, Date and URL are enough.
  
  I hope this helps.
  
  Norm
  - Thomsch
    Iron Contributor
    Sep 22, 2020
    stormin_30 Would it be possible to look for the next/nearest meeting regarding time?

Forum Discussion

Compare excel data with actual date in Power Automate

Share

Resources