You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
Use the "Get option set value" to get a value
Use this value as a filter in a function that uses FetchXML (e.g., rollup)
Trigger a workflow that includes step 1 & 2
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.
The text was updated successfully, but these errors were encountered:
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:
Expected behavior
Result returned without thousand separator or commas
Desktop (please complete the following information):
Workaround for this issue:
After getting the value, use the string function to remove commas.
The text was updated successfully, but these errors were encountered: