Combine Filtered List from Secondary Data Source Into One Field

Amanda Bordelon — Fri, 28 Feb 2014 19:31:49 GMT

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

General

Combine Filtered List from Secondary Data Source Into One Field