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.
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.
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.
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
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!
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.
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
So I have done what you've said, it has gotten a bit better but the format is still not tidy.
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
Here are the screenshots
@Anonymous
Can you please post screenshots of your flow?