Concat call Sharepoint item?

(0) Share

Report

Posted on by TBuente

112

Hi all,

I am trying to create an html table, and I currently have it converting into a PDF using OneDrive for Business. I am trying implement a Sharepoint list value; however, it is not working correctly.

Currently I have:

concat('<!DOCTYPE html>
<html>
<head>
<style>
table, th, td {
	border: 1px solid black;
}
</style>
</head>
<body>

<h2> FG Form Summary </h2>

<table style ="width:100%">
	<tr>
		<th>Project Title</th>
		<th>',item()?['Title'],'</th>
	</tr>
</table>
</body>
</html>')

This does create an html table; however, the value for " item()?['Title'] " is blank. This name does match the Sharepoint item I am trying to call (when I hover over the name), and the value I am testing is not blank.

Any ideas on how to get this " item()?['Title'] to properly display the contents of my Sharepoint item named "Title"?

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@TBuente

Screenshot of Flow

Is this running in a for loop?
TBuente 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Here is a screenshot. Create File 3 is using concat. Then I am converting the file, and finally creating a PDF of the converted file.

This is where I have learned of this method (Shane Young): https://www.youtube.com/watch?v=2rfAQe1kK8M

This is not running in a loop. Before this Create File 3, I have a Sharepoint "Get Items". I am trying to call one of the items from this Get Items, in my concat function.
Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TBuente,

Please input the title just like the following shows, no need to use the concat() function:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.