Hello,
I
am trying to filter with 2 data fields on my form to return a concatenated list
of users from a SharePoint List
Main: myFields
BusinessSector
BusinessRole
AllUsers
Gate
Roles (Secondary)
queryFields
q:SharePointListItem_RW
Sector
Role
Employee
dataFields
d:SharePointListItem_RW
Sector
Role
Employee
pc:Person
DisplayName
AccountId
AccountType
On the form the user
should:
·
Select a
BusinessSector
·
Select a
BusinessRole
·
Click a button
which in the AllUsers field would return all of the DisplayNames (with “;”
between) where
o BusinessSector=Sector
o BusinessRole=Role
I can add 2 actions to the button where I set the Gate Roles Sector=Business Sector and Role=Business Role and the results showed the correct list of users. I cannot figure out how the concatenate the list of users into one field.
Thanks