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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Replicate Excel Featur...
Power Apps
Unanswered

Replicate Excel Feature, Drag to Fill in power apps

(1) ShareShare
ReportReport
Posted on by 16

Hi Community,
Good Year to all.
I have a requirement where I have a SharePoint list where I save data of my progress for sections from 1 to 120. So, starting with basic Columns Category Type, Level,.... after that I have columns from 1 to 120.

 

prlofc3_0-1704466133072.png

 

In the Power apps using edit form I pulled all the 120 columns but here's the issue I want to use the drag function like in Excel as shown in below image. Is there any way to implement this function in power apps or any other approach to enter the repeating values in a simpler way instead of entering it 120 times. 

prlofc3_1-1704466133073.png

 

Please do not hesitate to reach out to me for more information 

Kindly Provide any Solution for the Above Requirement.
I'm open to any kind of suggestions or workarounds for the requirement.
Many Thanks 

@WarrenBelz   @ANB     @LaurensM  @Rajkumar_404 

Categories:
I have the same question (0)
  • prlofc3 Profile Picture
    16 on at

    Hi @BCBuizer  @KeithAtherton ..

    can any of you please help me with this ? 😊

  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @prlofc3 , Your screenshots are blur, however with whatever description you mentioned with that are you looking for this feature of excel in PowerApps, please correct me if I am wrong:

    dragFeature.gif

    If yes, then I am afraid that this kind of feature is available.  If not then, could you elaborate more on the requirement with some example.

     

    Thanks,

    ANB

  • KeithAtherton Profile Picture
    3,709 Most Valuable Professional on at

    Hi @prlofc3,

     

    I don't believe this feature is available with any out of the box controls, unfortunately.

     

    If you need this specific feature then you may need to create a PCF control or see if a similar one exists in PCF Gallery and elsewhere.

     

    Otherwise you may be able to develop a similar feature where you click on the "source" and "destination" cells then map the values across intermittent cell range. It wouldn't be click-and-drag but may still help.


    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    Follow me online.

  • prlofc3 Profile Picture
    16 on at

    Hello @ANB .

    This is the exact feature I'm looking to implement in Power Apps
    Could you please give me an Idea on how to Implement it ?
    Since I'm new to power apps I'm still exploring a lot of things.

    Many Thanks !!

     

  • prlofc3 Profile Picture
    16 on at

    Hello @KeithAtherton 
    Thank you for you reply.!
    I am not aware of this PCF and am just a beginner level in Power apps. So Is there any kind of work around like Entering the Range of the columns and inserting a values into it or anything else. 
    Please advice !

  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @prlofc3 , As said by @KeithAtherton , you might have to explore PCF. Reference: https://learn.microsoft.com/en-us/power-apps/developer/component-framework/overview

     

    Thanks,

    ANB

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 316 Most Valuable Professional

#2
11manish Profile Picture

11manish 242

#3
Valantis Profile Picture

Valantis 198

Last 30 days Overall leaderboard