Power Platform Community Forum Thread Details

This is a scheduled flow, due to run every evening to update a Sharepoint LIst. (I'm using a stored procedure to tell me which mobile phone is in who's possession. This is logged in SQL Server).

As you can see with the screenshot, I'm having to repeat the SQL stored procedure, starting with input data '1' and then '2' etc to get the output from the stored proc. i.e. who has mobile phone no.1, no.2 etc.

The 'Apply To Each' has 'update an item' - a Sharepoint list, with ID number of the row 1, 2, 3 etc. Each 'Update An Item' has update row with ID 1, then 2 etc to match the input data of the stored procedure.

This works fine once, but I'm going to have to manually repeat the stored procedure about 100 times.

Hope that makes sense? I'm totally stuck and ideally we don't want to change the stored procedure. Any suggestions or thoughts please!! Thank you.