Answered

Change Worksheet Position in Excel with a Flow

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Reylin 89 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No