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 (2)

Answers (0)

Sort by

Suggested answer

BCBuizer 22,814 Super User 2026 Season 1 on at

Like (0)

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 2,837 on at

Like (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