Unanswered

ClearCollect with 4 tables.

(0) Share

Report

Posted on by Kathryn_Marie

Hi,

I am trying to create a collection with 4 tables. My code has no errors but I'm also not getting a result. It is basically supposed to get the record from the first table, then retrieve the next values based on a matching ID, and so on for all 4 tables. Can anyone see any issues with my logic here?

ClearCollect(

Results,

{

JobTitle: Jobs.Title,

JobDescription: Jobs.Description,

JobSkillsDescription: AddColumns(

Filter('Job Skills', 'Job ID' = Jobs.'Job ID'),

JobSkillsDescription, Description

UserSkills: AddColumns(

Filter('User Skills', 'User Skill ID' in 'Job Skills'.'Skill Group ID'),

UserSkillsDescription, Title

)

}

)

The 4th table not shown in the code here is trying to retrieve the Persons name from a User table, but I wasn't about to do that without errors yet so I thought I'd start with the first 3 and get them working before I add that back.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
hey @Kathryn_Marie

can you try this please:

ClearCollect( Results, AddColumns( Jobs, JobSkillsDescription, AddColumns( Filter('Job Skills', 'Job ID' = Jobs.'Job ID'), "JobSkillsDescription", Description ), UserSkillsDescription, AddColumns( Filter('User Skills', 'Skill Group ID' in Filter('Job Skills', 'Job ID' = Jobs.'Job ID').'Skill Group ID'), "UserSkillsDescription", Title ) ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Kathryn_Marie 15 on at

Like (0)

Report

Thanks for your reply. I'm still getting a blank response. I'll describe the tables a bit better. So the table Jobs, has a list of jobs and information about it, then each job has multiple skills associated with it. So firstly, for every job, the next column needs to be a skill description. Then for every skill description, there will be multiple matches from the user skills table, submitted by different users, and finally I need to get the users name with the ID from the User Skills collection so I know who put in that description.

Was this reply helpful? Yes No