You’re offline. This is a read only version of the page.
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.
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!
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
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
