Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Create html table issues

(0) ShareShare
ReportReport
Posted on by

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.

  • Re: Create html table issues

    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.

     

     

  • manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: Create html table issues

    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

     

  • CFernandes Profile Picture
    CFernandes 8,146 on at
    Re: Create html table issues

    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!

  • Re: Create html table issues

    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.

  • manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: Create html table issues

    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

  • Re: Create html table issues

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

     

    Screenshot (154).png

  • manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: Create html table issues

    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:

    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

  • Re: Create html table issues

    Here are the screenshots

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

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: Create html table issues

    @Anonymous 

    Can you please post screenshots of your flow?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard