How can I get these flow items to repeat automatically?

(0) Share

Report

Posted on by matt-s77

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.

All responses (1)

Answers (0)

abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: How can I get these flow items to repeat automatically?

Hi @matt-s77

Is your ID's are fixed all the times from the input? Why not construct an array to store all the ID's? Iterate the array to get each id's and pass to your Stored Procedure?

Thanks