Hello, I have a flow setup to email a reminder for someone's birthday. Here is the flow:
, but I am getting this error:
The expression I am using is:
In the error message you attached, Power Automate is saying that a "Null" value was passed to the formatedatetime() expression. This caused it to fail because this expression needs a value of type "string".
If the expression received a "Null" value, nothing was passed to it, the value was empty. Double check that Power Automate is getting the correct value for "items('Apply_to_each')?['DOB']".
What option is it giving you for the Dynamic Content under the apply to each loop? If "Value" is your list, you should have dynamic content from the loop to iterate each item in the list.
This is what I show, there are a lot of them but I just wanted to show the DOB one... I have value there now.... not sure what I am doing wrong. I just want to be able to have a notification emailed if someone's birthday is on that day...
Without having access to the data myself, i can't say for certain where the exact issue is. I can see you are pulling a list from SharePoint. This would create an array in Power Automate. Apply to Each then needs to loop through that array of DOBs to compare each one to the current date.
Somewhere in this chain, a Null value is being passed.
Can you confirm what data comes through when you select DOB from the above list? Are you getting an array, string, nothing?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.