Apply to Each action: SP Create Item. Only allows for one input

[Anonymous]

Please reference this post for background:

https://powerusers.microsoft.com/t5/Building-Flows/Import-XML-to-SharePoint-list-with-Flow-and-xpath...

When pulling multiple data points from XML, I am only able to loop through one array (IdArray) when trying to create list items in SharePoint. how can you pull in data from multiple arrays? I also have a Company Id array that I want to apply to the Title field.

Without being able to add the Company ID into the Apply to Each, the array comes through as the actual array, not the values:

Thank you for your help - let me know if I can provide any additional information.

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

Please try the following configuration and expression to extract data in XML:

Id:

xpath(xml(item()),'string(/Table/Id)') 

Company_ID:

xpath(xml(item()),'string(/Table/CompanyId)') 

Best Regards,

[joshlwulf]

Thanks! I had this same question and finding this thread was huge for me.