I had a Screen with gallery where I had loaded my data from excel. Then I deleted all the datas in the gallery. Now I am unable to load the data back to the gallery even when previous exxcel file has all the datas. I tried to load the data prearing a new canvas app. But was unable to get it. The gallery is empty.
When I try to add data manually. It gives me error.
The requested resource is locked
Can anyone help me out with this ?
Hello @Roji ,
Since you've already tried to create a new applcaition out of your Excel data, I think the issue is in the Excel file itself. Can you ensure that all the data in your Excel file are in a Table (you need to create a Table in Excel and then add all the data there)? Can you test with a brand new simple Excel file?
The data are already in table form. I also tried preparing new excel file and linking with new app, existing app one by one but that did not work. Is there anything else I am missing ?
Hi @Roji ,
Can you connect to the table correctly? Also, try to open your excel, select the whole table and clear all the formats here:
Then Format as table again to test.
My employee table looks like this:
When I create an app with onedrive and load this data into the app, the gallery screen looks like:
It doesnot have any value in the table. Previously, it would load data but because the first row in the gallery was empty so I deleted it and tried to reload it. Since, then this problem is persisitent and I am not finding any way to overcome this.
@v-monli-msft I tried the solution suggested by you and it is not making any changes.
And when I try to add new data I get error:
There was a problem saving your changes data source may be invalid !!!