cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MRMC
Level: Power Up

Sign in Power Apps then using AzureAD to connect to SharePoint

Hi,

 

I'm a beginner to using flow to connect data from one source to another and O365 in general.  I'm trying to display responses from a MS form and have them displayed in a power BI webpart, which is embedded in a sharepoint site.  In theory I want the BI to update and display the new responses as they are submitted.

 

My manager wants the forms and the power BI as webparts on one page so Senior Managment can view this from one location.

 

I'm having some issues, when the responses are completed they get added to a .xlsx file which is in the documents folder under site contents in the sharepoint site.  This file gets updated with the data from the forms responses, I also want this to display in power BI. 

 

Currently in power BI I have used the get data > SharePoint - Team Sites > file.xlsx, which is fine as I can then genrate a report from this, but it doesnt show the most recent responses.  I was hoping this is something flow can help with, and I would be grafeful if anyone can point me in the right direction.

 

Thanks for your help.

 

Best Regards.

      

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Sign in Power Apps then using AzureAD to connect to SharePoint

Hi @ MRMC,

 

Could you please share a screenshot of the configuration of your flow?

Could you please share more details about what is the problem you have to achieve your needs?

Do you have problem add the responses to the .xlsx file?

Or do you have problem show the responses from Power BI with the .xlsx file which contain responses?

 

Please share more details so we could provide a proper workaround for you.

 

 

Regards,
Alice Zhang

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,000)