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?

All responses (6)

Answers (2)

Verified answer

Chriddle 7,793 Super User 2025 Season 1 on at

Like (0)

Report

Re: Manually triger of follow - enter month and year

You should not check for equality.

Check "contains" instead, if you want to filter for date strings with your yyyy-MM formated date.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: Manually triger of follow - enter month and year

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

formatDateTime(item()?['Zakończone'],'yyyy-MM')
Sbsyx 113 on at

Like (0)

Report

Re: Manually triger of follow - enter month and year

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.
Chriddle 7,793 Super User 2025 Season 1 on at

Like (0)

Report

Re: Manually triger of follow - enter month and year

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)
Sbsyx 113 on at

Like (0)

Report

Re: Manually triger of follow - enter month and year

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?
Verified answer

Chriddle 7,793 Super User 2025 Season 1 on at

Like (1)

Report
Re: Manually triger of follow - enter month and year

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

returns '2023-09'