web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / PA - reading and inter...
Power Automate
Unanswered

PA - reading and interpreting an excel file from sharepoint

(0) ShareShare
ReportReport
Posted on by 2
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:
I have the same question (0)
  • SaiRT14 Profile Picture
    1,990 Super User 2025 Season 2 on at
    Hi 
     
    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. 
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard