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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Separate information f...
Power Automate
Unanswered

Separate information from a Sharepoint list with a cell with several lines of text and display in the mail as a table

(0) ShareShare
ReportReport
Posted on by 41

Hello together, 

 

I am very new to program Flows in Power Automate. I would like to split one cell when information is seperated by an comma. 

I would also like to have the shared information displayed one below the other in a kind of table. 

 

I am very grateful for any help. 

 

Please see my Flow and the Sharepoint table here: 

 

Tobiask1_0-1635776942612.png

Tobiask1_1-1635776982336.png

 

It wouldTobiask1_2-1635777040761.png 

be nice if the batch and the article no. are in the same line:

Example:

5222222          B99999999

522222389      B125656599  

Categories:
I have the same question (0)
  • Tobiask1 Profile Picture
    41 on at

    @ekarim2020 Is it possible that you can help me on this topic? Many thanks in advance!!!

  • Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    Are you trying to do something like this:

    2021-11-03_13-56-51.png

     

    but where the "joined" text is sent in a email, formatted as a table?

     

    ELlis

  • Tobiask1 Profile Picture
    41 on at

    Hey Ellis, 

    thank you for your answer. 

    No, I have a Sharepointlist with fields Batch and Article number in which several characters are entered. (Batch and Article number are a column type of: multiple lines of text) 
    In this line there is a specific batch for each article number, which is separated by a comma in the field:
    Example for your list in the column batch for one line:

     

    Chuck 306,

    Chuck 307,

    Chuck 308

     

    And in the column Article number: 

     

    8100,

    6434,

    8230

     

    Now I want that Power Automate recognize the commas and write an Email the batch in the next line where the correct article number is assigned: 

     

    So on the EMail I would like a table which looks like this: 

     

                   

    Artikle numberBatch
    8100Chuck 306
    6434Chuck 307
    8230Chuck 308

     

    I think I have to use a Split Function to generate a HTML table. Can you please help me? 

    Thanks

    Tobias 

  • Verified answer
    Ellis Karim Profile Picture
    11,681 Super User 2025 Season 2 on at

    Using the following SharePoint list item as an example:

    2021-11-06_12-15-50.png

     

    We can generate a HTML table and send the following email:

    2021-11-06_12-21-57.png

    This is the demo flow:

    2021-11-06_12-24-14.png

     

    (1) Split actions: split at the comma ','

    2021-11-06_12-26-12.png

    You will need to use the correct SharePoint internal column names for the Artikel and Batch columns.

    See: What is SharePoint column internal name and where to find it

     

    The split actions produce the following arrays

    2021-11-06_12-38-34.png

     

    (2) Using the Select action we can select the matching Artikel and Batch numbers.

    2021-11-06_12-40-49.png

     

    The range function is used to loop through each item of the array, start from 0 until the length or end of the array:

    2021-11-06_12-30-34.png

     

    The Select action produces an array as its output which looks like this:

    2021-11-06_12-35-16.png

     

    (3) Create the HTML Table: using the output from the Select action above

    2021-11-06_12-45-46.png

     

    (4) Send Mail - add the output of the Create HTML table action:

    2021-11-06_12-47-23.png

     

    Example email sent using the above flow:

    2021-11-06_12-49-16.png


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

  • Tobiask1 Profile Picture
    41 on at

    Hey Ellis, 

     

    this looks very good. I will try that out and mark the post as solution if it works fine. Thank you for your quick response 🙂

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard