Dynamically Load different data depending on the User

[zhengting]

Hi, I am trying to load a form where it would load certain data depending which office the user is from. Each office would have their own excel file. May I know if there is a way to load the correct data from the correct file depending on who is using the app?

Thank you!

Zheng Ting

[BCLS776]

Right now, Power Apps does not support runtime linking to different data sources - each data source must be connected to the app in the portal before it is run.

If you are working with a small number of Excel files, consider linking all of them and using conditional logic in your app to decide which one goes with which user.

Hope that helps,

Bryan

[Mike2500 · Accepted solution]

In addition to Bryan's idea, another common approach is to load all the rows into a single source, perhaps a SharePoint list, and filter the rows based on who is viewing the app. 

[zhengting]

Thank you so much for your help!