How to store multiple column values in a gallery into single column values in SharePoint list.

(0) Share

Report

Posted on by Himasri

Hi ,

I have a gallery in powerapps as

Product ,Quantity, Okt-23,Nov-23,Dez-23,Jan-24,Feb-24,Mar-24........ //Column Names

Abc 1. 0. 0. 0 .1. 0. 0

Xyz. 3 0. 0. 0 .2. 1 0

Pqr. 2 0. 0. 0 .1. 0. 1

Lmn . 3 0. 0. 1 .1. 1 0 // Values

And Have a SharePoint list as

Product. Quantity. Month //Column Names

Abc. 1. Jan-24

Xyz. 2. Jan-24

Xyz. 1 Feb-24

Pqr 1. Jan-24

Pqr 1 Mar-24

Lmn 1 Dez-23

Lmn 1. Jan-24

Lmn 1. Feb-24. //Values

have to store that gallery values as below in SharePoint list , and I am displaying these SharePoint list values only as default in that gallery months columns And product & quantity displaying from another SharePoint list in gallery.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Himasri ,

I assume there is a collection:

ClearCollect( CollectionName, {Product:"Abc",Quantity:1,'Okt-23':0,'Nov-23':0,'Dez-23':0,'Jan-24':1,'Feb-24':0,'Mar-24':0}, {Product:"Xyz",Quantity:3,'Okt-23':0,'Nov-23':0,'Dez-23':0,'Jan-24':2,'Feb-24':1,'Mar-24':0}, {Product:"Pqr",Quantity:2,'Okt-23':0,'Nov-23':0,'Dez-23':0,'Jan-24':1,'Feb-24':0,'Mar-24':1}, {Product:"Lmn",Quantity:3,'Okt-23':0,'Nov-23':0,'Dez-23':1,'Jan-24':1,'Feb-24':1,'Mar-24':0} );

Please try this formula to submit records,

ForAll( CollectionName, If('Okt-23'>0,Collect(YourSPList,{Product:Product,Quantity:'Okt-23',Month:"Okt-23"})); If('Nov-23'>0,Collect(YourSPList,{Product:Product,Quantity:'Nov-23',Month:"Nov-23"})); If('Dez-23'>0,Collect(YourSPList,{Product:Product,Quantity:'Dez-23',Month:"Dez-23"})); If('Jan-24'>0,Collect(YourSPList,{Product:Product,Quantity:'Jan-24',Month:"Jan-24"})); If('Feb-24'>0,Collect(YourSPList,{Product:Product,Quantity:'Feb-24',Month:"Feb-24"})); If('Mar-24'>0,Collect(YourSPList,{Product:Product,Quantity:'Mar-24',Month:"Mar-24"})) )

Best Regards,

Bof

Was this reply helpful? Yes No
Himasri 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
Thanks for your response.

I have a gallery like this
Product ID, Product, Quantity comes from a Product_Details Sharepoint list and Months data comes from Product _Planner SharePoint list based on Product ID and Product by Default.
Now If I change the Month values in the editable gallery then I have to save that in the Product _Planner SharePoint list which has Product_ID,Product,Quantity,Month Column Names without any duplicate data.
Please help me out.

Thanks!

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Himasri ,

You could us Gallery.Allitems to get all the value inside the gallery.

Best Regards,

Bof

Was this reply helpful? Yes No
Himasri 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
My gallery has so many items so it's taking much time to just submit it. So, I am trying to select a button that collects the edited row from the gallery whenever a field is edited without duplicate data. And then submit that data to SharePoint list.

Thanks

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Himasri ,

You could set the Okt-23 text input control's OnChange property to:

Patch( YourSPList, LookUp(YourSPList,Product=ThisItem.Product && Month="Okt-23") {Quantity:Self.Text} )

or

Patch( YourSPList, LookUp(YourSPList,Product=ThisItem.Product && Month="Okt-23") {Quantity:Value(Self.Text)} )

And do the same thing for other text inputs.

Best Regards,

Bof

Was this reply helpful? Yes No
Himasri 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

Thanks for your response that help alot.

Best regards

Was this reply helpful? Yes No
Himasri 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
I have to submit my data with a button and when editing gallery it should be stored in a collection without any duplicates.
And now Month column in the SharePoint list is Date column.
Please help me out.

Thanks!

Was this reply helpful? Yes No