Answered

How can I send an HTML table from a new excel file uploaded to SharePoint.

(0) Share

Report

Posted on by sam123123123

Desirable Flow:

When an excel file is uploaded into SharePoint, the default status of the document is new. Subsequently, the flow can create a table for the Excel and then retrieve the data from the Excel. Afterwards, it creates a html table from the columns in Excel and then send an email while the status should be completed.

I am stuck in creating a flow and hope to get some helps. I tried to come up with a flow but when I uploaded the excel to SharePoint, it failed.

Really Appreciate!

Below are the flow and some info related to the flow

Cusomter receivable photos.png Sharepoint file ( Power Automate) .png

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @sam123123123
Can you show the error code in your flow run history?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report
Copy link

Link copied!

But is the way that I create the flow correct? If I want to achieve the situation that I mentioned. Really Thanks!

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @sam123123123
You can try to use this flow to get the file content:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I changed it, it's better; but, it seems like right now, I am stuck in lists row. Is there any way to fix it? Really thanks!

New flow

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @sam123123123
The File property need to put the File Full Path , like this:

outputs('Get_tables')?['body/value']?[0]?['name']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report
Copy link

Link copied!

Hi, can you show me your entire flow, because if you take a look at my flow, you can see that when I create the "get file content", it automatically transform to For each. Really Appreciate!

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @sam123123123
I did not use the get files action in my side :

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
sam123123123 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the solution, and sorry for the late acceptance of solution

Was this reply helpful? Yes No