Answered

Need help with For each loop, Please

(0) Share

Report

Posted on by sergalej

Hello,

I'm new to Power Automate Desktop and I'm trying to build a flow that will extract text from Outlook emails and append them to an excel table. I'm able to do this but only for one email, even though I'm using a For each loop. I've reduced my code to a simple flow to try and figure out where I'm going wrong. I've tried %CurrentItem.Subject% also. I'm always able to see the first email but not the other emails stored in the %RetreivedEmails% list.

Thanks in advance for your help.

Screenshot 2022-08-03 091909.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Have you confirmed your RetrievedEmails is working properly?

I just tried just like you did, but with adding subjects to a list, and it worked fine

Was this reply helpful? Yes No
sergalej 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello ryule, thanks for looking into this.

Yes, I believe RetrievedEmails is working properly as I'm able to see the 2 emails I'm testing.

I tried what you did, and the result is a list with only one item, the first email.

Was this reply helpful? Yes No
Verified answer

ryule 929 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Yep interesting. Have you tried building a separate bot from scratch? Potentially something is corrupt, if that's even possible....ha

Was this reply helpful? Yes No
sergalej 10 on at

Like
a
(1)

Report
Copy link

Link copied!

ryule, You're a genius, that worked!

I created a new flow and with the same steps as my previous one and it worked on the first try. I will consider this solution going forward, equivalent to the "Have you tried restarting your computer?" advice.

Thanks for all the help.

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Haha yay, glad that worked!

Was this reply helpful? Yes No