web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Security level per user

Power Apps

Answered

Security level per user

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hey there !

I would like to get this to work, I have a gallery that has data related to the values I entered in a form, then I need those values to be filtered depending on the areas the user belongs.

For example I have these 4 areas, but I just need to show data in the gallery for Area1 and Area4 to the specific User1

I have this values:

Area1

Area2

Area3

Area4

Table Users :

User Areas

User1: Area1, Area4

User2: Area2, Area1, Area4

User3: Area3,Area1,Area2

Thanks in advance for your help.

Categories:

Governance & administering

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you tell me:

What’s your data source?

What’s the data type of Areas column in “Users” Table?

Does each record belong to only one area?

I assume:

Share Point list is your data source.

Areas column’s data type is single line of text.

Each record belongs to only one area.

If my assumptions are correct, I've made a test for your reference:

1\ This is my “Users” table. User and Areas are “single line of text” columns.

2\ This is my Testdata table. It stores all the data. Area is a “single line of text” column.

3\ Add a gallery control and set its Items property to:

Filter(Testdata,Area in Split(LookUp(Users,User="User1").Areas,","))

Or

Ungroup(ForAll(Split(LookUp(Users,User="User1").Areas,","),Filter(Testdata,Area=Trim(Result))),"Value")

4\ The result is as follows:

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

Join the conversation