Unanswered

Editable Grid with Collection variable

(0) Share

Report

Posted on by SanjayAdsure201

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
SanjayAdsure201 85 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No