Lookup question with multiple conditions

(0) Share

Report

Posted on by Sajarac

3,276

Hi there.

I hope someone could point me in the right direction:

I can't figure out this lookup formula. I need to retrieve a value based in a couple of conditions.

In my gallery I have my customer, customer location and level based in that I need to see in a label the percentage associated with the customer.

the data to retrieve is stored in a collection

Please see the below chart:

So for the parts label located outside of the gallery is:

a lookup condition that checks the BrowseGallery.Selected and check the Collection and like in this case if the customer is in Canada and the level = 2 for parts the values to retrieve = 8.3%

Any help please?

And thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sajarac ,

The problem you have is that you cannot refer to a column (Canada) dynamically - you would have to hard-code that. What exactly is being selected from the drop-down (what is the Items property)

Was this reply helpful? Yes No
Sajarac 3,276 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you very much for your prompt response. I don't have a dropdown the data there is just a representation on how the Collection looks like.

And the gallery is an standard gallery when you create an app from a share point list.

regards

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sajarac ,

Can you please give me (example lists if you like) the Column names of both lists, the list names and the Items of the drop-down.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @sajarac,

Do you want to populate the Label based on Gallery selected and retrieve value from the collection?

Could you please share a bit more about the scenario?

Set the Text property of the Parts Label as below:

If(BrowseGallery.Selected.CustomerLocation="Canada", LookUP(Collection,Level=BrowseGallery.Selected.Level && Items="Parts").Canada, If(BrowseGallery.Selected.CustomerLocation="USA", LookUP(Collection,Level=BrowseGallery.Selected.Level&& Items="Parts").USA, LookUP(Collection,Level=BrowseGallery.Selected.Level&& Items="Parts").Others ) )

Set the Text property of the Services Label as below:

If(BrowseGallery.Selected.CustomerLocation="Canada", LookUP(Collection,Level=BrowseGallery.Selected.Level && Items="Services").Canada, If(BrowseGallery.Selected.CustomerLocation="USA", LookUP(Collection,Level=BrowseGallery.Selected.Level&& Items="Services").USA, LookUP(Collection,Level=BrowseGallery.Selected.Level&& Items="Services").Others ) )

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No