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

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Concat call Sharepoint item?

(0) ShareShare
ReportReport
Posted on by 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"?

I have the same question (0)
  • RezaDorrani Profile Picture
    12,141 on at
    Re: Concat call Sharepoint item?

    @TBuente 

     

    Screenshot of Flow

     

    Is this running in a for loop?

     

  • TBuente Profile Picture
    112 on at
    Re: Concat call Sharepoint item?

    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.

    flowpdf.png

     

    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 Profile Picture
    on at
    Re: Concat call Sharepoint item?

    Hi @TBuente,

     

    Please input the title just like the following shows, no need to use the concat() function:Annotation 2019-10-04 172405.png

     

    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.

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

Quick Links

Responsible AI policies

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard