Unanswered

when a new email arrives, save to the sharepoint list

(0) Share

Report

Posted on by CU02011135-0

Hi guys,
I receive an e-mail regularly every day. There is an excel file in this mail. My goal is to copy the data in this excel and save it to my sharepoint list. However, I could not do this. For this, I first tried saving it to the sharepoint library. Then I tried to turn the data in that excel file into a table, but it didn't work. What do you suggest? Has anyone done it before? Is it possible ?
Please help me...

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mstf042 ,

I think this link could help you:

Using eMail Attachment Content in Power Automate Without Saving the File (flyingpolymath.com)

Please check this test:

My CSV Table:

My Flow Configuation:

base64ToString(body('Parse_JSON')?['contentBytes']) skip(split(outputs('Compose_2'),decodeUriComponent('%0A')),1)

replace(split(items('Apply_to_each_2'),',')[0],'"','') replace(split(items('Apply_to_each_2'),',')[1],'"','') replace(split(items('Apply_to_each_2'),',')[2],'"','')

The Result:

My SharePoint List:

Best Regards,

Sunshine Gu
CU02011135-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for reply. I tried but it did not work for my flow. Here my flow's ss. It giving strange error. I looked up with compose function, and there are some weird expressions. Why might it be caused?
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mstf042 ,

Please do not insert a table in Excel Worksheet, if you insert a table, you will get an error. Please re-create a csv file, like me, without inserting any tables.

Best Regards,

Sunshine Gu
CU02011135-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
The e-mail I received is not in csv format. It comes directly in excel format. In this case, should I convert it to csv format first?