Find Missing Number in Array List

[Falhuddin]

Hi, I have a flow that can find missing number in Array list.

But it's use many API calls (Can exceed API usage) and took long time to run (20~30 minutes).

Below is my flow figure :

I use "Do Until" step to lookup missing number in array.

1) Define 1st Number (eg : 12700) ---> 1st number in array

2) Do the increment (eg : 12701)

3) Search the number (12701) in the list of Array

4) Condition (If not found run certain steps. Else, search the next number)

Each run, estimated looping is around 1100~1700 times.

Is there's any way to simplify this method?

[Paulie78 · Accepted solution]

Hi @Falhuddin 

I have created a video response for you to this question:

https://youtu.be/McVEMjBQ59M

See if you can follow what I demonstrate in the flow, it is difficult to give you exactly what you need, because I cannot replicate your exact scenario, but this should give you a good start and you should find it runs more or less instantly.

Let me know how you get on, if you get stuck I will give you a copy of the actions.

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

[Falhuddin · Accepted solution]

Hi @Paulie78 ,

Thank you for your reply and solution.

I'll used this steps in my Flow.

This Trigger & action should reduce a lot of API.