Hi all,
Can someone help please?
I have a Power Automate flow which gets triggered when a new Excel file is added to a Sharepoint site.
In the next step, I have a 'List rows present in a table' action which reads the data from the Excel table.
But I don't want to list all the rows in the Excel table so I have a statement in the 'Filter Query' section which says to retrieve only data for a certain date.
This is where the problem is: in Excel, the column name is [Date] but when I write that in the 'Filter Query' section, it doesn't accept [Date] as a valid column name.
I've tried the following but to no avail: Date, _Date_, _Date, _[Date]_
I'm thinking I may need the internal name in Excel for the column named [Date] (like using the schema name of a Dataverse table) but I don't know how to find that.
Can someone suggest anything please?
Here's what the Excel table looks like:
And here's the 'List rows present in a table' action in my flow - the statement in the 'Filter Query' section doesn't work!!
4
Share
Report
All responses (
Answers (
