You’re offline. This is a read only version of the page.
Dear All,
I want to use Collection Variable & Gallery control where I want to do CRUD operations on rows & the collection will get updated accordingly.
When searched on internet I get examples where SharePoint List is being used for binding & saving the items. There they bind SP List columns to Gallery columns like ThisItem.ColumnName etc. & do the things.
I can't use any List. My requirement is to use global collection variable having 5 columns out of them 3 are dropdowns and 2 are text values (numbers) & gallery as editable grid. Also don't know how can I show dropdown values on load so when user wants to add/edit the item, the drop down should be shown to select values. Any example will be highly appreciated.
Thanks,
Sanjay
Dear @v-jefferni ,
Thank you very much for your reply. Sorry to miss to add this in my 1st comment. For storing purpose, I need to use JSON string in SharePoint Multi-Text column. So when user will add new records, & click on Save, I want to save the JSON string to this column and when I want to edit the form, want to fetch it from same column & display values in the Gallery.
As my main form data is going to a SharePoint list, for this editable grid don't want to create separate list just for storing this data and need to use one column from my list for these values.
Any suggestions on this please.
Thanks,
Sanjay
Hi @SanjayAdsure201 ,
You can use collections as data source of Galleries, collections can have columns as well as any other data sources like Excel, SharePoint lists or Dataverse, otherwise you cannot save the changes or edit saved data.
Power Apps Editable Table/Gallery like Excel (Tutorial) - YouTube
Best regards,
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (