Sharepoint Lookup with multiple conditions in Label

(0) Share

Report

Posted on by DennisSch

Hello,

my problem is that I have a Sharepoint-List as my database.

It is built like:

Article-No (primary key) - Art.-Name - Customer - Plant - Picture

0815 - TESTER - A - 1 - XX

0816 - TESTER 2 - A, B - 2 - XX

0817 - TESTER 3 - B - 1, 2 - XX

The Fields "Customer" and "Plant" are Look-Up's with multiple option.

Now im trying to fill a power-App Galery with picture and Article No, Name and the Customer.

Picture, Name and No are not the problem but i can't fill the label with the information from the customer- Field.

The plant and the customer should be the filters (by a dropdown)

My code for the label was:

thisitem.'customer'.value

but this dowsn't work.... I tried it with concat(Table, 'customer', ",") but this also doesn't work...

for the dropdowns i tried it with followring code:

clearcollect(collectCust,{"All"}),

collect(ColletionCust,distinct(Table,'customer'.value))

Has enyone an idea ?

Thank you in advance.

Dennis

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @DennisSch ,

Try:

ClearCollect(collectCust,{Value:"All"}); Collect(collectCust,Choices(Table.Customer))

Was this reply helpful? Yes No
DennisSch 37 on at

Like (0)

Report
Copy link

Link copied!

Hi,

works for the Dorpdown, thank you but i can't fill the label in the gallery on the same way. Do you have an idea ?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @DennisSch ,

Can you try:

ThisItem.Customer.Value

Was this reply helpful? Yes No
DennisSch 37 on at

Like (0)

Report
Copy link

Link copied!

Hi,

sorry but his doesn't work. I have tryed it before. i got always the information:
"this formula uses a range, which is not presently supported for evaluation. Data Type: table"
(translated from German)

I have another view for this article with a detail screen there is a datacard which shows the needed infromation.... Can I add a datacard to a picture galery instead of the label ?

BR Dennis

Was this reply helpful? Yes No
DennisSch 37 on at

Like (0)

Report
Copy link

Link copied!

Hi,

i made it !

I used a Combobox as a display field and so it works....

But .... The Combobox which i filled with my collection doesn't filter the gallery now. Can i use a filter by searching for a value in a combobox (in view mode)

I add a picture with hope to make it clearer.

BR
Denns

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @DennisSch ,

Somehow I missed the part where Customer is a multiselect column, which is why my previous suggestion did not work. Indeed you can use a combobox, or a label with the below Text property:

Concat(ThisItem.Customer,Value,"; ")

With regards to your filter, due to the multi select on the Customer column, there are some complications due to delegation. The below may mitigate the impact of those complications as long as the number of prefiltered items (using DropDown1) does not exceed the Data Row Limit (by default 500, but can be raised to 2000):

With({ PreFilteredData: Filter( Mappe1, DropDown1.Selected.Result = "Alle" || LadungstraegerTyp.Value = DropDown1.Selected.Result }, Filter( PreFilteredData, DropDown2.Selected.Result = "Alle" || DropDown2.Selected.Result in Customer.Value ) )

Was this reply helpful? Yes No
DennisSch 37 on at

Like (0)

Report
Copy link

Link copied!
Hi,

sorry now im totaly confused....

I add your code but there is an error regaring the first "}" : Error massage: ... used "curlyClose" ...expected "ParenClose"

Is this because i code in German ? I knew there are some differences between the englisch version and the german ...
If( //Filter alle LTs und alle Kunden/Lieferanten Dropdown1.Selected.Result = "Alle" And Dropdown2.Selected.Value ="Alle"; Mappe1; //Filter ausgewählte LTs und alle Kunden Dropdown1.Selected.Result <> "Alle" And Dropdown2.Selected.Value = "Alle"; Filter(Mappe1;LadungstraegerTyp.Value = Dropdown1.Selected.Result); //Filter alle Kunden und ausgewählte LTs Dropdown1.Selected.Result = "Alle" And Dropdown2.Selected.Value <> "Alle"; Filter(Mappe1;Dropdown2.Selected.Value = ComboBox2.AccessibleLabel); //Filter ausgewählte Kunden und ausgewählte LTs Dropdown1.Selected.Result <> "Alle" And Dropdown2.Selected.Value <> "Alle"; With({ PreFilteredData: Filter( Mappe1; Dropdown1.Selected.Result = "Alle" || LadungstraegerTyp.Value = Dropdown1.Selected.Result }; Filter( PreFilteredData; Dropdown2.Selected.Value = "Alle" || Dropdown2.Selected.Value in 'Kunde Lieferant'.Value ) ) )

BR Dennis

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @DennisSch ,

The formula was supposed to completely replace your formula, so the Items property of the gallery should be set to:

With({ PreFilteredData: Filter( Mappe1; Dropdown1.Selected.Result = "Alle" || LadungstraegerTyp.Value = Dropdown1.Selected.Result }; Filter( PreFilteredData; Dropdown2.Selected.Value = "Alle" || Dropdown2.Selected.Value in 'Kunde Lieferant'.Value ) )

Was this reply helpful? Yes No
DennisSch 37 on at

Like (0)

Report
Copy link

Link copied!

Hi,

OK... I replaced my formula but now i got already the error with the "}"

Br Dennis

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
HI @DennisSch ,

Apologies, a closing bracket was missing:

With({ PreFilteredData: Filter( Mappe1; Dropdown1.Selected.Result = "Alle" || LadungstraegerTyp.Value = Dropdown1.Selected.Result )}; Filter( PreFilteredData; Dropdown2.Selected.Value = "Alle" || Dropdown2.Selected.Value in 'Kunde Lieferant'.Value ) )

Was this reply helpful? Yes No