Skip to main content

Notifications

Power Automate - Building Flows
Answered

A flow to fill out an Excel column with input variable

Posted on by 23

Hi,

 

I need to build a flow to populate values for an empty column of an Excel file. 

 

So, in my OneDrive for business, I have a blank Excel file. I copy and paste a batch of values into this table. I now need to sequentially fill out a column in this dataset, with a value that starts with a number and it should go on incrementally. how could that be achieved? 

 

Thanks

 

  • grantjenkins Profile Picture
    grantjenkins 11,053 on at
    Re: A flow to fill out an Excel column with input variable

    If you're already going in to manually paste the data to the Excel Table, then why don't you just add the first couple of values into your blank column, then use the fill handle to copy the values down (will automatically increment the numbers for you).

     

    grantjenkins_0-1668499586590.png     grantjenkins_1-1668499614658.png

     

  • Verified answer
    Re: A flow to fill out an Excel column with input variable

    HI @NicoApps ,

     

    I made a sample for you.

    vxiaochenmsft_0-1668492881003.png

    vxiaochenmsft_1-1668492912313.png

    vxiaochenmsft_2-1668492928713.png

    vxiaochenmsft_3-1668492975021.png

     

    Best Regards,

    Wearsky

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,473

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,659

Leaderboard