Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Sign in Power Apps then using AzureAD to connect to SharePoint



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.



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.



Alice Zhang

Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

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


Incoming: New and improved badges!

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


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,295)