My trigger is "When an email arrives" filtered with the subject line and attachment. This type of email will happen daily, with only an .xlxs file attached.
The file has lots of rows and columns filled. Unfortunately, I am unable to receive it in the "Table" format that Power Automate needs.
Been looking for ways to access this info to then use it in other flow. What I need to happen in the end, is adding all these new rows into an existing table. Have no idea how to acheive this.
Tried creating in Sharepoint the file, then creating a table in that file. However, the table just goes on top of the non-table information.
Maybe creating an array or something like that?
Appreciate any input you might have!