Lookup/filter a SharePoint List column, by another column in the last, to show the results in a combobox.

(0) Share

Report

Posted on by JimboSey

321

Hi,

Ok in my App, I have a form, data source is a SP List, what I want to achieve is...

I have a combobox (combobox1) in the form, which looks up by SharePoint list at the 'Asset Number' column (single line of text) which contain number for example 1, 2 , 3) these numbers can be repeated.

The code I used in items of combobox1 is

Distinct(WorkplanT1, 'Asset Number').Result

What I want to achieve in another combobox (combobox2) within the form is to filter the list by the Asset number selected in combobox1, then show me all the results contained another column 'Asset details' (Single line of text) which contain the asset number selected at combobox1.

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JimboSey

There is no need for the .Result in ComboBox1. ComboBox2 Items property: Filter(WorkplanT1, 'Asset details' = Combobox1.Selected.Result)
JimboSey 321 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply,

Apologies, I mentioned I'm using combobox1 for the filter, on checking, I'm using a text box,

So the textbox will automatically populate based on a selection elsewhere in my App, the textbox relates to the number in the Assest's Number column,

So in my list there could be say three rows that have the number 4 in the Assests number, I want to filter the list by the prepopulated number in my textinput on the form, then show a list in comobox2 of all the reults from the Asset Deatils column each row that contain the number 4 in the Asset Number.

So there could be three rows that that have asset number 4, and the asset details in each row could be, example.... Row1 Laptop, Row2, Monitor, Row3 Keyboard... I want to display those 3 results in combobox 2
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JimboSey

ComboBox2 Items property: Filter(WorkplanT1, TextInput1.Text in 'Asset details')
adedapo 256 on at

Like
a
(0)

Report
Copy link

Link copied!

// Items property of ComboBox2
Filter(WorkPlan1, 'Asset Number' = TextInput1.Text).'Asset details'