Creating a list from a set of records - issue appending IDs from SharePoint list to array of string

Li Kane

Hello,

I've been working on a flow to create a Constituent list based on the results from a query. After running the query and downloading it as a .csv file, it is saved in SharePoint as a list (I'm considering changing this in the future to whittle down the number of steps).

The issue that I'm running into involves the array of string parameter that tells Raiser's Edge which Constituent records to add to the list. I think the problem has to do with the nested brackets [["163601", “163605”]] which I believe means that the parameter is currently an array of an array vs. an array of string. I can't figure out how to store the values for record IDs in one variable without making it an array of an array.

Including screenshots below. Any advice is appreciated, thanks!

Alex Wong

@Li Kane
Main issue you failed, the way you pass in the parameter into ID(s) field. Show the edit view of the action.

2nd issue, your flow will run slow if there are few hundred records. There is no need to use “Apply to each". You can use action like “Select” to get an array of system record ids in it's ["1","2","3"] simple string array format to pass into ID(s).

Li Kane

@Alex Wong
I tried to use “Select” in a previous attempt but was still running into array/string issues so I switched back to using a for loop. Definitely will take another stab at using Select if it's more efficient though.

Screenshots of the edit view below.

Alex Wong

@Li Kane
The issue you have is how you input the Compose dynamc content onto the ID(s) item.

Click on the icon on the upper right corner of ID(s) item to input the whole array. What you are doing now is inputing the whole array as one value of ID.

Li Kane

@Alex Wong
Got the flow to work after fixing the dynamic content input issue. And I switched from the for loop to the Select action so it's running much faster. Thank you for your help!!