Create rows in a sharepoint list from parsed text in a email's body

[gennarodp]

Hello, 

i would like to know to create a different rows in a sharepoint list on a specific field extracted by email's body:

For example

I have this following text extracted by email's body:

AAA0000

BBB123455

CCC57575757

I would like to create three o many  different rows (how many are the rows), in a sharepoint list in the field "Item".

Output:

Item Column

AAA0000

BBB123455

CCC57575757

Thank you

[ScottShearer · Accepted solution]

@gennarodp 

Please see my example below.  Expressions that I used can be seen in the action comments.

When I loop, I am looping trough the output of the Split Compose action.

Let me know if you have any questions.

[gennarodp]

Hello @ScottShearer ,

thank you for your answer.

It works, but my text end with a blank row , for example:

AAA0000

BBB123455

CCC57575757

BLANK ROW

This thing, add a blank row also in sharepoint's list, and i don't want this.

Can help me to resolve this ?

Thank you

Regards

[ScottShearer]

@gennarodp 

Add a trim() expression to the expression in the Split compose action - let me know if this works for you please.

[gennarodp]

hello @ScottShearer ,

thanks. 

it's works very well.

Thank you very much

I have an other question for you.

If in this example, i would to update rows on sharepoint's list, others fields, how could i do?

In this example, i have two fields extracted by email's body:

The first (that you have already resolved):

AAA0000

BBB123455

CCC57575757

BLANK ROW

The second:

1

50

67

I would like that in sharepoint list, there were an update of a field " Qty" with the single following order:

Item	Qty
AAA0000	1
BBB123455	50
CCC57575757	67

it could be possible ?

[ScottShearer]

@gennarodp 

It sounds like you want to find a specific item in a SharePoint list and update it.  To do so, you'll want to use a filter query and a get items action.  Here is a link for creating an OData filter query to get you started.

Let me know if you need more help.

[gennarodp]

Non properly.

I would like that, the specific field"Qty", was updated in sharepoint's list , in the same step of creation of the "item" field.

Can i resolve with a parallel flow ?

[gennarodp]

The thing could be easier with a following input ?

AAA0000,1

BBB123455,50

CCC57575757,67

The output of sharepoint's list should be this:

Item	Qty
AAA0000	1
BBB123455	50
CCC57575757	67

[ScottShearer]

@gennarodp 

You'll need to make some minor changes to my original Flow - see my example below:

Please let me know if this works for you.