web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Excel Office Script to fill down data for specific columns

(0) ShareShare
ReportReport
Posted on by 6
Here's the data:
 
 
I want to fill down the cell contents to the blank rows below for column A and B
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    48,414 Super User 2025 Season 2 on at
    Excel Office Script to fill down data for specific columns
     
    I understand what your question was, I didn't ask what you wanted to fill down, I asked what do you want to fill it down with.
     
    The instructions I gave is how you would build out filling it down.
     
    In column one is a date I believe, but I do not know how you will determine what value will go there, I can only tell you what you need to do to fill it, not tell you what value goes there
     
    What specific thing did I not answer for you that I can answer for you?
     
    I feel the issue is, you are asking the Power Automate forum to build you a script, which should go to the Office Forums, I was giving you how you can just do it with Power Automate, without necessarily using a Script.

    But if you want to use a Script, then you have to have the Office People help you build one, then you can execute that script from Power Automate, but you will still have to provide them with what/how you want the data populated.
     
    For example, are you going to put the same date on them all, and if not, how are you going to figure out the value to put there in the script etc.
     
    Just want to make sure that using a Script is the best option (could be) and it is something that you need to have scheduled with a flow or is this a one time deal or??
  • OB-11091619-0 Profile Picture
    6 on at
    Excel Office Script to fill down data for specific columns
    Hey Michael Gernaey
    I want to fill down the data from the topmost cells
  • Michael E. Gernaey Profile Picture
    48,414 Super User 2025 Season 2 on at
    Excel Office Script to fill down data for specific columns
     
    What do you want to fill it with?
     
    Easy enough though
     
    1. Save your file in SharePoint or OneDrive
    2. Make sure you have a Table Around the data if you want to use List Rows present in a Table and then use Updates for updating the data
    or
    2b. or use Graph API to call and populate the data
     
    or 2c, you can create a Script to do it, and then call the Script via Power Automate Cloud
     
    Those are 3 options
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 745 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 528 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 320

Last 30 days Overall leaderboard