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


Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.


Flow Community User Group Member Badge

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


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 Flow Community Video Gallery!

Users Online
Currently online: 189 members 4,277 guests
Please welcome our newest community members: