export of CDM entity template failing

(0) Share

Report

Posted on by AmitLoh-Powerap

608

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi AmitLoh,

Please check the drop down button on the top right corner on PowerApps.com. Before, I have environment 1(default) and environment2(always used environment). In environment2, when I select an Entity to export it as a template, I would get the same issue with you.

Then I change the environment to Environment1(default), and when I click the Entities on the left navigation pane, I would be asked to create a new environment. In this case, I create environment3(Mable’s Common Data Model) for a test. In environment3(Mable’s Common Data Model), I would be able to use Export template button to export the entity.

Please try if you could create a new environment to export entities as templates. Please try if this works for you.

Best regards,
Mabel Mao
AmitLoh-Powerap 608 on at

Like
a
(0)

Report
Copy link

Link copied!

this worked. Is there any feature coming up that lets me import template after adding additional schema columns as well?
That will be so cool and I am waiting to become DBA using excel import.
Vijeta Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Amit,

Glad it worked for you. We are working on importing schema of entity with data functionality.

Thanks
ree 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried creating a new environment and exporting from the default environment and I am still getting the same "export failed" error. Any other thoughts?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I get the same '! Export Failed' message for the template or the data.

I also tried exporting the table as Environment resources in the Admin Center and imported the resources in to a new environment and still got the Export Failed error when exporting the template from the new environment.

Any Ideas on a work around or a fix?

Thanks
ree 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Peter,

Unfortunately, I have a support ticket in with the Microsoft PowerApps dev team. It appears the initial person I was speaking with could not duplicate the problem on her end. Upon remoting in, she could see I am having the same issue while using Chrome, Edge, and IE. I will be sure to post what works when they figure it out.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Ree,
Just an FYI...One of my MS Support contacts said your ticket should be passed from the PowerApps Dev team to the CDS Dev team for quicker resolution, you may want to get your ticket updated.

I did manage to make a work around to export entity data:
Create an excel file with your entity fields
Select the column headers and insert a table
Leave the default table name alone (Table1) - do not change it
Save it on OneDrive
Make sure you are in your correct environment
Create a PowerApps Flow
Start with a blank flow (in the PowerApps site not the Flow site)
PowerApps will be the 1st trigger - you cannot edit this
Add a New Step (ANS) then Add An Action (AAA)
Search "common" in the dialogue box
Pick Common Data Service - Get List of Records
Pick default from the database dropdown
Pick your Entity from the Entity dropdown
ANS & AAA
Search "Excel" in the dialogue box
Pick Insert Row
For the File Name use the folder button to find your Excel file on One Drive (or other repositories)
For the Table Name use the drop down to select "Table1" (you created in step 1)
A field mapping matrix will appear, if you have spaces in the Excel field names they will look funky but you should be able to complete the mapping between your entity and Excel
Complete the mapping
ANS
When you add new step the Excel Insert Row step should convert to an Apply to Each loop and you should get prompted the firt time - say yes/ok. This will copy the entity data record by record to Excel
You can cancel the ANS here but my preference is to add an ANS & AAA for Office Outlook 365 - Send an email
This is straight forwards just setup an email with a relevant subject and body so you know when the copy is complete (for about 20 columns per row it takes about 2 seconds each record so it's not fast)
You can run the flow from here or attach it to a button in a PowerApp (I think I will make a Utilities App with flows like this until CDS gets some fixes)
Done
Hope this helps 🙂