Power Platform Community Forum Thread Details

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

Categories:

Building flows

Issue 1: Reading Date as a Date - Use the "Compose" action to parse the date from the Excel output: formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd')

Issue 2: Adding Line Breaks Between Rows in the Email - Use the "Append to string variable" action to build the email body dynamically. For each row, append the name and birthday with a line break (<br> for HTML or \n for plain text): concat(variables('EmailBody'), items('Apply_to_each')?['Name'], ' - ', items('Apply_to_each')?['Birthday'], '\n')

Issue 3: Comparing Dates: Parse today’s date and calculate the range: utcNow() addDays(utcNow(), 7)

Convert the birthday to a comparable date format: formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd')

Compare the birthday with the calculated range using a condition and(
greaterOrEquals(formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd'), utcNow()),
lessOrEquals(formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd'), addDays(utcNow(), 7))
)

let me know if you need more details.