Use Collection to Update SharePoint List Column Defaults

[B4rikuda]

I may not be finding what I am looking for because I'm not searching properly but I am wondering if it is possible to have a collection within PowerApps that one can use to update the default choices listed in a SharePoint List column. 

E.g. SharePoint List Column has a default of "Red", "Blue", "Green". I collect these within the PowerApp, remove "Green", and add "Yellow". 

Is it possible to update the SP List Column default to now show "Red", "Blue", "Yellow"? 

If not, how can I get a ListBox or Dropdown to now default to the new list items when the app loads moving forward? 

[WarrenBelz]

You can use a collection for the Items of any drop-down or combo box, in fact it is good practice.

So if your collection colColors had a field ChoiceColor (avoid naming it a "reserved" word like Color), the items for the control would be

Sort(ColColor,ChoiceColor,Ascending)

Please click and accept as Solution if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[B4rikuda]

@WarrenBelz, Thank you for your reply. I understand the basics of how to use a collection and sorting but it doesn't answer my question of how to modify what is listed in the dropdown or listbox. 

Currently I am pulling the default choices from the SharePoint List into a collection and displaying them into a dropdown box. My question has to do with how can I alter these so that when they are updated (as in the example I gave above), the dropdown and listbox choices change? 

The challenge for me is that the values in the dropdown are NOT a value in a record of a SP List but rather are items of the collection of the default choices of said column. So doing a Patch or Update are meant for records but can this be done to change the default choices for a SP List Column?

[ezjensen]

following this, as I have a similar question out there.  I have an expense app that allows users to enter in line items, which then patch to a collection, but I am struggling getting that collection to patch back to the SharePoint list columns that are choice fields.

Here is my issue:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Patching-a-Collection-text-value-to-a-drop-d...

[WarrenBelz · Accepted solution]

Hi @B4rikuda ,

If I am understanding you correctly, this is not possible, SharePoint is a data source that has some bits allowing user interaction. Any changes to this need to be done in SharePoint. Is this what you were meaning?

Please click and accept as Solution if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Hi @ @ezjensen , please post your query as a new topic as it is unrelated to this one and this helps users find it.