cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TBuente
Level 8

Concat call Sharepoint item?

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"?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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.

View solution in original post

3 REPLIES 3
Dual Super User
Dual Super User

Re: Concat call Sharepoint item?

@TBuente 

 

Screenshot of Flow

 

Is this running in a for loop?

 

TBuente
Level 8

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.

 

Community Support Team
Community Support Team

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.

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,716)