Unanswered

JOIN on tables in power apps gallery

(0) Share

Report

Posted on by Malek007

Hello, So i am working on a power apps app. I have a table called workshop and a table called Language and a table wworkshop_language since the relation between language and workshop is many to many. I have a gallery and i am displaying the workshop_language table in the gallery. However I have a column where i want to display the languages of each workshop doing a join between the language_workshop table and the languages table. I wrote this code but it does not work :

Concatenate(
Filter(
Language;
ID = ThisItem.LanguageID).LanguageName
; ",")

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ZUdeepa 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Explain more plz

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Malek007,

You are actually very close! Concatenate is used to merge strings together:

Concatenate("Text1"; "Text2")

If you want to concatenate the column values of multiple rows with a separator, use Concat:

Concat( Filter( Language; ID = ThisItem.LanguageID ); LanguageName; "," )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Dush_S 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hii, @Malek007
try this,
insert a label to the gallery and type the below code according to your data.

Lookup(YourlworkshopListName,ThisItem.LanguageID=LanguageID,LanguageName

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Malek007,

As an addition to my previous code, we will have to add the workshop_language table as well in order to receive all language names. The code below will assume that this code is written in a label within the Workshop gallery.

Concat( //List all languages linked to this workshop ForAll( //Adjust the link between workshop_language and workshop (workshopIDColumn) Filter(workshop_language; workshopIDColumn = ThisItem.ID) As Main; LookUp( Language; ID = Main.LanguageID; LanguageName ) ); Value; ", " )

I hope this helps!

Was this reply helpful? Yes No