Get items from list where "Start Date" date is today or in the future

[BenW1]

Hi all,

I'm trying to edit a flow I use for new starters joining the business. 

It is currently set to get all items from the SharePoint list, however I want to limit this to only items that in the date field, titled "Start Date", are either today or in the future, therefore excluding dates that have already passed. 

It then creates a HTML table and emails this out on a weekly occurrence. 

Any help appreciated!

[Pstork1 · Accepted solution]

Use an OData query like the following.  Make sure to add the single quotes around the formatted date and time.

StartDate ge 'formatDateTime(utcNow(),'MM/dd/yyyy')'

[BenW1]

Hi Pstork1,

Thanks for your suggestion. The query failed when testing the flow;

Any ideas?

[Pstork1]

The problem is the Space in the Start Date column name.  If you look at the column settings and scroll all the way to the end of teh address line you will see the actual field name, rather than the display name.  Its probably something like Start_x0020_Date