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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create a row in an exc...
Power Automate
Unanswered

Create a row in an excel file for each item

(0) ShareShare
ReportReport
Posted on by 90

Hi,

 

I was hoping someone could help, I need to build a flow that is triggered when a new item is created in an SP list from a Power Apps form. Within the SP item will be a field that will either contain one item like: Test1 or multiple items separated by a comma like: Test1,Test2,Test3

 

If there is one item, it will need to create one row in an excel file, if there is more than one it will need to create a row for each of the items separated by a comma. The excel file will have multiple columns, and the remaining 8 columns (B-I) will include the same data on each row, the only column that will differ is column A as it will have:

Test1

Test2

Test3

 

The file needs to be in CSV format if possible and will then be emailed out. I hope this makes sense?

Categories:
  • David_MA Profile Picture
    15,715 Super User 2026 Season 2 on at

    I can get you started with adding the data from the comma-separated values in your SharePoint list as that is pretty easy. You will use these actions after your trigger condition:

    David_MA_0-1686145420740.png

    In the compose action, use this expression to split the comma-separated values (Note: triggerBody()['text]] will be replaced by the dynamic field in your SharePoint list:

     

    split(trim(triggerBody()['text']),',')

     

     You should then be able to use the following as your schema in the Parse JSON action:

     

    {
     "type": "array",
     "items": {
     "type": "string"
     }
    }

    Use the body of the Parse JSON action in the Apply to each action, and then populate the field in your spreadsheet with the Item value from the Parse JSON action.

     

     

    You can follow the steps in this post to convert the Excel spreadsheet to CSV: Solved: Convert xlsx. or xls files to csv files in a Shar... - Power Platform Community (microsoft.com)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 317 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 247

#3
Henil Profile Picture

Henil 117

Last 30 days Overall leaderboard