Unanswered

Error while fetching data from Lookup table in combobox

(0) Share

Report

Posted on by Rinky

Hi All,

I have a Projects table (columns - Project Id, Project Name, TaskDescription, group_id(data type- Lookup)). Now each project belongs to a group, so I have Groups table (column - group id (data type-Autonumber), Group Description). I want to display all the projects in a combobox and show Group Description along with Project Name as the text. I tried below code, but it's not working.

AddColumns(Projects,"GrpProjTask",Concatenate(LookUp(Groups,'group id'=Projects[@group_id],'Group Description'),"-",'Project Name',"-",TaskDescription))

Error: The function Lookup has some invalid arguments

Any help will be appreciated.

Thanks!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Rinky

can you try this please:

AddColumns( Projects, "GrpProjTask", Concatenate( LookUp(Groups, 'group id' = group_id, 'Group Description'), "-", 'Project Name', "-", TaskDescription ) )

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
Rinky 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, No, It did not work. Still giving same error
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Rinky

try this please:

ClearCollect( NewCollection, ForAll( Projects, { ProjectName: 'Project Name', TaskDesc: TaskDescription, GroupDesc: LookUp(Groups, 'group id' = group_id, 'Group Description'), ConcatenatedValue: Concatenate(LookUp(Groups, 'group id' = group_id, 'Group Description'), "-", 'Project Name', "-", TaskDescription) } ) )

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
Rinky 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It did not work