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

View solution in original post

@v-xiaochen-msft 

 

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

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,613)