Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Reading content from onedrive files inside cloud flows

Posted on by
Hello, im new to power automate and im kinda stuck here.
Basically, i want to read the content from a csv file inside onedrive and then use it to send an email.
 
I got as far as to use the Get file content step from onedrive but i dont know what to do next.
 
I want to be able to use the content from the file and write a dynamic email based on the information.
 
Like this:
 
"On october we sold [sales] of [product]."
 
With sales and product beign extracted from the csv. 
 
Also is it possible to filter lines/columns?
  • xanddix Profile Picture
    xanddix 18 on at
    Reading content from onedrive files inside cloud flows
    Hello, its important to know if you are working on a standard file, every file its going to have the same model.?If yes, i reccomend u to convert that file on xlsx and run a office script on excel to get the information from respectives cels from ur table. office scrips is avaliable on "Automate" tab on excel but its only avaliable for Enterprise E3/E5 microsoft plans.

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard