Hi
I have a flow that when an email is received to a mailbox, if an attachment (with certain criteria set) is attached it will save a copy of the excel file to sharepoint. This works perfectly, no issues.
However, what I really want to do is not the file is saved, I need to save a separate excel file saved for each row in the excel file. Not only that, I need the relevant row saved to a specific document set in sharepoint. So, I would need the headers from the file plus the row that matches the document set name eg. AB0123456
I'm not really sure where to start when thinking about how to split the file up. Does anyone have any experience of doing something like this?