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 / Add a row to Power BI ...
Power Automate
Unanswered

Add a row to Power BI dataset when a new email arrives

(0) ShareShare
ReportReport
Posted on by 2

Hello,

 

I am trying to build a PowerBI report from excel files that I get emailed to my inbox. I am using the "Add a row to Power BI dataset when a new email arrives" template, but when I get to the PowerBI portion I'm not sure what to put in there. Everything that I find online seems to say the dynamic expression coincides with the values you setup in PowerBI (or the column headers of your spreadsheet), but there are no expressions to grab the values from the spreadsheet within in email. Or, at least, I don't know what they are.
Thank you in advance for your help! 🙂


4evrsvd_0-1704222591582.png

I inputted "Time", "From", and "Subject", because of the below picture. They are not actual real values within my spreadsheets:

4evrsvd_1-1704222657454.png

 

Categories:
I have the same question (0)
  • 4evrsvd Profile Picture
    2 on at

    It dawned on me that I'm probably starting with the wrong trigger. The flow mentioned above sounds like it's specifically for emails, but I'm looking for the attachments within those emails. So I've updated it to the following:

    4evrsvd_0-1704229015824.png

    4evrsvd_2-1704229125389.png

     

    But I'm still at a loss of what to put in for the values.

    Thanks again! 🙂

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 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard