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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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