Help splitting string to new fields in SharePoint using Flow

[N1vek215]

Hello, I'm trying to reformat some names that I have from an Excel sheet that is feeding to a SharePoint List using a template from Flow I found.

What I'm specifically trying to do is have Flow or SharePoint Online automatically take the StudentName field (LastName, FirstName) and move FirstName and LastName into the respective columns in the list. In addition, I would also like the DisplayName combine both FirstName and LastName on the list.

Below is the picture of what I'm trying to achieve (in Blue)

Any help would be great. I'm pretty new with Flow and coding so any pictures and step by step suggestions would be great.

Thank you in advance!

[RezaDorrani · Accepted solution]

Hi @N1vek215 

Create a flow with trigger "When an item is created in SharePoint"

Then connect to the ShrePoint site and the "New Students" list

This will call the Flow each time a new student is created in the list

Next create the "Update Item" action to update the data in FirstName, LastName and DisplayName columns

Id - use the dynamic content ID obtained from "when an item is created trigger"

Use expressions for FirstName,LastName and DisplayName

First Name -     

trim(split(triggerBody()?['StudentName'],',')?[1])

Last Name -

split(triggerBody()?['StudentName'],',')?[0]

Display Name -

concat(trim(split(triggerBody()?['StudentName'],',')?[1]),' ',split(triggerBody()?['StudentName'],',')?[0])

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[David1212]

I'm trying to do something very similar to this except that the names I am splitting are formatted as First Name Last Name (e.g., "John Smith") rather than Last Name, First Name ("Smith, John"). I'm pretty ignorant of how to structure the function expressions. So what would the expressions be to split last name from first name in my case?