Project Report with Project Users Collection based on Role & Home Group | Community
Skip to main content
MoniqueEvans
Community Advisor
MoniqueEvansCommunity Advisor
Community Advisor
September 11, 2025
Solved

Project Report with Project Users Collection based on Role & Home Group

  • September 11, 2025
  • 2 replies
  • 321 views

I'm working on a new view for a project report and am having a bit of text mode brain fog. I would like to pull in the Project Users but only include those from a specific homegroup and exclude a home team. I'm able to pull the list for Home Group but cannot remember how to do a "not_in" for the role? Is that even possible.

 

displayname=Creative Studio
listdelimiter=<div>
listmethod=nested(projectUsers).lists
type=iterate
valueexpression=IF({user}.{homeGroupID}="GUID",CONCAT({user}.{name}),"")
valueformat=HTML

Best answer by nryan2

Would something like this work:

 

displayname=Creative Studio

listdelimiter=<div>

listmethod=nested(projectUsers).lists

type=iterate

valueexpression=IF({user}.{homeGroupID}="GUID",IF({user}.{homeTeam}.{name}!="Your Team Name",CONCAT({user}.{name}),""))

valueformat=HTML

2 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
September 11, 2025

the role is a collection on the user object. Documentation probably says "no collections of a collection" -- would you be content with just the primary role? As a quick workaround you could probably indicate that if the primary role is XYZ, do "", otherwise, concat the user name. 

 

In case you meant to say "team" instead of "role", the same is true -- can't look for all teams, but can look for the home team.

MoniqueEvans
Community Advisor
MoniqueEvansCommunity AdvisorAuthor
Community Advisor
September 12, 2025

Thanks Skye! That's what I was afraid of, I could list every role (or team) except for the project manager but was hoping for something a little cleaner so it didn't take 5 minutes to load due to the lenghtly complex filter.

 

Before I go through that trouble, I'll check in with the team and see if it bothers them that there's an extra name included.

N
nryan2Accepted solution
Level 3
September 12, 2025

Would something like this work:

 

displayname=Creative Studio

listdelimiter=<div>

listmethod=nested(projectUsers).lists

type=iterate

valueexpression=IF({user}.{homeGroupID}="GUID",IF({user}.{homeTeam}.{name}!="Your Team Name",CONCAT({user}.{name}),""))

valueformat=HTML

    MoniqueEvans
    Community Advisor
    MoniqueEvansCommunity AdvisorAuthor
    Community Advisor
    September 19, 2025

    THANK YOU NRYAN!!!!! I totally forgot that the ! could be used in the expression, that was the game changer. I decided to go with homeTeamID instead of Home Team Name since that could be edited in the future and this is EXACTLY what I needed. So simple.

     

    In case anyone else is interested in the final code:

    displayname=Creatives listdelimiter=<div> listmethod=nested(projectUsers).lists type=iterate valueexpression=IF({user}.{homeGroupID}="GUID",IF({user}.{homeTeamID}!="GUID",CONCAT({user}.{name}),"")) valueformat=HTML

     

    Terms & ConditionsAccessibility statement

    Loading footer...