You’re offline. This is a read only version of the page.
Announcements
64
My goal is to filter an Excel file by month and then saving the months in their own file. So all months beginning with 10 will be saved together in an October file.
I have initialized a CurrentMonth and CurrentYear variable. They are strings. These are working currently.
I'm trying to filter an array. The column is called EndProductionTime. It's text in the format of "mm/dd/yyyy hh:mm:ss". I'm trying to filter EndProductionTime by if it is equal to CurrentMonth. The inputs are correct, but the output is always empty [].
Can you please help me with the expression to put in the highlighted box below? Any insight is appreciated.
Hi @pgd
Pls try below query in filter array action. Click on "Edit in advanced mode" and then write the query in the textbox:
Share
Report
All responses (
Answers (
@equals(formatDateTime(item()?['EndProductionTime'], 'MM'), variables('CurrentMonth'))
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
