Unanswered

Using Sharepoint list reference with filtering choice options

(1) Share

Report

Posted on by abartosz

I use Power Apps as an interface for populating Sharepoint lists. Everything works fine but I would like to filter the options available in combobox control that is used to populate the list reference field (I want to have the posiibility to connect 2 different list items by reference). Right now I have references to all list elements available to choose:

The 'Test 1' element has True value in true/false column 'Wykonana'

So I would like to have only 'Test 2' visible in the combobx control of the form. I tried filtering but couldn't figure out how to make it work:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

hi @abartosz

Sorry I am confused (easily my wife says), can you please try to explain it again, with shorter sentences and example.

I would like to filter the options available in combobox control that is used to populate the list reference field

So where do the options in this box come from? An Optionset, a String list??

(I want to have the posiibility to connect 2 different list items by reference). Right now I have references to all list elements available to choose:

1. I don't know what a list reference is, as you haven't explained, or how this combobox connects the rest of the Ui to that reference to load something.

Dumb it down for me 🙂

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
abartosz 2 on at

Like (1)

Report

Sorry, maybe I tried to keep it too short 😄 The fact that I use Polish interface and had to translate all the controls may also be a reason. So my list has a column which references to another item from the list (I translated the column type as reference, not sure if this is how this type is named in English). Sometimes I need the list element to refer to another element. When generated the form in Power Apps the Items field contains the code as follows:
Choices([@'Do wyceny'].Wycena_x0020_odniesienia)

With this code when clicked on combobox I can choose from all the elements currently in the list. The same is when I add the list item in Sharepoint - I can refer to all elements in the list (currently Test 1 and Test 2):

I would like to filter the options available in controlbox so that there are only elements with specific value in column called ‘Wykonana’ available to choose from.

Was this reply helpful? Yes No
abartosz 2 on at

Like (1)

Report

The solution is available here: https://michelcarlo.com/2022/04/30/power-apps-sharepoint-lookup-combobox/

Was this reply helpful? Yes No