Deleted excel row

[dandandsan]

Hi,

I have a basic app displaying data from an excel data connection which is fine. When I delete data in the excel sheet the app is still showing the a blank entry, I have tried deleting the row but still no joy, is this normal?

[v-xiaochen-msft · Accepted solution]

Hi @dandandsan ,

Could you tell me:

1. What is your connector? (Did you use onedrive connector?)
2. Did you delete the record in Excel? Did this record in the gallery just become a blank record ?

If my assumption is correct, there are two important points.

1. Firstly, Close your table.
2. Secondly, refresh your data source.

I've made a test for your reference:

1\ This is my table “Van” and my gallery control.

2\Add an Icon control and set is onselect property to:

Refresh(Van)

3\ Firstly, I opened the table and deleted the third line (third record). Then closed the table. Finally, I clicked the refresh icon.

4\ The result is as follows:

In addition, sometimes "onedrive" has a delay. Please wait a while and click the refresh icon again.

Hope this helps.

Best Regards,

Wearsky

[dandandsan]

@v-xiaochen-msft 

Thank you for your reply. It now works fine and as per your instructions.