Power Platform Community Forum Thread Details

I'm running into 3 intrerrelated issues trying to get entities working with excel spreadsheets:

1. I select 'Get data', go through the steps, select the sheet, set headers, primary key, etc.

during the 'create' process, I get this error:

"Load to Common Data Service failed. Details: [(([Table with name 'crca0_miscequipment_3s' does not exist], The remote server returned an error: (404) Not Found.), Unable to retrieve metadata for CRM environment: https://canada-001.azure-apim.net/apim/commondataservice/f5b08057b4ae457fb6ac65a34b196285/$metadata.json/datasets/default.cds/tables/crca0_miscequipment_3s)], One or more errors occurred.. (Job ID: cb67a036-4ddc-42dd-b38e-099312aad045)"

2. When I get the above process to work (maybe 1 time in 20), the entity that's created always seems to be using a cached version of the sheet; I've tried modifying sheet/column names in case they were causing problems, and I see references to previous names in newly-created entities.

3. Even on the rare occasion that the app actually worked, I found that the app would not display new data entered

through Excel. This tells me that the app has cached some data somewhere, and is using that, even though I use Refresh() frequently.

What am I missing?

Categories:

Microsoft Dataverse with Power Apps