Unanswered

Create html table issues

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've created a scheduled flow that sends out employee timesheet entries on a weekly basis. Within the flow is add the create a html table. Everything works well but the only issue is how the html table came out.

Screenshot (144).png

This is how it looked like when sent out as an email. Also is there a way that they could also view it in an excel format.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Can you please post screenshots of your flow?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Here are the screenshots

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

HI @Anonymous

For the employee name, I'm assuming in SharePoint, it's a People column? If so, you need to fetch the name and not the whole field. Power Automate is converting the whole information for the Person into text and that's what's messing up the formatting.

Here's the example of the Created By column. There are a lot of fields inside the Created By:

In your case, is the "Emp_Name DisplayName" instead of the "Emp_Name"

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So I have done what you've said, it has gotten a bit better but the format is still not tidy.

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

What's in the "Mon-Act" and "Mon-Ctr" that is stretching so much the other columns?

Do you think a solution would be to send an Excel attached with the information? That would be easy to create and attach to the email.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

MonAct and MonCtr are Monday Activity and Monday Contract. I shortened it so it would spread out so much in the email but it had no effect whatsoever. to be honest I think attaching an excel format would be easier, but how would I come about it.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous.

This article helps me Format HTML table(It is simple yet effective) https://www.sharepointsiren.com/2019/07/formatting-html-tables-in-flow/

Please review the article it might help you format your table.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Don't worry about uploading the Excel.

The fields in those columns are big and probably screwing up the format.

The article that @CFernandes shows you the solution. You need to inject HTML tags to format your table correctly. I know it's not the most straightforward way, but with this, you have full control of the outcome. Can you give it a go and let us know if it worked?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So I followed the article and unfortunately the outcome was still the same. Checked the flow and saw that it ran successfully as well. I really don't know what's going on.

Was this reply helpful? Yes No