cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sasrsc
Resolver II
Resolver II

Parent, Child relationship - create collection with the children as one variable using concat?

I've been working on this for hours and I think I'm getting further away from solving it...

I want to do a ForAll and loop through each Report by Name in the Table VAReportListings and add a column to a collection that is a concatenated list of the TagID.Name value from VAReportTags. It's a zero-to-many relationships. 

So for example:
Airline Analysis, Air-Trip-Events
Arrivals & Departures, Air
Bookers & Travelers, blank currently
etc...

The ListID and the TagID in VAReportTags are lookup columns in CDS and is displaying below the "name" value.

Table VAReportTags

sasrsc_0-1603917173053.png

 

Table VAReportListings

sasrsc_1-1603917214350.png

 

0 REPLIES 0

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (49,133)