Hi,
I'm trying to update a contact record in Dynamics 365 using Flow.
I've identified the record passed it to the "Update a Record" action.
I'm updating one date field from the list of fields, however all of the optionset label fields are being selected in the update request. Due to this I am getting an error with statuscode 414 - RequestUriTooLong.
Is there a way to have the request only update the date field that is being specified and ignore all of the Optionset fields?
When peaking at the code behind the Update a record action I can also see the fields being specified, below is an extract of the fields:
Thanks in advance!
Solved! Go to Solution.
Hi @Vikesh
Firstly, the record identifier you are using is not correct. Update the flow as shown in the screenshot:
Assign the dynamic field values to all the fields that you want to update. Run the flow and check if you continue to face the issue.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @Vikesh
Can you please share a screenshot of the flow? That way we might better identify the issue and assist you with this.
There's only one field being specified to be updated in the Update record function.
Seems like I need a way to remove the optionset label fields from the request that is being generated (as seen when peaking the code)
{ "inputs": { "host": { "connection": { "name": "@parameters('$connections')['shared_dynamicscrmonline']['connectionId']" } }, "method": "patch", "body": { "_xx_title1_label": "", "_xx_3rdparty_label": "", "_xx_addnewtime_label": "", "_address1_addresstypecode_label": "", "_address1_freighttermscode_label": "", "_address2_addresstypecode_label": "", "_address3_addresstypecode_label": "", "xx_ageinyearssimple": 12, "_xx_doyoualreadyhavetime_label": "", "_xx_finalchoice_label": "", "_xx_anycreds_label": "", "_parentcustomerid_type": "", "_customersizecode_label": "", "_xx_anotheroption_label": "" .... }, "path": "/datasets/@{encodeURIComponent(encodeURIComponent('org0000000.crm00'))}/tables/@{encodeURIComponent(encodeURIComponent('contacts'))}/items/@{encodeURIComponent(encodeURIComponent(items('Apply_to_each')))}", "authentication": "@parameters('$authentication')" }, "metadata": { "flowSystemMetadata": { "swaggerOperationId": "PatchItem" } } }
I can't see any options to do so and am not sure why they are even being sent as empty strings.
Hi @Vikesh
Can you share an expanded view of the flow? Are you listing and updating the records of the same entity?
Yes, listing and updating the same records - contacts
There is a lot of fields on the contact entity so would take a lot of screenshots, below are all the fields that have some input against them.
Age in Years (Simple) is a whole number field, simply trying to save the value 12 against that field.
Hi @Vikesh
Firstly, the record identifier you are using is not correct. Update the flow as shown in the screenshot:
Assign the dynamic field values to all the fields that you want to update. Run the flow and check if you continue to face the issue.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!