cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alessandramaced
Helper V
Helper V

Collections not populated for all users

Hi all

 

I'm building an app to people form different departments access.

So I set User when app start to get data that user can see.

 

I have these formulas:

 

1) to get user

Set(varUser;Lower(Trim(User().Email)));;

 

2) To set area from user

Set(AreaUser;LookUp(DespesasPreenchedores;Email=varUser).Area);;

 

3) To populate a collection with all finance expenses that user can access table 

ClearCollect(colDespesa; Filter(Despesas_Areas;Area=AreaUser));;

 

For my user the collection works fine. But other user don't have populated the collection. Show no items (must show)

 

What I did wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
EddieE
Solution Sage
Solution Sage

@alessandramaced 

Your formula seems fine. Things you can check:

 

- are all Email addresses stored in the DespesasPreenchedores list in Lower Case?

- Do all Users in the DespesasPreenchedores List have data for Area?

- Does the data for Area in Lists DespesasPreenchedores and Despesas_Areas match?

- Do the other users have the correct permissions to view the data?

- You may need to use Lower(Trim(...)) on the data from the List DespesasPreenchedores as well as User().Email?

 

 

 

View solution in original post

2 REPLIES 2
EddieE
Solution Sage
Solution Sage

@alessandramaced 

Your formula seems fine. Things you can check:

 

- are all Email addresses stored in the DespesasPreenchedores list in Lower Case?

- Do all Users in the DespesasPreenchedores List have data for Area?

- Does the data for Area in Lists DespesasPreenchedores and Despesas_Areas match?

- Do the other users have the correct permissions to view the data?

- You may need to use Lower(Trim(...)) on the data from the List DespesasPreenchedores as well as User().Email?

 

 

 

Ops, forgot to give permission on sharepoint list. Thank you very much

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,516)