Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Attach file from sharepoint list and email it

(0) ShareShare
ReportReport
Posted on by 33

I have a flow.

 

When a new item is created or modified in sharepoint list, e email is sent to a certain Manager with certain details and any files are also then attached to the email.

 

The flow works but when the Manager opens to attachment it isnt correct. The flow and the message within in the attchment below.

 

It used to work, so I have obviusly chnaged something in error!

 

sclarke23_1-1697108854262.pngsclarke23_2-1697108936366.pngsclarke23_3-1697108982418.png

The error message:

sclarke23_4-1697109152505.png

Any help would be much appreciated.

  • Michael E. Gernaey Profile Picture
    41,027 Super User 2025 Season 1 on at
    Re: Attach file from sharepoint list and email it

    Hi @sclarke23 

     

    Because Get Attachments (body) returns an Array, that when you loop through it, you would see the Dynamic stuff, when inside the Apply to Each

     

    What is normally done, is you do Get Attachments, Apply to each, and then You have an array variable that you keep adding the attachments too.

     

    Then in your Attachments for emails etc you have to iterate through and put them all there.

     

    If you know for sure there is only one, then you could use the Ordinal position of the Get Attachments body Array which would be [0] to grab only that one Attachment (Content Bytes)


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • sclarke23 Profile Picture
    33 on at
    Re: Attach file from sharepoint list and email it

    Hi,

     

    I had got to the point i knew it was this bit was incorrect. When going to the dynamic content the only option available for body is get attachments. There is no option for body get attachment content. I am not sure why it is not appearing?

    sclarke23_0-1697141109140.png

     

  • Michael E. Gernaey Profile Picture
    41,027 Super User 2025 Season 1 on at
    Re: Attach file from sharepoint list and email it

    Hi @sclarke23 

     

    Hi I think its here 

    FLMike_0-1697130053631.png

     

    I dont think body points to the actual content, i think the content is inside the body. please review the Body itself to get the Content


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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,658 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow