Change Worksheet Position in Excel with a Flow

[Reylin]

Hello! I've made an automated flow that maintains a spreadsheet. Every day it makes a new worksheet but it always adds it to the end of the list of worksheets (We have a new spreadsheet every month). The people reading these spreadsheets every day need to go to the back of the list and drag the worksheet to the front position. Is there any way for me to automate this to make things cleaner and easier? 

For example, here is today's worksheet that was created, and its positioned at the end of the worksheets after the Template. I want it to be at the front when its created every day. 

[ChristianAbata · Accepted solution]

hi @Reylin  it looks like you need to focus a spreedsheet, so in my experience unfortunally this is not posible in PA.

[Reylin]

Hi Christian, 

Thanks for the quick reply! If its not possible with PA then I guess I shall look for a different kind of solution somewhere else~ 
I thought I'd at least give PA a shot though 🙂 

[ChristianAbata]

@Reylin  youre welcome , please if I solve your dude consider to mark as a solution my answer to guide others.

[v-alzhan-msft · Accepted solution]

Hi @Reylin ,

I agree with @ChristianAbata that we couldn't achieve the requirement to add new row to the first line of excel table, Microsoft flow could only add it to the end of the table currently.

If you want the function to add a row to the first line of the table to be supported in Microsoft flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.