Unanswered

Power Automate Flow for SharePoint List

(0) Share

Report

Posted on by kayakingaway

Hello all,

I am trying to create a flow to break up the multi row text box containing emails to create a new row with the remaining information following. Such as new row would read: Test, test1@website.com, 11/25/2021,government, test category. and the next row would read test, test2@website.com, 11/24/2021, government, test category, etc. Any help would be appreciated. I started a flow and got down to the if yes and no and I'm just stuck now.

snippit ex.PNG

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@kayakingaway

Can you past a screen shot of what you have so far as well as an example of the original text?

Was this reply helpful? Yes No
kayakingaway 52 on at

Like (0)

Report
Copy link

Link copied!

Here is roughly what I have. I do have the site address and list name but cannot share. Below is an image of bottom (what I need each row to look like) and top what the rows with multiple emails currently look like

Was this reply helpful? Yes No
v-chenzhi on at

Like (0)

Report
Copy link

Link copied!
Hi @kayakingaway ,

Do you want to create new row with single email?

Could you please tell me how the other information in these rows is filled in?

I assume you have this in SharePoint and the other information of the new line is the same as the original.

Please try the following workaround.

Here is the expression.

split(triggerOutputs()?['body/TTemail'],',')

BTW, Set the List Name of the Created item to be different from the trigger List Name, it will cause the flow to loop.

Best Regards,

Zhi Chen

Was this reply helpful? Yes No