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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Not able to iterate ov...
Power Automate
Unanswered

Not able to iterate over rows from excel

(0) ShareShare
ReportReport
Posted on by

I need to email contacts listed in a column. I can send an email, but only the first contact gets an email. I can't seem to figure out how to configure my flow to iterate over the rows so that everyone contact gets an email. 

Categories:
I have the same question (0)
  • Shuvam-rpa Profile Picture
    891 Super User 2024 Season 1 on at
    Re: Not able to iterate over rows from excel

    @Anonymous please send us the screenshot of your flow.

  • Community Power Platform Member Profile Picture
    on at
    Re: Not able to iterate over rows from excel

    Value is equal to email. 

    dclay_1-1656612475821.png

     

     

  • v-bofeng-msft Profile Picture
    on at
    Re: Not able to iterate over rows from excel

    Hi @Anonymous ,

     

    Could you please check the output of the 'list rows' action in run history?

     

    Best Regards,

    Bof

  • Verified answer
    Shuvam-rpa Profile Picture
    891 Super User 2024 Season 1 on at
    Re: Not able to iterate over rows from excel

    @Anonymous hi,

    have tested out same flow it works fine for me, the possible reason it not work for you because in mail column 

    of yours there is some chance of special characters, could you send us screenshot of excel sheet if possible.

     

    please check the below screenshot as refrence

     

    Shuvamrpa_0-1657009468690.png

    Shuvamrpa_1-1657009504953.png

    please check if your mail columns look similar to screenshot or not --- it have hyperlink formatting or not.

     

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • Community Power Platform Member Profile Picture
    on at
    Re: Not able to iterate over rows from excel

    My issue was that some of my rows had been taken out of the table and I didn't catch it. The content was still there, however it wasn't formatted as being as a table anymore. I think this happened because in my initial testing I was copying and pasting between different excel sheets.
    Thank you @Shuvam-rpa for point that out. 

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard