web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Find Missing Number in...
Power Automate
Answered

Find Missing Number in Array List

(0) ShareShare
ReportReport
Posted on by 33

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 :

Falhuddin_0-1621818312246.png

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?

Categories:
I have the same question (0)
  • Verified answer
    Paulie78 Profile Picture
    8,422 Moderator on at

    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 😘

  • Verified answer
    Falhuddin Profile Picture
    33 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard