Hi,
I have this scenario where each day a new email arrives in Outlook with an Excel attachment. I need a flow to get the data in the attachment (only 1 tab/sheet in the file) and copy the data to a MS List. The flow needs to be triggered each time an email with Excel attachement arrives.
I did some research and found out that the Excel data needs to be in a table format and in order to acheive this, you need to create an office script. So I recorded and saved the script called "Convert to Table" as per screenshot below.
Now my issue is how do I incorporate this into a flow? I didn't get far as per screenshot below as I got stuck at the "File" stage i.e. what file am I referencing here?
@Rhiassuring appreciate any direction on how to fix this step and finish the flow if possible.
Thanks in advance.
