Onpowerapps.com, expand theDatasection and click or tapEntitiesin the left navigation pane. All the entities are shown.
Click the ellipsis (...) to the right of the entity that you're interested in.
ClickOpen in Excel, and then open the workbook that is generated. This workbook has binding information for the entity, a pointer to your environment, and a pointer to the PowerApps Excel Add-in.
In Excel, clickEnable editingto enable the PowerApps Excel Add-in to run. The Excel Add-in runs in a pane on the right side of the Excel window.
If this is the first time that you've run the PowerApps Excel Add-in, clickTrust this Add-into allow the Excel Add-in to run.
If you're prompted to sign in, clickSign in, and then sign in by using the same credentials that you used onpowerapps.com. The Excel Add-in will use a previous sign-in context and automatically sign you in if it can. Therefore, verify the user name in the upper right of the Excel Add-in.
The Excel Add-in automatically reads the data for the entity that you selected. Note that there will be no data in the workbook until the Excel Add-in reads it in.
Community Support Team _ Mona Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-monli-msft Thanks for the reply. I am opening the file using the same process as you have stated. It now states that O365 has been configured to prevent aquisition and execution of add-ins, even though I have been granted full permission to do so.