Hi @Tez ,
Could you please share more details about your scenario? What is the meaning of “somebody decides add another entry and use” ?
For your first question, If you want to fill the dropdown box or combo box with selected cities in that SPO list, you could apply below formula on the Items property of the control:
Distinct(ListName,Cities.Value).Result
If you want to update the selected value in the control, {Value: Dropdown1.Selected.Result} could be used in Update property of the data Card or Patch formula on a button.
For the second question, do you want to make the dropdown items like below?
Liverpool
Manchester
All
If you do want the dropdown Items like that, and add else cities, you may create a collection to collect the results then use a Patch function to add item in to it. Apply below formula on the OnVisible of the screen, and use the collection as the Items of the dropdown box:
ClearCollect(colCities,Distinct('Test List',City.Value).Result);
Patch(colCities,Defaults(colCities),{Result:"All"})
Then you could use another Patch formula to add else items to the collection.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
