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 / Select your data form ...
Power Apps
Answered

Select your data form view o edit mode (Forms)

(0) ShareShare
ReportReport
Posted on by 165

Hi Folks.

 

It's possible or there is a way when I edit or view I can select all my fields copy and paste in excel Without using "Export to Excel" or "Edit in Grip view"?

 

My client wants to open the element in view or edit and select al the info copy and paste, but right they are doing one by one

 

rauseol_0-1680097166530.png

 

Regards

Luis

 

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @rauseol

    According to Bing:

    Yes, you can copy and paste a PowerApps datatable into Excel. You can follow these steps:
    1. Set Datatable to clipboard text.
    2. Paste cells to Excel worksheet (choose the upper left cell).
    3. This should paste the datatable in Excel, all in one column, but on separate rows.
    4. Then, use the Excel UIs to have PAD do Text to Columns based on the proper delimiter⁴.

    I hope this helps! Let me know if you have any other questions.

    Source: Conversation with Bing, 3/29/2023(1) Solved: How to insert DataTable into Excel - Power Platform Community. https://powerusers.microsoft.com/t5/Power-Automate-Desktop/How-to-insert-DataTable-into-Excel/td-p/1393653 Accessed 3/29/2023.
    (2) How to Export data from DataTable to Excel in PowerApps. https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-Export-data-from-DataTable-to-Excel-in-PowerApps/td-p/293868 Accessed 3/29/2023.
    (3) Solved: Copying a data table? I see the copy function when .... https://community.powerbi.com/t5/Desktop/Copying-a-data-table-I-see-the-copy-function-when-I-right-click/m-p/43191 Accessed 3/29/2023.
    (4) Copy/Paste Excel table into a PowerApps form textbox field. https://powerusers.microsoft.com/t5/Building-Power-Apps/Copy-Paste-Excel-table-into-a-PowerApps-form-textbox-field/td-p/1442398 Accessed 3/29/2023.
    (5) Solved: Copy data table inside powerapps - Power Platform Community. https://powerusers.microsoft.com/t5/Building-Power-Apps/Copy-data-table-inside-powerapps/td-p/1204073 Accessed 3/29/2023.

  • rauseol Profile Picture
    165 on at

    Thanks you so much Sir!!

     

    Regards

    Luis

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 893

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 482

Last 30 days Overall leaderboard