Skip to main content

Notifications

Power Automate - General Discussion
Answered

send email with an attached file from a SharePoint list.

(0) ShareShare
ReportReport
Posted on by 52

My flow works as a customer service platform using a form from microsoft forms , a list in sharepoint and power apps:

1. when the customer write the requirement in the form a new item is created in the list in sharepoint.

2. the requirement has now a pending status.

3. the representative solve the requirement and could attached any file in the app if its necessary. 

FelipeUr_0-1703714822651.png

4. when the ticket is solved the status changes, and a flow send an email to the client.

FelipeUr_1-1703714941369.png

What I need if the solution comes with an attachment, we need to send the email with that attachment if the status is solved.

 

Could you help me, thanks in advance.

Categories:
  • FelipeUr Profile Picture
    FelipeUr 52 on at
    Re: send email with an attached file from a SharePoint list.

    Thank you it worked, I appreciate your time to help me. 

  • Verified answer
    Re: send email with an attached file from a SharePoint list.

    Hi @FelipeUr ,

    When the ticket is solute, flow wants to send an email with an attachment to the client.

    First, make sure that there is a client email column in the SharePoint list.

    I did a test for your reference.

    In my scenario:

    vyetonggumsft_0-1703721907830.png

    Set conditions in triggers.

    vyetonggumsft_0-1703727441517.png

    vyetonggumsft_1-1703727463998.png

    @equals(triggerOutputs()?['body/Estatus/Value'], 'Solved')

    vyetonggumsft_1-1703722037621.png

    vyetonggumsft_2-1703722194065.png

     

    {
     "Name": @{items('Apply_to_each')?['DisplayName']},
     "ContentBytes": @{body('Get_attachment_content')}
    }

     

    vyetonggumsft_3-1703722212884.png

    My SharePoint List:

    vyetonggumsft_4-1703722294675.png

    Best Regards,

    Sunshine Gu

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard