Power Platform Community Forum Thread Details

Hello Guys,

I Created a list with look up and dropdown, but dosen't work with PowerApps.

In the liston Sharepoint Online, i used Web Parts function and worked

For exemple:

Dropdown ONE: "1, 2, 3"
Dropdown TWO: "abc, def, ghi"

If i Selected Value 1, return "ABC"

If i Selected Value 2 returr "DEF"

And go on.

It's working perfect on SPOnline, but i want to work on the PowerApps.

Someone can help me how to do?

Categories:

Building Power Apps

@MarinsBertoldi

I don't know much of anything about the SPOnline webpart but I will attempt to answer your question.

For example:

Dropdown ONE: "1, 2, 3"
Dropdown TWO: "abc, def, ghi"
If i Selected Value 1, return "ABC"
If i Selected Value 2 returr "DEF" 
And go on.

It's working perfect on SPOnline, but i want to work on the PowerApps. 
Someone can help me how to do?

Mini-Tutorial

Suppose you create the following collection with key-value pairs. Put this code within the OnSelect property of a button.

ClearCollection(myCollection,{key:1, value:"ABC"},{key:2, value:"DEF"},{key:3, value:"GHI"})

Click the button.

Now create a new ComboBox. Put the following code into the button properties below

Items: myCollection
DisplayFields: ["value"]
AllowMultipleSelection: False

Finally, create a label. Put this code in the Text property of the label.

LookUp(myCollection,key=ComboBox1.Selected.key,value)

Now go ahead and set the dropdown to

The result shown in the label will be

ABC

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."