Change data source base on user

[David1966]

Is this possible to change your data source base on the user.

• I'm building a app that keep track of the used by date of first aid kits in work utes.
• So when i open the app on my iPad the app pulls my data for my first aid kit from a SharePoint list called TMT951.
• But when someone within my organization open the app it finds there first aid SharePoint list for a different first aid kit TMT954.
• So if i have say 5 user and they have 5 diff Kit each user can see and edit there kits.
• Will it use the same Gallery and Form?

This this possible?

[mmbr1606]

hey @David1966 

one question. Does this has to be dynamic? So how many users/lists do you have?

You would need a way to map each user to their respective SharePoint list. This can be achieved in several ways, such as maintaining a master SharePoint list or a table within your app that contains mappings of user identifiers (e.g., email addresses) to the names of their respective SharePoint lists.

this is just a high level approach:

// On app start or on the visible property of your first screen
Set(varCurrentUser, User().Email);
Set(varUserListName, LookUp(MappingList, UserEmail = varCurrentUser, SharePointListName));

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[David1966]

New to all this still a lot to learn second app.  So, your saying have a SharePoint list with everyone details "Email" "first last name" and a link to their SharePoint Data to link to app?

• So how do I handle the data do i link everyone data in the app then when they use the app?

         get their data and links it to the gallery and form?

         So how would I do this if you know of a blog or Video?

[mmbr1606]

there are several things that would work i guess.

how many users are there? if there are not many you could also hard code it. if its 100 (just ab example) this wont be developer friendly xD

[David1966]

Just few at first but it just a invasion im putting forward to the boss could you just share the app and setup each user in their own power apps account? would that be an easier way?