Hi @Gottijay2000 ,
Do you want to get a one column table where each value is the email addresses of the user in 'Admin Users'?
Can you tell me whether the person field(User) allows multiple people?
I’ve made a similar test for your reference:
Case 1: The person field(User) does not allow multiple people.
1\ Add a button control and set the control’s OnSelect property to:
Clear(Emailofusers); /* ‘Emailofusers’ is a collection that will be created by the following code*/ /*Clear the collection ‘Emailofusers’ before getting the data*/
ForAll( /*traversal each records of 'Admin Users'*/
'Admin Users',
Collect(
Emailofusers,
{emailaddress: User.Email} /*get the email of user*/ /*User is the column name of the people field(User)*/
)
)
2\ You will get a one column table(Emailofusers) where each value is the email of the user by clicking the button.
Case 2: The person field(User) allows multiple people.
1\ Add a button control and set the control’s OnSelect property to:
Clear(Emailofusers); /* ‘Emailofusers’ is a collection that will be created by the following code*/ /*Clear the collection ‘Emailofusers’ before getting the data*/
ForAll( /*traversal each records of 'Admin Users'*/
'Admin Users',
ForAll( /*traversal each records of ‘User’*/
User,
Collect(
Emailofusers,
{emailaddress: Email} /*get the email of user*/
)
)
)
2\ You will get a one column table(Emailofusers) where each value is the email of the user by clicking the button.
If you still have any question please don’t hesitate to let us know.
Best Regards,
