cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dandandsan
Helper II
Helper II

Deleted excel row

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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.

v-xiaochen-msft_0-1608002846456.jpeg

 

v-xiaochen-msft_1-1608002846457.jpeg

 

 

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.

v-xiaochen-msft_2-1608002846459.jpeg

 

 

4\ The result is as follows:

v-xiaochen-msft_3-1608002846460.jpeg

 

 

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

Hope this helps.

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

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.

v-xiaochen-msft_0-1608002846456.jpeg

 

v-xiaochen-msft_1-1608002846457.jpeg

 

 

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.

v-xiaochen-msft_2-1608002846459.jpeg

 

 

4\ The result is as follows:

v-xiaochen-msft_3-1608002846460.jpeg

 

 

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

Hope this helps.

 

Best Regards,

Wearsky

@v-xiaochen-msft 

 

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,573)