cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ry2jericho
Frequent Visitor

Help with creating HTML Table from multiple sharepoint columns

Hi Everyone,

Hoping you can help with this problem. I am trying to create a HTML table to send via e-mail, the inputs for this table are in multiple sharepoint columns, within a list:

Columns
JournalTitle, JournalCode

In each of the columns is semi-colon separated data like "ABC;APR;POL;".

I have been testing with arrays and variables but so far I can't get these columns back into a table successfully. I have been able to split the separated data and append that to an array to use with the HTML table, but only for one column.

Ry2jericho_0-1612871293631.png

 

When I try to do the same for multiple columns I get the below result:

 

Ry2jericho_1-1612871327099.png

I know why this is happening, but I dont know how to solve it!

 

What i want to achieve is 3 rows with JournalCode and JournalTitle populated. 

How can I create an array from multiple columns in my list and create the html table? or is there a better way to go about this? 

Thanks in advance,
Ryan





2 ACCEPTED SOLUTIONS

Accepted Solutions
Ry2jericho
Frequent Visitor

I think I found a solution here, using it as a base for my scenario

Solved: Split multiple Sharepoint field entries into Rows ... - Power Platform Community (microsoft....

 

it seems to work based off small sample test, any other suggestions welcome

View solution in original post

v-litu-msft
Community Support
Community Support

Hi @Ry2jericho,

 

I am glad your issue has been solved by yourself.


If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

View solution in original post

2 REPLIES 2
Ry2jericho
Frequent Visitor

I think I found a solution here, using it as a base for my scenario

Solved: Split multiple Sharepoint field entries into Rows ... - Power Platform Community (microsoft....

 

it seems to work based off small sample test, any other suggestions welcome

View solution in original post

v-litu-msft
Community Support
Community Support

Hi @Ry2jericho,

 

I am glad your issue has been solved by yourself.


If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,285)