Answered

Adding Filter Items to combobox from sharepointlist

(0) Share

Report

Posted on by timdehaen

I'm stuck with adding choices to a choicebox. If i'm making a choice in the first choicebox, the second choicebox must be filled with only the items that have the selected characteristic.

I'm having 3 lists.

First list is called Campus, Second list is called 'gebouw' (in English Building), Thirth list is called 'lokaal' (in English called Room).

The logic behind it is: Every campus has it own set of buildings and every building has it own set of rooms. Lists are linked by the 'lookup' option in sharepoint list.

I've added as datasources to the three lists mentioned above.

When I choice ‘Vildersstraat’ only the rooms located at ‘Vildersstraat need to be added to ‘lokaal’.

I’ve written this code (don’t mind the ; In using an AZERTY keyboard so I need to replace , by ; )

AddColumns(

Choices([@Helpdesk].lokaal) As _Choices;

"lokaalhelpdesk";

LookUp(

[@Lokalen];

'Id (ID)' = _Choices.Id

).Campus

);

lokaalhelpdesk.Id = DataCardValueCampus.Selected.Id

)

What I'm I doing wrong?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

timdehaen 58 on at

Like
a
(0)

Report
Copy link

Link copied!

The whole databasestructure. That maybe makes it more obvious.

DatabaseFMApp (2)...
Nilsnutz 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Based on your datastructure it looks like you have a direct lookup from room to campus (not room -> building -> campus)
Unless I'm missing something you should be able to filter the second combobox for rooms like this:
Filter(rooms,
CampusLookupColumn.Id = campusselector.Selected.ID)

If you don't have the direct lookup room -> campus, I would clearcollect all buildings in that campus in the onchange property of the campus combobox and filter the room list like:
Filter(rooms,
buildingLookUp.Id in col_CollectedBuildings.ID)
timdehaen 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Table "Helpdesk" wasn't yet added tot de dbstructurechart.

DatabaseFMApp + h...
timdehaen 58 on at

Like
a
(0)

Report
Copy link

Link copied!

I've solved the problem by doing a Lookup in a Lookup clause.
Verified answer

timdehaen 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Set(Campusnaam;LookUp(
[@Lokalen];
'Officieel lokaal nr' = Lokaal.Selected.Value
).Campus.Value
);;
timdehaen 58 on at

Like
a
(0)

Report
Copy link

Link copied!

In the onchange i've added the code above (and a Lookup for the e-mailaddress of the helpdesk)

Code of the lookup for the helpdeskaddress

Set(Helpdeskadres;
LookUp(
[@Campussen];
'Id (ID)'= LookUp(
[@Lokalen];
'Officieel lokaal nr' = Lokaal.Selected.Value
).Campus.Id).Helpdeskmail
);;