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 / Refresh power Query an...
Power Automate
Unanswered

Refresh power Query and send the mail as attachment.

(0) ShareShare
ReportReport
Posted on by 90

Dear Sir,

I want to create a power automate Web (not desktop version) for below steps. Please help.

 

1. What I did: I am following the below power automate to download an excel file from the link of the mail body and save it into my OneDrive.

mohashinBhyian_2-1677483142020.png

 

 

2. Need to refresh Power Query of specific excel file: Now this downloaded excel file is linked with Power Query. I want to refresh this power query.

mohashinBhyian_1-1677482229374.png

 

3. Send mail with an excel table as an attachment:  

 

mohashinBhyian_0-1677482606805.png

 

4. Filter the below excel sheet based on different suppliers and then send the mail including the range as an excel attachment. Mail Id can be stored in an excel sheet. 

mohashinBhyian_1-1677482620807.png

 

Categories:
I have the same question (0)

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard