Power Automate - read excel file off sharepoint

[pbidani]

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

[lbendlin]

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?

[pbidani]

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

[lbendlin · Accepted solution]

if you want a guaranteed space use &nbsp;  .  You could also consider using "Create HTML Table"  if that is an acceptable output format.

[pbidani]

Excellent!

That works!  Thanks! 

My compare is currently on the full date - how do i modify it so it is on the day and month only.  Goal is to send email showing birthdays in the next 7 days --- 

Also, how do i show a cleaner date in the email?

Source data is below

Thanks again!

Happy Holidays and Best Wishes for the New Year!

[lbendlin]

Read about convertFromUtc()  - especially the format option. Also read about addDays()

Expression and functions - Azure Data Factory & Azure Synapse | Microsoft Learn