How to do Set() for Combobox whose items is from a LookUp field in Sharepoint List?

(0) Share

Report

Posted on by rzainm

107

I have a combobox whose items are from a lookup field in a list.

Items:

Choices(SPList.Country)

I wanted to set a variable with a lookup() based on a combobox item since I'm going to use that for a switch case.

I tried doing

Set(_Country, LookUp(SPList, 'item' = _item, Country))

Set(_Country, LookUp(SPList, 'item' = _item, Country).Value)

but theres an error in the Switch function and_Country returns blank if i used UpdateContext.

Switch(_Country,
"USA",
Set(_rates, _usRate),
"EU",
Set(_rates, _euRate))

Any help or workarounds is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @rzainm

Try this

Set(_Country, LookUp(SPList, Country = _item).Country)

Switch(_Country,
"USA", Set(_rates, _usRate),
"EU", Set(_rates, _euRate)
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
rzainm 107 on at

Like (0)

Report

Hi @Rajkumar_404

May I know why Country = _item in the Look up? _item is sort of like the item number.

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

The expression Country = _item in the LookUp function is used to find the record in the SharePoint list where the 'Country' field matches the selected item in the combobox.

if the combobox items are the names of countries, and the SharePoint list has a field called 'Country' that contains the same country names, the expression Country = _item will find the record in the SharePoint list where the 'Country' field matches the selected item in the combobox.

Thanks!

Was this reply helpful? Yes No
rzainm 107 on at

Like (0)

Report
Hello @Rajkumar_404
I tried from
Set( _Status, LookUp( SPList, 'Entry No.' = _entry, Status ).Value )
to
Set( _Status, LookUp( SPList, Status = _entry ).Status )
It says these types can't be compared "Record" (which is the Status), "Number" (which is the _entry).

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

What does the data type of the Country column in SharePoint?

Was this reply helpful? Yes No
rzainm 107 on at

Like (0)

Report

Country column in SPList is look up type to Countries list. Combo box items is Choices(SPList.Country).
'Entry No.' column is number type in SP List.

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Try this

Set( _Status, LookUp( SPList, Value('Entry No.') = _entry, Status.Value ) )

Was this reply helpful? Yes No