cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SandraAkujobi
Post Partisan
Post Partisan

Create html table issues

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.

9 REPLIES 9
Mira_Ghaly
Dual Super User II
Dual Super User II

@SandraAkujobi 

Can you please post screenshots of your flow?

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Here are the screenshots

Screenshot (150).pngScreenshot (147).pngScreenshot (148).png

HI @SandraAkujobi 

 

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:

Screenshot 2020-08-14 at 12.07.53.png

 

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

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

 

Screenshot (154).png

Hi @SandraAkujobi 

 

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

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.

CFernandes
Super User
Super User

Hi @SandraAkujobi.

 

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!

Hi @SandraAkujobi 

 

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

 

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.

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,638)