Share
Report
18I have a power automate flow that I am trying to list fields for a given station. So, right now I have a list rows action which filters and grabs the station ids from the step and puts it in an array. Here is what my array variable value is
[
"9cd1a940-2eff-ed11-8f6e-0022482db4d8",
"6efc3015-f671-ee11-9ae7-0022482dbf64",
"afae1b47-2eff-ed11-8f6e-0022482db4d8",
"45d2a940-2eff-ed11-8f6e-0022482db4d8",
"b67c1d4d-2eff-ed11-8f6e-0022482db4d8",
"36ebb859-ff78-ee11-8179-0022482db015",
"95ae1b47-2eff-ed11-8f6e-0022482db4d8",
"8b1d42d1-eb92-ee11-be37-0022482dbf64"
]
So, I know there are values in the array. Then I use another list rows action where I use the station array variable to get my list of fields. Here is what the fetch query looks like
<fetch mapping="logical" version="1.0">
<entity name="pod_requestfielddefinition">
<all-attributes />
<order attribute="calmp_station" descending="false" />
<order attribute="pod_displayorder" descending="false" />
<filter>
<condition attribute="pod_active" operator="eq" value="true" />
<condition attribute="pod_displaytorequester" operator="eq" value="true" />
<condition attribute="pod_displayinrequestdetails" operator="eq" value="true" />
<condition attribute="calmp_station" operator="in">
{% for stationID in @{variables('Station Array')} %}
<value>{{stationID}}</value>
{% endfor %}
</condition>
</filter>
<link-entity name="pod_requestfieldtype" from="pod_requestfieldtypeid" to="pod_requestfieldtype" link-type="inner">
<attribute name="pod_name" alias="request_field_type" />
</link-entity>
<link-entity name="pod_requestfieldvalue" from="pod_requestfielddefinition" to="pod_requestfielddefinitionid" link-type="outer">
<attribute name="pod_requestfieldvalueid" alias="pod_requestfieldvalueid" />
<attribute name="pod_requestedduedatecomment" alias="request_due_date_comment" />
<attribute name="pod_value" alias="request_field_value" />
<attribute name="pod_request" alias="pod_request_id" />
<attribute name="pod_comment" alias="pod_request_comment" />
<filter type="and">
<condition attribute="pod_request" operator="eq" value="@{outputs('Get_Request_Row_By_ID_2')?['body/pod_requestid']}" />
</filter>
</link-entity>
</entity>
</fetch>
The error happens because of the line
The error happens because of the line
<condition attribute="calmp_station" operator="in">
{% for stationID in @{variables('Station Array')} %}
<value>{{stationID}}</value>
{% endfor %}
</condition>
The exact error is
An exception System.FormatException was thrown while trying to convert input value '[REDACTED]' to attribute 'pod_requestfielddefinition.calmp_station'. Expected type of attribute value: System.Guid. Exception raised: Expected hex 0x in '{0}'.
Any help on this error is greatly appreciated! For more context the ids in my station array are the guid column of the station table if that may be an issue?
An exception System.FormatException was thrown while trying to convert input value '[REDACTED]' to attribute 'pod_requestfielddefinition.calmp_station'. Expected type of attribute value: System.Guid. Exception raised: Expected hex 0x in '{0}'.
Any help on this error is greatly appreciated! For more context the ids in my station array are the guid column of the station table if that may be an issue?
Categories:
All responses (
Answers (
