Hi,
I was hoping someone could help, I need to build a flow that is triggered when a new item is created in an SP list from a Power Apps form. Within the SP item will be a field that will either contain one item like: Test1 or multiple items separated by a comma like: Test1,Test2,Test3
If there is one item, it will need to create one row in an excel file, if there is more than one it will need to create a row for each of the items separated by a comma. The excel file will have multiple columns, and the remaining 8 columns (B-I) will include the same data on each row, the only column that will differ is column A as it will have:
Test1
Test2
Test3
The file needs to be in CSV format if possible and will then be emailed out. I hope this makes sense?

Report
All responses (
Answers (