web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : aXndQ5Yd7zrsbwbbPPZmC8
Power Platform Community / Forums / Power Automate - General Discussion / Help with my sharepoin...
Power Automate - General Discussion
Answered

Help with my sharepoint list.

Like (0) ShareShare
ReportReport
Posted on 6 Dec 2021 19:35:45 by cheers1903 62

I have made up a list in sharepoint.

 

I have then made up a flow to provide me with an email notification of expiries from the list which are due in the next 45 days.

 

When i create the flow, i carry out a test run. But the email notification provides a HTML table from the categories in my list.

 

However one of my columns does not show the content from my list it shows

 

cheers1903_1-1638819146044.png

 

what am i doing wrong as none of the other columns shows this content. Only the info from the category.

 

I am using power automate

I have the same question (0)
  • Verified answer
    cheers1903 Profile Picture
    cheers1903 62 on 06 Dec 2021 at 20:48:59
    Re: Help with my sharepoint list.

    that works perfectly.  thank you very much.  Saved me a heap of hassle.  

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,236 Most Valuable Professional on 06 Dec 2021 at 20:44:52
    Re: Help with my sharepoint list.

    @cheers1903 

    I was trying to ask if the SharePoint column that isn't showing properly is a text column or some other type of column such as a choice or lookup.  If the column is a choice or lookup, you need to select the column name followed by Value from Dynamic properties in your Create HTML table action.  So, if Company is a choice or lookup column, select Company Value from Dynamic properties rather than Company.

     

     

     

  • cheers1903 Profile Picture
    cheers1903 62 on 06 Dec 2021 at 20:26:55
    Re: Help with my sharepoint list.

    cheers1903_0-1638822323885.pngcheers1903_1-1638822349547.png

     

    Not sure what you mean, sorry.  I have screen shotted my flow and my HTML table.  All the other columns work.  Its only the company one that when i get the email notification or test run, it comes up with the long file path. 

     

  • ScottShearer Profile Picture
    ScottShearer 25,236 Most Valuable Professional on 06 Dec 2021 at 19:50:21
    Re: Help with my sharepoint list.

    @cheers1903 

    What type of SharePoint column is Company?

     

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans