187
I have a birthday checker running on our employee list at the moment, but it takes close to an hour to run as it has run a date checker on every item / employee on the list, checking their birthday which is in a DD/MM/YYYY format.
Is it possible to filter the 'get items' based on a partial date, i.e. just the DD/MM part?
I've tried setting up a calculated column that reads their birthday as DD/MM, but you can't filter on a calculated column, so that option failed.
Thanks Mabel, bit of tinkering and I've got this working, although I ended up filtering on my calculated column through the filter array action. The whole Flow now runs in under a minute instead of 45 of them.
Hi @JamesSnaps ,
Thanks for updating.
I have made some research and test, I am afraid that it might be not possible to format the column you want to use in the Filter query field.
I also tried using a calculated column instead, however, calculated column is not supported in Filter query.
Further, you could also try with action Filter array instead of a Condition. Please check the following flow for a reference:
The function used in Filter array:
Share
Report
All responses (
Answers (
@equals(formatDateTime(item()?['Date'], 'dd/MM'), utcNow('dd/MM'))
Function used in Compose action is:
item()?['Title']
Best regards,
Mabel
Hi @JamesSnaps ,
Do you want to send a notification when today is employees’ Birthday?
Please take a try with the function formatDateTime to format the date to “dd/MM”.
I have made the following test for your reference.
In the list, there is a date column of type “yyyy-MM-dd”.
Trigger the flow with a button, then get items from the list.
Add a Condition with the following formulas:
formatDateTime(items('Apply_to_each')?['Date'],'dd/MM')
is equal to
utcNow('dd/MM')
Under If yes branch, send a mobile notification.
Image for your reference.
Best regards,
Mabel
