Power flow which takes an string compose by names and mails and populate and excel table

(1) Share

Report

Posted on by AL-21110845-0

Hello everyone, I am not very knowledgeable in the world of Power Automate. I am trying to create a flow which, every time it is run, takes a string in the following format:

```
Name <employee@company.com>; Name <employee@company.com>; and so on.
```

I need to break this string into Name and email and fill an Excel in a SharePoint list.

So my two concerns are:

1. How to map every compose output to the correct column name. Currently, it is adding rows but not with the desired content; it is blank.
2. Every time it is run, it needs to clear the previous list to get the up-to-date list and avoid appending new rows, duplicate values, or not getting the up-to-date list from it.

Thanks in advance for your help.