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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
23 | |
13 | |
11 | |
10 | |
8 |
User | Count |
---|---|
33 | |
25 | |
24 | |
17 | |
16 |