Create Collection for the Multislect People type column

(0) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone

I have two multiselect people type column in my SharePoint List

On start of the app, I have tried to create a collection for the record

ClearCollect(
SelectedPersons,
Filter(
NPP_IT_Top_risks,
!IsBlank(Risk_Owner)
)
);
ClearCollect(
SelectedPersons2,
Filter(
NPP_IT_Top_risks,
!IsBlank(LT_Owner)
)
)

Both LT owner and Risk Onwer are multi select person type column

The collection is not showing any data or record

"Onslect " of the button I have added following formula.

If(
User().Email in SelectedPersons.Email || 
User().Email in SelectedPersons2.Email || 
User().Email in ["ropp.com", "sivwpp.com", "Solan@wpp.com", "nikithpp.com", "robipp.com", "Richpp.com"],
Navigate(
'New Top IT Risk',
ScreenTransition.Fade
),
Notify("You don't have access to this screen")
)

Could anyone please check what is wrong with the formula

Categories:

All responses (3)

Answers (0)

VishalJhaveri 1,167 Super User 2025 Season 1 on at

Like (0)

Report

Re: Create Collection for the Multislect People type column

A
Screen1
A
Screen2
A
Screen3
B
Screen1
C
Screen1

Create the MS Groups namely A, B, C and then assign them screen which they can access in SharePoint list.
Now, when the user will open the Canvas Apps, based upon the role assigned he/she will get access to only those screens that are mentioned in the SharePoint List. You need to write expressions or code accordingly.
Danny_Dicaprio on at

Like (0)

Report

Re: Create Collection for the Multislect People type column

Hi @VishalJhaveri

Can you please be brief
VishalJhaveri 1,167 Super User 2025 Season 1 on at

Like (0)

Report

Re: Create Collection for the Multislect People type column

You can create a group and write screen names across those groups in SharePoint List.
Based upon the group accessing the application, you must assign a role. And based on the role assigned, it must correspond to the role written in SharePoint list.