Power Platform Community Forum Thread Details

Hello - I'm trying to build a flow that takes the data received in (.xlsx format) from a weekly automated email and appends an existing Excel file to the next available blank row (which has multiple sheets, but only the current FY sheet needs to be appended), that is saved on our SharePoint. I've looked at multiple actions, but none seem to give me the ability to select the specific sheet that needs appending (I want to stress that I do not want to delete any existing data on my SharePoint file, just add the new data to it). I'd prefer not to create a separate file for the current FY as this would require modifications at the close of each FY, but if that's the way I need to proceed, so be it.

Thank you in advance for your time

Categories:

Building flows