Forum Discussion
Post a Teams message, when Excel online criteria is met.
Hogstad_Raadgivning I would do it a different way so you don't have to manually check the spreadsheet and add in if it's the person's birthday - you can get the flow to check that.
Make sure your spreadsheet has the full date of the next birthday and that the rows are formatted as a table:
In your flow, as you've realised, you need to use the List rows present in a table action:
Then add an apply to each and select value from the dynamic content.
Next add 2 Compose controls:
1. I've renamed the first one to ConvertedDate and its purpose is to convert the date from Excel's integer format to something you can use in the flow. So you need an expression which will be:
When you are comparing dates you must always have them in yyyy-MM-dd format.
2. The second Compose, called Today, gets today's date and puts it into yyyy-MM-dd format for the comparison. The expression is
Finally, add a Condition to check if the converted date is the same as today's date. In the left field select the ConvertedDate output from the dynamic content, and in the right field select the Today output from the dynamic content.
In the green if yes channel add your Teams Post a message action
And this is the result in your Teams channel:
Rob
Los Gallardos
Microsoft Power Automate Community Super User