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.'
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
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional