Control the values in a drop down box by filtering a sharepoint choice colum

[cammc]

I have a SharePoint list  which is connected to my App. This list can be added to at any point. What I want to be able to do is have a single drop down box on the app which shows the values in the check column (this column is a calculated based on input in other fields in this list).

That part is straight forward - what I need to be able to do it have it so that the values in the drop down, will only ever show where the choice column lives value is Yes. Unfortunately I wont be able to change this from a choice field.

In the below example I would want to see value 1, value 2, and -- displayed but not value three.

I have tried filtering with if statements and multiple filters, but I cannot seem to get it to work. Im guessing the issue I am having is because im trying to use a choice field to do the filtering?

[C-Papa · Accepted solution]

Hi, try the below, change your DropDown items to

Filter(DataSource,Live.Value = "Yes").Check

[Nogueira1306]

Create a combobox and in the combobox set this values to "Check"

Where I have "Nome", you write "Check"

After that, assuming that Live is a true or false, in itens write this:

Filter( SP_List_Name; Live = true)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

[cammc]

thankyou so much - been making it far to difficult for myself and the above is simple and to the point "doh"

many thanks for your help