I want to export a list of projects with their associated project users

[MichaelLandauer]

I want to export a list of project data using Fusion. I have most of the fields configured, but I cannot figure out a way to export a list of users associated with each project (the project team). 

I see an expression in reports that refers to projectUsers. But I don’t see anything like that as an option in Fusion as a project field. Here’s what I have in text mode for the report:

displayname=Project Team Members

listdelimiter=

listmethod=nested(projectUsers).lists

namekey=group.plural

textmode=true

type=iterate

valuefield=user:name

valueformat=HTML

I want what that produces on that report to be part of my export from Fusion, but I can’t figure out how to get there.

I tried to use Related Records. I tried to do a search for users but can’t figure out a way to search for “users associated with this project” …

[Viktoriia]

Maybe just look for the specific roles such as Project Owner, Project Sponsor, users assigned to tasks, if those are needed?

[ChrisStephens]

Check the field projectUsers:user:name

[MichaelLandauer]

OK, I can see where that might be where I need to go. Thanks. But ... I am not sure what to put for the ID field here:

The 2. ID is the project ID from an earlier module. I tried that in the ID field, but no luck. 

[ChrisStephens · Accepted solution]

Oh no, pull the project. So your record type = Project, check whatever you want in outputs (but at least check 1), then go to collections, toggle the map, and type in projectUsers:user:name.

[MichaelLandauer]

Got it! Perfect. This makes my day. Thank you. 

[MichaelLandauer]

One more followup. I am sure this is just me not doing something with arrays or collections, properly. But the results I am getting are: 

[Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection], [Collection]

[ChrisStephens]

There's a configuration error somewhere, can you screen shot your call to the project and the output bundle data, as well as where you are seeing that [Collection]?

[MichaelLandauer]

There must be a step in there where i need to convert the collection to an array maybe? 

[ChrisStephens]

What is that output from? The names of the vars in the output makes me think it's not the raw output from the WF module, so how are you mapping the data into that second module?

[ChrisStephens]

It should be something like this, which will give you a string that is a new line-seperated list of each user's name

[MichaelLandauer]

Yes!! That's it. That did it. Thank you for your patience with me. Really appreciate it.