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:

Business Process Flows

All responses (8)

Answers (1)

sam123123123 on at

Like (0)

Report

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

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

v-yueyun-msft on at

Like (1)

Report

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

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

Best Regards,
Yueyun Zhang
sam123123123 on at

Like (0)

Report

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

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!
v-yueyun-msft on at

Like (0)

Report

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

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
sam123123123 on at

Like (0)

Report

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

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
v-yueyun-msft on at

Like (0)

Report

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

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

Best Regards,
Yueyun Zhang
sam123123123 on at

Like (0)

Report

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

But is the way that I create the flow correct? If I want to achieve the situation that I mentioned. Really Thanks!
v-yueyun-msft on at

Like (0)

Report

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

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

Best Regards,
Yueyun Zhang