Answered

Birthday email flow matching any date instead of just month and day MM/dd

(0) Share

Report

Posted on by BHarTT

Hello Everyone,

I have a flow that is matching any 4 characters of the output to the birthday. For example, the Getdatetime output is 02/19. The email notification will go out to all dates with any of the 4 characters like 06/02/1974. Is there any way to only match the MM/dd?

Thank you in advance.

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@BHarTT

Try this:

SharePoint stores dates internally as yyyy-MM-dd

I noted that you have almost 5000 items in the list - Flow can't retrieve more than 5000 items unless you have a premium license.

It would be better if you added two additional columns to the list - one for the month and another for the day of the birthday. Do not make them calculated columns - have a Flow populate the new columns. If you do so, then you can use an OData filter query which would be much more efficient.

I tried solving your issue using substringof and endswith in an OData filter but was not successful.
BHarTT 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ScottShearer,

Thank you for that. I am testing and will have the results on the next run tomorrow morning. I will report back then.
BHarTT 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ScottShearer,

I ended up using MM/dd/ in the formatDateTime since that is how they are coming out in the Get Items export for that column. It seems to have done the trick but I won't know for sure until the 19th and 20th of next month. Thanks for your help, and I will mark as answered once confirmed.