Unanswered

Patch Text Input Fields To Multiple SharePoint Columns

(0) Share

Report

Posted on by cperry07

Hello,

I have created a gallery for an inventory list where I have a TextInput field in a column. I have another SharePoint list where I would like to write this data into where each of the inventory items have a column. I would like to Patch each value into it's respective column. Is there a way to accomplish this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Is the gallery connected to that list?

Patch(ListName, ForAll(GalleryName.AllItems,
{

ID:ID,
Column1: TextInput1.Text,
Column2:TextInput2.Text
...
}

))

Was this reply helpful? Yes No
cperry07 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

I'm actually pulling the Gallery items from a SharePoint list that I created.

My issue is there is only one TextInput field since it is a part of a gallery.

Was this reply helpful? Yes No
zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Then remove one of the TextInputs I gave in my example (which was to show you how to patch multiple columns)

If I'm understanding correctly, you have one list with at least two columns, one being the name of the item, and the other to hold the quantity, right? Then that list is the gallery's Item() property?

Give this a shot:

Patch(ListName, ForAll(GalleryName.AllItems,
{

ID:ID,
Column1: TextInput1.Text
}

))

Was this reply helpful? Yes No
cperry07 63 on at

Like
a
(0)

Report
Copy link

Link copied!

So when I add the ID:ID portion of the patch in, it fails and give a server response error and says the record cannot be found.

This is the list that's populating my gallery and the Item() portion of the gallery.

This is the list i'm trying to patch the record into.

This is the error i'm now running into

Was this reply helpful? Yes No
cperry07 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Was following up to see if you maybe have an idea to the error I mentioned regarding the server response?

Thank you!

Chris

Was this reply helpful? Yes No