Unanswered

PowerApps Excel add-in cannot connect to to CDS

(0) Share

Report

Posted on by Sandra Soniec

128

Hi, installed PowerApps Office add-in by central deployment through O365 in order to edit CDS data in Excel. Add-in is enabled for everyone, status OK. Received an e-mail that the add-in is ready to use with the links to Excel to test it. I see the add-in in My add-ins and refreshed it. Was able to sign-in but get an error message while trying to establish a connection to CDS: "The call to get the available environments for myUser (myUser@domain.ch) failed. Details: error". (translated from German)

In PowerApps, when I open the entity with "Edit data in Excel" I receive the following message "ADD-IN INFORMATION Office 365 has been configured to prevent individual acquisition and execution of Office Store Add-ins". While individual acquisition is blocked I don't understand why the add-in cannot be executed since it is admin deployed.

Any ideas how to fix this? Thxs in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

CazzaT1 23 on at

Like (0)

Report

Hi
Did you ever resolve this issue as I am experiencing the same problem?

Kind regards

Was this reply helpful? Yes No
Sandra Soniec 128 on at

Like (0)

Report

@CazzaT1 No, never got this up and running. The majority of my user frequently mess up static, dynamic worksheets (overlooking the hidden columns on the left). We open the data in Excel online for editing from CDS (Dataverse). My advanced users are using XML 2003 spreadsheet for data imports.

Was this reply helpful? Yes No
CazzaT1 23 on at

Like (0)

Report

@SandraSoniec
Thank you for your reply. I will continue to investigate how I can get this to work.

Was this reply helpful? Yes No
Pat98110 7 on at

Like (0)

Report

I ran into the same issue and found a solution. However the Microsoft Store was blocked and that can prevent the ability to install the add-in. You will need to install the add-in then connect to the dataverse. It works like looking at the raw data in the table. This allows you to then create a quick simple dashboard. You can edit the data however there are several columns of data that are GUID's which can be difficult to navigate. >> https://appsource.microsoft.com/en-us/product/office/WA104380330 << Microsoft PowerApps Office Add-in

Was this reply helpful? Yes No
CazzaT1 23 on at

Like (0)

Report

Hi, thank you for your reply. I have been advised that the issue I have is due to the fact that the Microsoft Store has to be accessible when using the Add-in, after it has been installed. Our Add-ins are managed at an organisational level and therefore users cannot access the store. I am waiting for our technical services team to create a policy to allow access. Still waiting.....

Was this reply helpful? Yes No