Forum Discussion
Power Automate - read excel file off sharepoint
Hello,
I am new to PowerAutomate and have spent a good amount of time trying to figure out a flow - but not able to resolve 3 errors --
Overview - flow reads an excel file from sharepoint; file has name and birthday; if birthday is in the next 7 days, it should send me an email with a list of birthdays in the next 7 days. need a line break for each upcoming birthday.
Issues
1) Not able to read date as a date
2) No line break between rows of birthday in the email
3) Not able to compare
I will greatly appreciate your suggestions!
Thanks and Happy Holidays!!
Pav
if you want a guaranteed space use . You could also consider using "Create HTML Table" if that is an acceptable output format.
5 Replies
Please ask at the Power Automate forum. Microsoft Power Platform Community Forum Thread
1. Use UTC and ISO-8601 format - always!
2. use HTML <br>
3. compare what with what?
Thank you Ibendlin! Much appreciated.
using the utc and iso date format, the date comparisons worked fine.
I got an email with the 2 correct records.
Line break is also working great.
How do i create a space between the fields in an output row?
Thanks Again!!
Pav
if you want a guaranteed space use . You could also consider using "Create HTML Table" if that is an acceptable output format.
