Share
Report
4Hello 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.
```
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.
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.
Categories:
All responses (
Answers (
