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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / extract data from exce...
Power Automate
Unanswered

extract data from excel file into power automate email

(0) ShareShare
ReportReport
Posted on by 235

 

Hi, 

 

I have a excel file in SharePoint library and one of the columns in excel file (table) has dates.

Is there a way to show latest date from the file into body of my power automate email ? 

Below is my flow and I want to get date from excel file in "when a file is created or modified in folder 4". thank you

 

tanveal_0-1665951235668.png

 

Thanks!  

Categories:
I have the same question (0)
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @tanveal 

    What action are you using for When a file is created or modified in a folder 4?

    To me, that sounds more like a trigger.

     

     

  • tanveal Profile Picture
    235 on at

    yes both are triggers, essentially, I have two excel files that needs to be updated sequentially before powerbi dataset is updated and once data is updated and power BI report is updated, I want to send an email indicating that report has been updated as of date (which it should grab from excel file in folder 4). Folder 4  has table in excel file and one of the column is date and I want to grab the latest date from the column and show in the email)/  

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    @tanveal ,

     

    As far as I know, one flow could only have one trigger in Microsoft flow.

    I believe you need to create two separate flows.

     

     

  • tanveal Profile Picture
    235 on at

    I want to update the Power BI dataset only when both files are updated, would that be possible to have it with 2 flows ?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard