Collections not populated for all users

[alessandramaced]

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?

[EddieE · Accepted solution]

@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?

[alessandramaced]

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