web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Deleted excel row

Power Apps

Answered

Deleted excel row

(0) Share

Report

Report

Posted on by dandandsan

98

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?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @dandandsan ,
Could you tell me:
What is your connector? (Did you use onedrive connector?)
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.
Firstly, Close your table.
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

Was this reply helpful? Yes No
dandandsan 98 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft

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

Was this reply helpful? Yes No

Join the conversation