Unanswered

Inventory management - location and user management

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Ive build an inventory app, but im stuck on the location and user management access. Example: We have three different locals, lets call this locations 1, 2 and 3 (sites with users), all of the users can access and view the inventory, but only the users that work on location 1 can edit items on location 1.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @Anonymous ,

You need a list of users and their allowed locations then set a Variable something like

Set( gblLoc, LookUp( YourUserList, YourEmailField = User().Email ).UserLocationField )

then add

LocationField = gblLocation

into any filter

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz so, i need to create another column on my sharepoint list with user and location (what type of colum)? theres a way to explain this step by step?
Thanks in advance

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz So, just for better understanding: i have this register screen, this screen already push the current user that are using the app:
And then i have this screen to where i do the movements:

Example: I, nick.carvalho@ .com can view all of the itens and only make change on itens that are located on location 1, and then it goes: user2 can view all and make changes on location 2, user 3 can view all and make changes on location 3...

There must be another list with user and location, right? ive just made a new one with Email and location column. Whats the next step?

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

You need a separate list with User Email and Location.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelzYep, just created. But i dont follow where to put this formula that you mentioned in first place..

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

It is setting a Variable, so App OnStart will do the job

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz What i am missing here?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz ive accepted by accident a response, but im still struggling with this.

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

I am not sure what you mean - assuming Contrato is the field you want in 'Controle de acesso' that indicates the user's location then (apart from your other filters) if the field name Contrato is the same in 'Banco Estoque' the filter you have posted should do the job you want.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz when a put the filter, its accusing that theres a error in the variable (gblLoc).

Was this reply helpful? Yes No