Power Platform Community Forum Thread Details

Hi all,

I have a flow running that is linked to Microsoft Lists, that enables a user to create/edit an item (it's a reporting form with dedicated responses) in a specific List, which then automatically transfers the item data into a separate List.

It works completely fine for the most part, however, there is a slight issue that has arisen. Since I have some questions within the reporting form that have multiple options that a user can select, I've had to initialize variables for these questions, append them to the specific array variables and then use those variables for the Update Item action in my flow (shown below).

These are two examples of variables I've initialized.

The same two examples where the values from the original List are appended to the initialized arrays, (the data comes from the 'when an item is created or modified' action)

The 'update item' action, which uses these appended variables to fill out new items in the separate List.

All of these work, except for one specific variable ('Government Measures Implemented') and I can't seem to figure out why it's not recording any data when it's updated. It seems like nothing is being appended when the original item is created in the original List. All the code, variables and syntax are exactly the same for all variables.

When I look at the backend code for when the flow runs successfully, nothing seems to be shown within the variable, regardless of there actually being data in the field. (Shown below, the ones highlighted in red show the same two variables as in the previous examples. The first one 'Type of Political Risk' works, while 'Government Measures Implemented' doesn't despite having the same exact method of initializing.

...
"TypeofPoliticalRisk": [
{"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 5,
"Value": "Civil War"}
],
"TypeofPoliticalRisk@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"TypeofPoliticalRisk#Id": [
5
],
"TypeofPoliticalRisk#Id@odata.type": "#Collection(Int64)",
"GeopoliticalImpact_x003f_": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Entire Region"
},
"GeopoliticalImpact_x003f_#Id": 1,
"PleaseSpecify_x0028_Geopolitical": "1. Issues\n2. Problems",
"GovernmentMeasuresImplemented_x0": [],
"GovernmentMeasuresImplemented_x0@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"GovernmentMeasuresImplemented_x0#Id": [],
"GovernmentMeasuresImplemented_x0#Id@odata.type": "#Collection(Int64)",
...

Does anyone know how I could fix this? Let me know if you need more details, thanks!

Categories:

General topics