Answered

Trouble with Birthday Alerts using a SharePoint list

(0) Share

Report

Posted on by blakelemay

Hello,

My goal is making a flow that sends out a birthday alert to our staff via Microsoft Teams 1 day before their birthday or half birthday. I have tried multiple different methods, but they all come down to the same result (The flow was succesful, but it failed to send the message to teams because the branching condition is not satisfied.)

My most recent attempt is this:

- I added a column that automatically subtracts one day from their birthday (Column Name: Birthday Alert)

- I added another column that automatically compares the day before their birthday, to todays date. (Value of 1 or 0) (Column Name: Birthday Alert Today?)

- I set up "Reccurence" --> "Get items" --> "Apply to each" --> "value" --> Condition: Birthday Alert Today? is equal to 1

- If yes: Send a teams message. If No: Do nothing

It returns the error below.

How can I fix this issue?

and if this issue is fixed, and the branching for the condition for the Teams message is still not satisfied, how do i fix that?

Also, could this be causing the issue?

As you can see, my sharepoint list items that have a birthday tomorrow are showing a value of '1'.

But when I filter that column by '1', it says there are no items that fit that criteria.

Thank you

I am very new to Power Automate, so please explain it to me like im 5 years old if possible 🙂

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

RoboHeart 65 on at

Like (0)

Report
Hi @blakelemay

to be honest, it is sometimes a bit tricky with calulated list fields in Power Automate.
Generally, it is easier to do the calulation in the flow if you just need it there.

Calculated values are coming as strings and if they are numbers it could be that they look like this
"1.00000000000000"
if - like in your case - you actually expected a number of value 1 w/o any further digits.

But 0 is "0" so in your case the easiest way would be to write your condition like this, e.g.:

Was this reply helpful? Yes No
Verified answer

blakelemay 23 on at

Like (0)

Report

Hello, I actually found another way to solve this. I probably over complicated it a bit, but it gets the job done. What I did was add et another additional column that checks the previously mentioned column for a "1", if there is a "1" then the new column will say "Yes". This did the trick. Not the prettiest thing in the world but im happy.

Was this reply helpful? Yes No
RoboHeart 65 on at

Like (0)

Report

Of course, this will also work.
I just gave you the easiest workaround and the hint with the string. 😉

Was this reply helpful? Yes No
blakelemay 23 on at

Like (0)

Report

I will remmeber that for next time, thank you 🙂

Was this reply helpful? Yes No
blakelemay 23 on at

Like (0)

Report

Well, I do have an issue with the laf birthday column as reading into next year (2023) when a column adds 6 months for a birthday. Do you know of a formula i can use to keep the year as 2022 if it moves into next year?

Was this reply helpful? Yes No