Concatenate several values from a related table

(0) Share

Report

Posted on by Gorilla_8

I want to concatenate the present values from a related table, just the ids linked to that item in the gallery.

Example:

Concat(MYSPList2;LookUp(MYSPList2;IDLookUp=ThisItem.ID).ColumnName; " - " )

Concatenate(LookUp(MYSPList2;IDLookUp=ThisItem.ID).ColumnName & " - " )

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gorilla_8

Concat and Concatenate are two entirely different functions.

If you are just trying to put together two (or more) values, then utilize the concatenate shortcut of the & character.

Ex. LookUp(MYSPList2; IDLookUp=ThisItem.ID; ColumnName) & " - "

Beyond that, I am not clear on what issue you are having.

I hope this is helpful for you.

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Thanks!

Yes, I know...

And I wanna get two more values based on IDLookUp...

You mean like this>

Concatenate(LookUp(MYSPList2; IDLookUp=ThisItem.ID; ColumnName) & " - " )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Gorilla_8

Are you trying to get those column values from the same lookup? Same record?

If so, then utilize the following:

With(LookUp(MYSPList2; IDLookUp = ThisItem.ID); ColumnName & " - " & ColumnName2 <& etc>)

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

I want to get all data from a column of the same ID from the main table

I want to get all data from a column of the same ID from the main table

Example:

I have ListA with ID 1

And I have ListB with the IDLookUp 1, with 3 items.

I want to show the 3 items from ListB concatenated in the main gallery of ListA

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Gorilla_8

Then that would be the Concat function.

Concat(Filter(ListB, IDLookUp = ThisItem.ID), columnName & "; ")

This would produce a semi colon separated text result.

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Thank you very much!

Was this reply helpful? Yes No