Answered

Patching into choice column in sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to patch a column from a collection gathered from an excel file using this syntax for the patching.
Patch('ATS - Candidate',ShowColumns(colCandidateTestBulkUpload,"CandidateName","EmailAddress","EndorsedtoColdCalling"));
but I am having problems with the column "EndorsedtoColdCalling" showing the error "Invalid argument type (Table), Expecting a Record value instead." Is there any way for me to modify my syntax to accommodate the patching into my choice column in SharePoint?

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try this

Patch( 'ATS - Candidate', ForAll( colCandidateTestBulkUpload As aPatch, { CandidateName: aPatch.CandidateName, EmailAddress: aPatch.EmailAddress, EndorsedtoColdCalling: {Value: aPatch.EndorsedtoColdCalling} } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I tried the code and still it shows the error whenever I get to the
EndorsedtoColdCalling: {Value: aPatch.EndorsedtoColdCalling}
but if I remove it the error goes away
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Is this a single or multi-choice column ? Also what type of field is this in the collection ?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
it is single choice and the fields in the collection are strings specifically "Yes" "No" and "Null" value choices. Appreciate your help on the matter.
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

Second part of question - what type of field is it is the collection. If it is a single choice in your list, there are only two possibilities

Text field from your collection to Choice in list (as I posted)

EndorsedtoColdCalling: {Value: aPatch.EndorsedtoColdCalling}

Choice field in Collection to Choice in List

EndorsedtoColdCalling: {Value: aPatch.EndorsedtoColdCalling.Value}

or simply

EndorsedtoColdCalling: aPatch.EndorsedtoColdCalling

Can you please re-check the field type in both source and destination

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
sorry for the late reply @WarrenBelz

it is the Choice field in Collection to Choice in List
but upon doing both
EndorsedtoColdCalling: {Value: aPatch.EndorsedtoColdCalling.Value}
and
EndorsedtoColdCalling: aPatch.EndorsedtoColdCalling
the error is still persisting
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

here is a screenshot of what I am seeing @WarrenBelz
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,
Sorry to ask again, but are both definitely single choices - it is the only explanation left (one or both are multiple choice columns). This error "Invalid argument type (Table) suggests one of them is multiple choice.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz

yes the columns in the excel file I am pulling data is single choice and the column in sharepoint I am patching in is also single choice. Correct me if I am wrong I attached the screenshots of the columns respectively
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
What does the field look like in your collection ?