Power Apps Drop Down from Sharepoint List - customise to show these items if this option is selected

[KatLane]

Hi.

I have a sharepoint list and I'm customising the form in power apps.

I have a drop down list of documents, but I only want certain items to be visible based on a previous selection.

For example the three document categories I have are 'Employment', 'Maintenance' and 'CPD & Licensing'.

If I select 'CPD & Licensing', I only want to see 'Real Estae Certificate / Licence' and 'CPD Statement' to appear.

If I select 'Maintenance', I only want to see 'Drivers Licence', 'Car Insurance', 'Car Registration' etc.

If I select 'Employment', I only want to see 'Letter of Offer', 'Job Description', 'Employment Agreement' etc.

I'm aiming to remove the margin for error in which category certain documents belong.

Currently I have one column in my SP list and I've customised the items for the CPD & Licensing category.

I've also added additional fields through Power Apps for the other two categories and customised those item lists.

I've used this formula (and variations of same based on which category and list I'm linking) with success to only show the specified items, by way of only showing the document list that relates to that category.  So I have three versions of the below code, one for each category and its matching document list.

If(DataCardValue5.Selected.Value="CPD & Licensing",true,false)

BUT, the other two document lists aren't displaying in the SP list, because they were created directly in Power Apps.

See below, you'll notice that there are no document types listed next to 'Maintenance' or 'Employment'.

I dont want to recreate the other two in SP as this will give me three columns with staggered results depending on which category is picked.  I want to display one 'Document Type' column in SP, filled with the correct document type for that category.

So I'm after a solution to either display the other two document type lists in SP (without adding them in side by side so they look like three different columns) or a formula to be able to have one document type list, but only display the nominated items based on the document category picked.

Also, side note, does anyone know why 'CPD Statement' is displaying differently to 'Real Estate Certificate / Licence' when they're both in the same category?

[C-Papa · Accepted solution]

Hi, you can do this with IF() function on your dropdown items, the below formula should do it...

If(Dropdown1.Selected.Value = "CPD & Licensing",["Real Estate Certificate / Licence", "CPD Statement"],If(Dropdown1.Selected.Value = "Maintenance",["Drivers Licence","Car Insurance","Car Registration"],If(Dropdown1.Selected.Value = "Letter of Offer",["Letter of Offer","Job Description","Employment Agreement"])))

Dropdown1.Selected.Value is you first dropdown that filters the second, you may need to change the name / element to suit. 

[KatLane]

That's perfect, thank you 😀

I also managed to figure out why some of types look different - format column > choice pills!