Answered

Save the content of the gallery in the collection to add to the SharePoint list as a single row.

(0) Share

Report

Posted on by Manigra

I want to enter data in three "text input fields" in a gallery, first to save them in a collection and then to patch them as a single row in a SharePoint list.

"On Start" I have created a collection - ClearCollect(ServerDetails,{ServerName:"",RackLocation:"",SNOWTask:""})

Collection is also showing all details, but I have no idea on how to bring this to a SP list in a single line.
Can you please help?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Manigra

For putting the text input values from gallery in the collection:

Clear(ServerDetails); ForAll(GalleryServerDetails.AllItems As Item, Collect(ServerDetails, { ServerName:Item.TextInputServerName.Text, RackLocation: Item.TextInputRack.Text, SNOWTask:Item.TextInputTask.Text } )

For putting it in one line is SP, Do you want all the text concatenated into one column? What are the columns of your SP list?

Was this reply helpful? Yes No
Manigra 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Adrian,

on SharePoint I have three columns called ServerName, RackLocation and SNOWTask and the aim is to store all servers names in column "ServerName" , all Rack Location details in "RackLocation" and Task information's in "SNOWTask".,

Thank you!

Thank you

Was this reply helpful? Yes No
Manigra 23 on at

Like
a
(0)

Report
Copy link

Link copied!

My collection is made out of a Gallery ( three Text Input fields ) .. and the save Button is made like this :
Patch(ServerDetails, ThisItem, {ServerName: TextInputServName.Text, RackLocation: TextInputRackLoc.Text, SNOWTask:TextInputSNOW.Text})); Collect(ServerDetails, {ServerName: "", RackLocation: "", SNOWTask: ""})

So my collection consists of three columns and one column each is to be assigned to a Share Point column - in only one line.

Thank you

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Manigra

When you say in only one line, did you meant only one row, correct?

If so then you can use the Concat function to combine text into one row.

Patch(ServerDetails, ThisItem, { ServerName: Concat(GalleryServerDetails, TextInputServName.Text, "; "), RackLocation: Concat(GalleryServerDetails, TextInputRackLoc.Text, "; "), SNOWTask: Concat(TextInputSNOW.Text, "; ") }));

Was this reply helpful? Yes No
Manigra 23 on at

Like
a
(0)

Report
Copy link

Link copied!

correct - one row.

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Manigra

Did this one work for you?

Patch(ServerDetails, ThisItem, { ServerName: Concat(GalleryServerDetails, TextInputServName.Text, "; "), RackLocation: Concat(GalleryServerDetails, TextInputRackLoc.Text, "; "), SNOWTask: Concat(TextInputSNOW.Text, "; ") }));

Was this reply helpful? Yes No
Manigra 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Adrian,

unfortunately, it did not work, I am a complete novice.
Eventually I need to explain better what I have:
- my Submit Button is now executing the following command
Patch(IMACD_Request_List,Defaults(IMACD_Request_List),
{'Server Name':Text(TextInputServerName)})

where IMACD_Request_List is my SharePoint list
where 'Server Name' is the column, I want to patch

Now my aim is to get multiple data out of a Gallery ( ServerName, RackLocation and SNOWTask) to each column in that SP but in only just one row.

Hopefully I could explain myself better.

Thanks!

Was this reply helpful? Yes No
Manigra 23 on at

Like
a
(0)

Report
Copy link

Link copied!

sorry, now a little more specific, I have three columns on SP I want to patch with data out of the Gallery and the command that is working now is:

Patch(IMACD_Request_List,Defaults(IMACD_Request_List),
{'Server Name':Text(TextInputServerName)},
{'Rack Location':Text(TextInputRack)},
{'SNOW Task':Text(TextInputTask)}
)

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Manigra

No worries. So let's say your gallery named GalleryServerDetails has 3 text input boxes (TextInputServerName, TextInputRack, TextInputTask)

You want to patch these details into your Sharepoint list named IMACD_Request_List in one row like so:

Is this correct so far?

If so, then you can try this one on your submit button:

Patch(IMACD_Request_List,Defaults(IMACD_Request_List), {'Server Name':Concat(GalleryServerDetails,Text(TextInputServerName),"; ")}, {'Rack Location':Concat(GalleryServerDetails,Text(TextInputRack),"; ")}, {'SNOW Task':Concat(GalleryServerDetails,Text(TextInputTask),"; ")} )

If there are errors on this formula, let me know where the error is and what it says.

Was this reply helpful? Yes No
Manigra 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Adrian, I'll give it a try next week and will report back to you.
Thanks for your help.

Was this reply helpful? Yes No