Select your data form view o edit mode (Forms)

(0) Share

Report

Posted on by rauseol

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

Regards

Luis

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
rauseol 165 on at

Like (0)

Report
Copy link

Link copied!

Thanks you so much Sir!!

Regards
Luis

Was this reply helpful? Yes No