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 Automate - Building Flows
Unanswered

Power Automate Flow - Apply to Each Sharepoint Column Details Issue

(0) ShareShare
ReportReport
Posted on by 47

Hi,

 

I have made an app which allows for the upload of up to 5 .msg files. These are submitted to a sharepoint location and converted to .pdf using a onedrive. The intention is to then send the files back to the person who submitted them (currently planned for attaching all .pdfs submitted to a single email, but will work on that once i've fixed current issue). 

 

I am using the "modified by" column in the sharepoint site to get the email address of the uploader. When I do this, I enter the "Apply-to-each" loop , which when combined with the send an email v2 function causes duplicate emails to be submitted (3 x the upload amount for 5 uploaded .msg files). 

To get round this I tried to initialise a variable with a string / array, and then setting the string / integer in the loop. When I do this, for a string, the email address is tripled (which explains the 3 x issue mentioned earlier) and when using the integer, the email address added for each loop - so the first attachment sent back would have 1 email populated, the second 2 email addresses populated, etc - giving the 15 emails mentioned earlier. 

I'm trying to find a way to complete this and getting nowhere at the moment. It would be great to use a User().Email TextInput field on the app and apply this to the Send and Email v2 function in the flow, but havent worked this out quite yet.

 

Any help appreciated!

 

 

I have the same question (0)
  • chicken_1 Profile Picture
    47 on at
    Re: Power Automate Flow - Apply to Each Sharepoint Column Details Issue

    okay, think I might have solved this. I added a Text Input requirement to the PowerApps part of the flow and then send the User().Email textinput in the Flow.run code on button press. Seems to be functioning as expected at the moment - emails sent for 5 attachments and the "ask in powerapps" textinput is giving a single email address. Next to add the ability to retain multiple attachments and send in a single email.

  • chicken_1 Profile Picture
    47 on at
    Re: Power Automate Flow - Apply to Each Sharepoint Column Details Issue

    any apply-to-each fields create multiple emails to be received. 

    I tried this guide and i receive 5 emails, each containing the 5 uploaded attachments.

     

     

     

    any help?

  • chicken_1 Profile Picture
    47 on at
    Re: Power Automate Flow - Apply to Each Sharepoint Column Details Issue

    i think my issue is with the powerapps, which is causing the flow to be run 5 times (once per file uploaded). how can i upload the files in a single go?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard