Save attachments to a sharepoint library

(0) Share

Report

Posted on by ram_ESP

Hi Team,

Good day to you all. I am new to power automate usage and wanted to achieve an option below.

SharePoint Document Library: Email Reports

Shared Mailbox: emailreport@abc.com

I have created a service account(srv-act@abc,com) in Office 365 and assigned a Business Basic License and provided mailbox delegation to the above mentioned shared mailbox.

I wanted to create a flow under my service account where emails with attachments should be saved to above mentioned SharePoint Document Library. Please note that this service account has full control to the SharePoint site and respective document library.

I have tried a manual and using built in templates but none of the options are positive on my end.

Please assist on the same.

Thanks,
Ram

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

AnthonyAmador 2,553 Moderator on at

Like (0)

Report

Hi @ram_ESP

Try something like this.

It works for me, hope this can help you.
Cheers.

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Hi Anthony Amador,

Thank you for your response. I received an error below when I use my service account which has all apps subscribed via basic license. If I add my account which is not a service account and just a E3 and that connection works.

What could have happened to this service account? Should I re-create this service account from scratch?

Thanks,
Ram

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Adding to my previous reply, that service account is still running another flow. Should I use different account for this flow? Or I can use single account for multiple flow connection?

Thanks,
Ram

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Hi Anthony,

I received the below error when I use "When an email arrives to a shared Mailbox" option.

The specified object was not found in the store., The process failed to get the correct properties.
clientRequestId: 1b7c3648-db6d-4919-b6ab-84ad009eb2b9
serviceRequestId: 5608c8bd-26cd-419b-99a2-2762744f28c8

I had used my another account as connection here and not the service account. Because service account failed connection as per my previous response screen shot.

Thanks,
Ram

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Noticed another error when I click Inbox on the shared Mailbox folder field in the power automate flow first step.

Thanks,
Ram

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on at

Like (0)

Report

Hi @ram_ESP

In this link you can check the differences between the business plans, the basic plan does not include Outlook so that could be the problem. You can check it by clicking on the three dots and try adding a new connection.

You can use the same account for different flows, you don't have to create different accounts for other flows.

I think the problem could also be the permission to access the shared mailbox, in this link you can check how to add members to a shared mailbox, one way to check if you already have access is to try access the shared mailbox from the Outlook account you are using, permissions can take up to 60 minutes to take effect.

Hope this can help you.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: https://docs.microsoft.com/en-us/power-platform/admin/get-help-support/

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Hi Anthony,

I created a new shared mailbox and used a E3 licensed user for connection in Power Automate. Also created a condition to check "Has Attachments" contains "True" then create a file in SharePoint document library.

I see the files are dropping now.

I need to check if I can add a column name as "Email Sender" in SharePoint document library and to add the value original sender those who are sending email to shared mailbox. Is this possible?

Thanks,
Ram

Was this reply helpful? Yes No
Verified answer

AnthonyAmador 2,553 Moderator on at

Like (0)

Report

Yes, its definitely possible.

Use the action "update file properties" after creating the file, if you add the column in the document library it should look like this.
Hope this helps.
Cheers.

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

Hi Anthony,

I did the same steps. Noticed that attachments are getting saved in the sharepoint document library.

I have created a column in Sharepoint document library as email sender and added "From" into the field as per your screen shot. My flow worked and noticed atatchment on the library. However, email sender column not getting updated and received an error below:

Resource could not be discovered.
clientRequestId: 96d0781a-439e-46a8-9787-124717d96456
serviceRequestId: 3393c4d5-c3b9-436a-a485-8ab8582e084d
Thanks,
Ram

Was this reply helpful? Yes No
ram_ESP 78 on at

Like (0)

Report

HI Anthony

Was this reply helpful? Yes No