Entities data lost

(0) Share

Report

Posted on by Er_Dago

Hi,

i'd created entities with some data.

It work fine, but after 2/3 days app don't show data and when i verify entity, no data in it...it's second time that it happens

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Er_Dago,

Are you using a custom entity in CDS? Which environment are you using? Could you open the entity in Excel to see if there are any data in it?

I have an app based on CDS entity which was created 1 month ago, I opened the app just now, all the data were shown properly. I opened the entity in Excel, the data can also be checked in the Excel file.

Best regards,
Mabel Mao
Er_Dago 13 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm using Custom entity in CDS in a custom Envirorment "Test".
When i load data first time it work fine for 2/3 days, then without any update of app or entity, app return error and data in entity vanished.
I can open it in excel but it's empty.
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Er_Dago,

Thanks for your reply. I haven’t seen a similar issue likes yours so far, so according to your description, I create a custom entity named “test entity” in the test environment, then I create an app from data with this entity. Below is a screenshot of my app:

I add three items by clicking the “+” button in the app, then I open the entity in Excel file, below is the data in the Excel file:

I will check this app after about 2/3 days to see if I would get the same issue with you. Please correct me if I don’t understand your scenario correctly.

BTW, how is your app created? How many data are there in your data source? If you have any special configuration in the app, please let me know, it might be helpful to reproduce this issue.

Best regards,
Mabel Mao
Er_Dago 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, correct.
I've an entity with 900+ record and 13 Field.
other simple entity with 1 column and few data didn't lost data.
No particular configuration, only filter on data shown like:
Filter(SortByColumns(Search(Filter(Entity;Codice=Dropdown1.Selected.Value); TextSearchBox1.Text; "Nome";"Codice";"Cognome";"Email"); "Cognome"; If(SortDescending1; Descending; Ascending));Codice=Dropdown1.Selected.Value)
Greetings
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Er_Dago,

Thanks for your reply. I wonder that there are some invalid values in your function. Could you please try with this function?
SortByColumns(Search(testentity, TextSearchBox1.Text,"Address_AddressLine1","Address_AddressLine2","Address_City"), "Address_AddressLine1", If(SortDescending1, Descending, Ascending))

I add more fields in the testentity, with more than 1000 records. Then I refresh the app I created yesterday, all the data can be shown. Using this function:
SortByColumns(Search(testentity, TextSearchBox1.Text,"Address_AddressLine1","Address_AddressLine2","Address_City"), "Address_AddressLine1", If(SortDescending1, Descending, Ascending))

An article about Search, Filter function could be a reference for you:
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

I will keep an eye on my app to see if I could reproduce this issue.

Best regards,
Mabel Mao
Verified answer

Er_Dago 13 on at

Like
a
(0)

Report
Copy link

Link copied!

No solution... But i solved using sharepoint access web app. No more data lost
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Er_Dago,

I checked the app created 5 days ago which is based on a CDS custom entity. But the data didn’t lose. All the data were shown on the app.

My app was created from data with Common Data Service with no customization on the functions. Did you customize the functions?

Also glad to hear that you have solved this issue by using SharePoint Access Web app. If you got any other issues, welcome post your issues here, we are always ready to help.

Best regards,
Mabel Mao
steven_wang 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mabel,

I'm having the same issue here. The last time I modified this custom entity was 01/10/2017. Today when I tried to export the data, it said "can't export". So I clicked "data" and found no data was there.

I also tried to open it in Excel, enabled editting, trust the Add-in, but got an error message in Excel as below:

As a result, my app connected to that entity can't be used either. When I used the app on my phone, an error message showed up ssaying "failed to load 'Inputs_'. Server response: No HTTP resource was found that matches the request URI. No route data was found for this request"

This problem only happens to one of my custom entities. All other custom entites can be exported, opened in Excel and assessed without any problem.

Do you have any idea why it happened? Thanks!
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Steven_wang,

Did you get the error message suddenly today? And only one custom entity occurred the error, right?
Do you have any special configures on the entity? Could you show me some details information about your entity if convenience?

From the error message, it seems that it is a server connection issue. I will have to report it from my side, I will back to you if I got any updates.

Best regards,
Mabel Mao
steven_wang 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it happened suddenly and only one entity had such a problem. But today, another entity I created last Friday had this problem again...I don't know why.

Details of the problematic entities.
The first one uses AutoNumber as primary id, and I also created a few fields that are integers or text.
The second one uses AutoNumber as primary id as well, and all the other fields are text.
Both of them were created in a new environment instead of the default environment because in the default environment I was asked to create a new environment first to use the Common Data Service.

I used the Flow in my app to get a record from Common Data Service and update a record. Everything worked fine last Friday, and nobody touched anything during this weekend. But when we used our app this morning, Common Data Service failed to load the underlying entity.

Please let me know if you have any updates or thoughts on it. Thank you!