Is the Open in Excel function no longer available from Power Apps portal?

(0) Share

Report

Posted on by Joel D

363

Hi,

I'm following the steps described in this tutorial from docs.microsoft to manage data in an entity by using Excel online, but I can't find the mentioned Open in Excel button.
I found a similar button (in the top Menu I clicked on Data > Edit data in Excel) but I can't opt for opening the file online (it downloads the file immediately), moreover the file downloaded doesn't contain any record but the columns names only, as if the table was empty:

Am I missing something or the function (opening the excel file online) has been deprecated?
And why the file that I downloaded doesn't have any record inside, as the table is not empty?
(I'm using the trial version with default data, may it be relevant?)

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

Hi Joel,

1.Firstly, you must be sure that the entity does contain data records.

2.Then you need run Excel Add-in.

There will be no data in the workbook until the Excel Add-in reads it in.

At the beginning, select Edit data in Excel button to download excel.

(1) In Excel, select Enable editing to enable the Power Apps Excel Add-in to run. The Excel Add-in runs in a pane on the right side of the Excel window.

(2) If this is the first time that you've run the Power Apps Excel Add-in, select Trust this Add-in to allow the Excel Add-in to run.

If you're prompted to sign in, select Sign in, and then sign in by using the same credentials that you used on Power Apps.

(3) Data of the table you select will be loaded after you login in the Excel Add-in.

You can refer following link, which provides more detailed information about it():

Open table data in Excel - Power Apps | Microsoft Docs

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Joel D 363 on at

Like (0)

Report

Thank you very much!

Was this reply helpful? Yes No