Dynamics-365-Workflow-Tools icon indicating copy to clipboard operation
Dynamics-365-Workflow-Tools copied to clipboard

Get option set value returns the integer value with thousand separator

Open atajjo opened this issue 1 year ago • 0 comments

Describe the bug The "Get option set value" feature returns the integer value with thousand separator (e.g., 1,00,000 instead of 100000), causing issues when trying to use this value as a filter in other functions that use FetchXML expressions. The error is caused because the FetchXML thinks the value is a string since it contains comma characters, causing a mismatch exception (expected type is int32 but value provided is a string).

To Reproduce Steps to reproduce the behavior:

  1. Use the "Get option set value" to get a value
  2. Use this value as a filter in a function that uses FetchXML (e.g., rollup)
  3. Trigger a workflow that includes step 1 & 2
  4. See error

Expected behavior Result returned without thousand separator or commas

Desktop (please complete the following information):

  • OS: Win 10
  • Browser: Edge
  • Version: 112.0.1722.68

Workaround for this issue: After getting the value, use the string function to remove commas.

atajjo avatar May 08 '23 11:05 atajjo