Skip to main content

Notifications

Power Automate - General Discussion
Answered

Phone numbers in Power automate devided for parts

(0) ShareShare
ReportReport
Posted on by

Hi, I'm looking for solutions with phone numbers. I have a bit more than 3000 phone numbers and I want to devide them for 6 parts where one of them counts 500. Problem is when I do this operation with function "

take(outputs('Compose_2'),div(length(outputs('Compose_2')),5))" i takes properlu 499 phone numbers and last phone number is not valid for example: 123 456 789 and outcome of this last number is 123 45. Do you know how to devide them and how to take these parts to process further in flow.
Flow look like this:
buszi99_1-1665999096489.png

 


Compose 2 - I store there phone numbers

buszi99_3-1665999178097.png

 

Compose 4 - it's the outcome of function "take(outputs('Compose_2'),div(length(outputs('Compose_2')),5))"

Phone numbers are randomly generated

Outcome with numbers

buszi99_2-1665999155214.png

And as you can see last phone number is not complete

 

Best Regards 
Kamil
Categories:
  • buszi99 Profile Picture
    buszi99 on at
    Re: Phone numbers in Power automate devided for parts

    I will try this, but second question is: for example how i can take the other parts of this phone numbers to paralel branches ?

  • Verified answer
    Re: Phone numbers in Power automate devided for parts

    Hi @buszi99,

    Do you want to divide your phone set into 6 groups of 500

    The reason why you have this problem is that your phone sets a string, and when you use take() you can only get the preceding characters.

    I recommend using chunk() to group them. Before this, use split() to distinguish each phone number.

    I did a test for you to see, in my scenario I have 10 phone numbers and I divided them into 5 groups of 2.

    chunk(split(outputs('Compose'),','),2)

    Here you could replace the number 2 with 500 in your screnario.

    vqiaqimsft_0-1666078651580.png

     

    vqiaqimsft_1-1666078651588.png

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard