Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Action 'Apply_to_each' failed

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

I have a automated flow which trigger an HTTP viber api. The process logic is below to better understand.

 

1. Get Records of Data from a sql view to compose a message content to HTTP viber api. (SQL Get Rows v2)

2. Get Phone numbers from sql table. (SQL Get Rows v2)

3. Setup HTTP to trigger Viber Api with each Phone numbers plus the message content from view (HTTP).

 

My problem is i can't figured out why im getting 'The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')?['Phonenumber']' is of type 'Integer'. The result must be a valid array.'

 

powerappserror.png

  • Verified answer
    MJain Profile Picture
    2,450 on at
    Re: Action 'Apply_to_each' failed

    HI @phoenixpub ,

     

    Get Phone numbers is giving you array , then why are you doing two loops in the next step . Please remove that and use your http call .

     

    Thanks

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow