Changing ITEMS lookup

(0) Share

Report

Posted on by TB-12061259-0

I'm trying to change the Items lookup on a form to only render the items for a set of Skills based on what was selected on the Equipment. These are lists located in my SharePoint. Naming conventions to get this has turned into a nightmare.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TB-12061259-0,

I'm assuming:

1. you have 3 lists: Equipment, Skills and a third table to which you form is connected, let's call it Assignments.

2. The Assignments list has a LookUp column to the Skills list, called SkillsColumn

3. The Skills list has a LookUp column to the Equipment list, called EquipmentColumn

4. The control where the Equipment is selected is a combobox called cmbEquipment

5.The control where the Skill is selected is a combobox called cmbSkill

Based on the above assumptions, you can set the Items property of cmbSkill to:

Filter( Skills, EquipmentColumn.Id = cmbEquipment.Selected.ID )

Bascally this filters the Skills, based on the selected Equipment. However, this change will break how the form saves the selected value to the datasource when submitting the form, so you need to change the Update property of the DataCard for SkillsColumn to

{ Id: cmbSkill.Selected.ID }

In case any of the assumptions are not correct, please provide the correct details, I can adjust the suggested solution to match the conditions of your solutions.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
If Skills has a SharePoint lookup to Equipment, the Items property should be:

Filter( Skills, Equipment.Id = cmbEquipment.Selected.ID )

If you can share:

Structure of the Equipment list

Structure of the Skills list

Whether the column is Lookup, Choice, or Text

A screenshot of JSON(cmbEquipment.Selected)

I can give you the exact formula.

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

Both suggestions are on the right track —

Filtering the Skills items by the selected Equipment's lookup ID is the standard pattern here. The exact formula depends entirely on how the SharePoint lookup column surfaces in Power Apps though sometimes it comes through as ColumnName.Id, sometimes ColumnName.Value, depending on whether it's a single or multi-select lookup. Running JSON(cmbEquipment.Selected) like 11manish suggested is the fastest way to see the actual shape of that lookup field and pick the right syntax instead of guessing. Also worth double-checking the DataCard Update property as BCBuizer flagged, since changing the Items source on a SharePoint form often breaks the default save binding

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!

@TB-12061259-0

Wanted to check if you were able to resolve your issue?

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog My Tech Space LinkedIn

Was this reply helpful? Yes No