I'm trying to create a power automate flow that can take several or more dynamic bits of data from cells in an online Excel file. To then put the bits of data into a single email to be sent to a specific individual.
If I did this manually I would just copy the cell data and paste it into an email body.
This is my first Automate use so I'm still learning how to use it. Any help would be gratefully received.
Firstly - you might want to post this on the power automate forums rather than the powerapps forums.
This is definitely doable, just make sure your excel file is setup in a table. I don't know what your data looks like, but I will write out a sample.
Get rows (excel) -> create csv table (data operations) -> send email (outlook) and put csv table in body of email
WarrenBelz
146,618
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,957
Most Valuable Professional