Help with my sharepoint list.

[cheers1903]

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

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

[ScottShearer]

@cheers1903 

What type of SharePoint column is Company?

[cheers1903]

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 · Accepted solution]

@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 · Accepted solution]

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