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
Solved! Go to Solution.
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.
that works perfectly. thank you very much. Saved me a heap of hassle.
What type of SharePoint column is Company?
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.
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.
that works perfectly. thank you very much. Saved me a heap of hassle.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
13 | |
12 | |
9 | |
9 | |
6 |
User | Count |
---|---|
24 | |
21 | |
17 | |
8 | |
8 |