Create a collection from a custom gallery

Like (0) Share

Report

Posted on 16 Apr 2021 01:00:55 by CP0822

Hi guys,

This is my situation, i have this gallery where I pull some data from a sharepoint list but then I have a custom textinput inside the gallery where the user have to type some info that I'm asking them

How can I create a collection only with this info? I should be something like this.

Thanks

Collection

C1	C2	C3
S	422	23
M	424	45
L	636	12
XL	424
XXL	212

Gallery

All responses (7)

Answers (1)

Verified answer

v-albai-msft on 20 Apr 2021 at 02:08:52

Like (1)

Report

Re: Create a collection from a custom gallery

Hi @CP0822 ,
Yes, just put the code into the OnChange property of the first TextInput control.
Then based on your requirement, clear this collection after patch into SP list.
Best regards,
Allen
CP0822 66 on 19 Apr 2021 at 16:36:57

Like (0)

Report

Re: Create a collection from a custom gallery

Hi @v-albai-msft

Where do you suggest I should set this formula? In the "On change" of the TextInput?

Many thanks.
v-albai-msft on 19 Apr 2021 at 09:24:49

Like (1)

Report
Re: Create a collection from a custom gallery

Hi @CP0822 ,
You can try this formula:
Collect(collection1,TextInput1.Text)
You can also save the Title of each record:
Collect(collection1,{Title:ThisItem.Title,Value:TextInput1.Text})
Best regards,
Allen
CP0822 66 on 16 Apr 2021 at 16:30:23

Like (0)

Report

Re: Create a collection from a custom gallery

Hi,

I want to create a local collection and then when all the text inputs are filled patch this info in mi SP list.

Any ideas?
CP0822 66 on 16 Apr 2021 at 16:28:52

Like (0)

Report

Re: Create a collection from a custom gallery

Hi Allen,

I tried your solution but I'm getting the collection like this.

How can I get only the value in the textinput without creating a table record?
v-albai-msft on 16 Apr 2021 at 03:55:52

Like (0)

Report
Re: Create a collection from a custom gallery

Hi @CP0822 ,
Do you want to create a collection with all entered values in Textinput control?
If yes, you can try this method. See my example, set OnChange property of first Textinput control to:
ClearCollect(collection1,Gallery1.AllItems.TextInput1)
Best regards,
Allen
Jagadeeshk 457 on 16 Apr 2021 at 01:10:01

Like (0)

Report

Re: Create a collection from a custom gallery

Create collection means, do you want to create local collection if so what all columns?
Or do you want to write the text ip column in sharepoint list?
If so use patch function