I know it's been a while since you posted, but for anyone seeking how to do this in the future:
Do the following:
In your excel spreadsheet:
First, update the dates in your "Date" column the actual date of the meeting.
In your flow:
Trigger: Recurrence -Set to daily and choose the time you want the invite sent. (Don't worry, it will only send 2 weeks before the meeting dates listed, FOR the meeting dates listed)
Action: Get Future Time: Set to 2 weeks (or 14 days/whenever)
Action: Substring
Sub Text: Get Future Time
Sub Starting: 0
Sub Length: 10 (Time in excel is weird, this makes sure it reads your date as you intend it with Month, day and year. Excel can read this in any order so long as you 'label' your date column as a date).
Action: List rows present in table choose your application, Sharepoint or One Drive for Business
Click Advanced Options:
Filter Query: enter, Date eq 'Substring' (include single quotes/apostrophes and add substring using dynamic content. A box will either pop up on the right or you will have to scroll down and it will appear below- depends on your window size). This is how your flow will know what for which dates to send the invite two weeks before.
Action: create event (Choose your application, outlook, or microsoft 365)
Fill in your meeting information. Click advanced for more options.
Let me know if you (or future people) have any questions!
Errors:
You're missing the "start_time" and "end_time" for your meeting. Add these to your excel spreadsheet. These should be two separate columns. For ease, label them as "Text" (opposed to formula, date, etc). The meeting invite action will ask for this first thing.
If this is helpful, please upvote. This is my first reply!
