Unanswered

Missing column when patching collection to SharePoint (Column missing is from Distinct result record)

(0) Share

Report

Posted on by naifhanis92

Hi experts,

Noob here. I'm having a problem updating collection to my sharepoint. It able to patch column with data type Text and Value but not with the result.

My collection:

All collection column able to be patched to SharePoint except column "TestMethod" and "Clause" which it is in column result (Because i use distinct function to make dependent choice)

Another record (other than test method and clause) able to be patched nicely. By the way I'm using below to do collection (OnChange). I tried to put .Selected.Value and .Selected.result but there's an error.

Below is the code to patch collection to SharePoint.

Thanks all. If there are any other info i need to provide, will happily give you guys.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report

Hi @naifhanis92 ,

The issue here is that if you want to use the process of patching a collection directly to a list as you are, then every field in the collection has to exist in the list in both name and field type/structure, so you have to make the "foot fit the shoe" so to speak. So if you are patching to (for example) a Choice field, you need a Table field with the field name Value (not Result). You can use RenameColumns to do this when you originally put this into the collection. The other option is to Patch all the fields individually and "line up" the relevant values.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
naifhanis92 on at

Like (0)

Report

OMG thanks a lot @WarrenBelz 😭. I stuck here for more than 2 days trying "lot" of things to make that right. Thanks for the help, wishing a best time for you and your family!

Was this reply helpful? Yes No