Manually triger of follow - enter month and year

(0) Share

Report

Posted on by Sbsyx

113

Hello,

I need a flow in which the month and year are entered in the trigger, e.g. "September 2023" and then this information from the manual trigger is downloaded to "filter table" and only data from August 2023 is returned to me. I have the entire flow created, I only need the conversion expression text from the trigger to the date format yyyy-MM. There is a possibility?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report
formatDateTime( parseDateTime( 'September 2023', 'en-us' ), 'yyyy-MM' )

returns '2023-09'

Was this reply helpful? Yes No
Sbsyx 113 on at

Like (0)

Report

Thanks, It is do. But I have problem with date dowloand Excel. Flow dowloand ISO 8601 format, exacly this is YYYY-MM-DDThh:mm:ss±hh:mm. I try formula formatDateTime(item()?['Zakończone'],'yyyy-MM') on dowloand column from table Excel . However, It still return full date on ISO 8601.

I need to leave the date in the format yyyy-MM-dd in the excel table column.
What do?

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

formatDateTime(item()?['Zakończone'],'yyyy-MM') returns year an month only (if item()?['Zakończone'] is a valid date string)

Use formatDateTime(item()?['Zakończone'],'yyyy-MM-dd') to get the whole date (without time)

Was this reply helpful? Yes No
Sbsyx 113 on at

Like (0)

Report

The problem is that the array filter cannot compare the data from the column "Zakończone", it returns all rows instead of those expected from the trigger.
I think that the automate cannot compare the full date with the shortened one because it throws an empty body, and I want to search by the shortened one when I enter the expression formatDateTime(item()?['Zakończone'],'yyyy-MM') while taking information from the table it downloads the full format anyway.
Generally, the point of the flow is that after entering a date in the trigger, e.g. "September 2023", the automation sends me data from the table only from "September 2023". The entire automation sequence is complete. All I need is a solution for filtering by date without the day of the month.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
You should have this on the left side of your Filter array condition.

formatDateTime(item()?['Zakończone'],'yyyy-MM')

Was this reply helpful? Yes No
Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

You should not check for equality.

Check "contains" instead, if you want to filter for date strings with your yyyy-MM formated date.

Was this reply helpful? Yes No