web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Entity creation/refresh
Power Apps
Unanswered

Entity creation/refresh

(0) ShareShare
ReportReport
Posted on by

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?

I have the same question (0)
  • v-yuxima-msft Profile Picture
    on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 774 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 335 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 248

Last 30 days Overall leaderboard