Share
Report
28 UPDATED 12/16/24
I have two SharePoint lists.
A with 306 records
B with 950 records
My flow is structured as follows
step 1 - manual start
step 2 - get items from SharePoint A
step 3 - get items from SharePoint B
step 4 – Use Select action to get the unique ID from SharePoint A
step 5 – Use Select action to get the unique ID from SharePoint B
Step 6- Use Initialize Variable action on A ID’s
Step 7- Use Initialize Variable action on B ID’s
step 8 – Use Compose action to Intersect VarA and VarB
All good to this point. I checked the Compose results manually for accuracy.
Now I want to take the Compose results of approx.. 180 matching ID’s and update SharePoint list A for those specific ID’s.
I tried various methods. I am currently at a “apply to each” with the update SharePoint item action inside. The error message is “ Action 'Update_item' failed: The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'id' is required to be of type 'Integer/int64'. The source type/format 'Array' of the value…….is not convertible to type/format ‘integer/int64’
Okay. So, what is my step to convert an array of 184 ID numbers to something acceptable?
I have two SharePoint lists.
A with 306 records
B with 950 records
My flow is structured as follows
step 1 - manual start
step 2 - get items from SharePoint A
step 3 - get items from SharePoint B
step 4 – Use Select action to get the unique ID from SharePoint A
step 5 – Use Select action to get the unique ID from SharePoint B
Step 6- Use Initialize Variable action on A ID’s
Step 7- Use Initialize Variable action on B ID’s
step 8 – Use Compose action to Intersect VarA and VarB
All good to this point. I checked the Compose results manually for accuracy.
Now I want to take the Compose results of approx.. 180 matching ID’s and update SharePoint list A for those specific ID’s.
I tried various methods. I am currently at a “apply to each” with the update SharePoint item action inside. The error message is “ Action 'Update_item' failed: The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'id' is required to be of type 'Integer/int64'. The source type/format 'Array' of the value…….is not convertible to type/format ‘integer/int64’
Okay. So, what is my step to convert an array of 184 ID numbers to something acceptable?
Categories:
I have the same question (0)
All responses (
Answers (
