Answered

Combobox using choice field from Sharepoint

(0) Share

Report

Posted on by Pottterzinho

Hello guys, I'm stuck at this. I have a form where I need to filter the options from a choice field based on a selected item. To filter simple fields as text in SharePoint it's okay, my problem is getting the values from the choice field in SharePoint. I know that I will probably be using the Choices formula, but I would like to know how can I filter based on a selected item. Can you help me, guys?

Filter(List of products; Project= Project.SelectedText.Value).Type of product

This kind of formula doesn't work because returns a table. I need to figure out how I use this kind of concept to choice fields from SharePoint.

Basically, I wanna get the values from the column "Tipo de produto" based on a selected project.

Thanks for your help guys.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

RodCha 216 on at

Like
a
(0)

Report
Copy link

Link copied!
Use in your 'Dropdown/Combobox' in the 'Items' field; this formula is for the Projeto 'Dropdown':

Distinct('List of products', Projeto)

Then, in your 'Gallery':

Filter('List of products', Projeto = Dropdown.Selected.Result)
Verified answer

Pottterzinho 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help @RodCha but my intention was to get the data in a combobox. Now I figured out, I can't use the choices formula because it returns me a table, and the combobox couldn't accept. So after this, I used the LookUp formula that returns the values that I wanted.

LookUp('Lista de escolhas'; Projeto = DP_Projeto.SelectedText.Value).'Tipo de produto'

So, basically, I filter a select item from a choice column on Sharepoint not using the formula choices but using the LookUp formula.
v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Pottterzinho ,

Glad to see you solved the problem.
You could mark your answer as a 'solution' to close the case.

Best Regards,
Charie Choi