Unanswered

Patch a date column and Person column from a collection (Repeating table)

(0) Share

Report

Posted on by GayathriTU

Hi all,

I have made an app with a repeating table. In the repeating table i have 3 text column,1 choice column,1 date column,1 person column. After every row i use this code and works fine:

patch 1.PNG

After every new row, i can see the values in the collection. When i want to patch the column to send the info the SharePoint i get an error.

patch 2.PNG

Name of Person Column : Owner Name (Person or Group column in SharePoint)

Name of Date column : Target Date (Date Column in SharePoint)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Gayathri_TU

You said you were getting an error in your post. Well, what is the error? Please post a picture of your error message.

What is your question? What’s going wrong?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
GayathriTU 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney
Please find the screenshot of the error

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Gayathri_TU

If you want to PATCH a blank value for each of these columns do not use "". Instead use this code:

TargetDate: Blank(), OwnerName: Blank()

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
GayathriTU 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney

Thanks for the reply,

May i know how to patch the value from collection to SharePoint person or group column.

For more information please find the screenshot for patch to collection and from collection to SharePoint

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Gayathri_TU

Please show me some sample data from your collection using the collections viewer. I believe your data is not in the correct format but I do not know what your data looks like or where it comes from.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
GayathriTU 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney
Thanks for the reply,
I am using Combo box box (ttname) in Power apps for Person data

I am using using patch function to push each row data into collection , screenshot of collection viewer,[Name to store value from combo box]

From Collection , while patching back the data to SharePoint list i am getting error in person column.
SharePoint Column Name : Owner Name (Data type: Person or group)

Thanks in advance.

Was this reply helpful? Yes No
GayathriTU 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney

Any Solution for the error

Was this reply helpful? Yes No