cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gennarodp
Post Patron
Post Patron

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User III
Super User III

@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.

image.pngimage.pngimage.png

 

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

Scott

View solution in original post

8 REPLIES 8
ScottShearer
Super User III
Super User III

@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.

image.pngimage.pngimage.png

 

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

Scott

View solution in original post

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

@gennarodp 

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

image.png

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

Scott

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:

 

ItemQty
AAA00001
BBB12345550
CCC5757575767

 

it could be possible ?

 

@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.

 

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

Scott

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 ?

The thing could be easier with a following input ?

 

AAA0000,1

BBB123455,50

CCC57575757,67

 

The output of sharepoint's list should be this:

 

ItemQty
AAA00001
BBB12345550
CCC5757575767

 

@gennarodp 

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

image.pngimage.pngimage.pngimage.png

Please let me know if this works for you.

 

 

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

Scott

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (41,994)