cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dierenartsnl
Level: Powered On

Deleted records are still found by filter, locate etc.

I have two apps. In one app i have an unfiltered gallery on table (powerapps entity) kenneluser.

In another app I populate the table with identical records using patch, let us say 8 records

In the first app I can see the records appearing.

In that app I have a button to clear the table

 

RemoveIf(KennelUser;true)

 

All records disappear from the gallery.

In the second app I click respectively

-a button that puts an empty string in a label

-a button that puts the number of records that match a filter in the same label

 

Set(NumFinds;CountRows(Filter(KennelUser;Email=Trim(User().Email))))
;;
Set(LabelText;Text(NumFinds))

 

The label says "8".

If I leave averything alone and look again after a day the records are not found anymore, it says "0"

Is this something I am supposed to live with or am I doing something wrong/incomplete. Do I have to submit something after clearing the table or something like that?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Deleted records are still found by filter, locate etc.

Hi @dierenartsnl ,

 

Can you please share more details about this app? 

 

Is your data source CDS entity? What is the column type of "Email"? How many buttons do you have in the 2nd app and what are the formulas in their OnSelect property? What is the Text property of your label controls? 

 

If both apps have the same data source and you remove all the records of this data source in your first app, then it is expected behavior that in your 2nd app, no records would show. But you need to first do a refresh of the data source. You can add a button and set its OnSelect property to:

Refresh(KennelUser)

The reason why the number become 0 after one day is that you migh closed the app and reload it again. During the process, the data source is refreshed when you reopening it.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
dierenartsnl
Level: Powered On

Re: Deleted records are still found by filter, locate etc.

Why does nobody care about this problem? What do i have to do? Include a boolean field -deleted- in each table and add -not deleted- everytime i use a filter?
Community Support Team
Community Support Team

Re: Deleted records are still found by filter, locate etc.

Hi @dierenartsnl ,

 

Can you please share more details about this app? 

 

Is your data source CDS entity? What is the column type of "Email"? How many buttons do you have in the 2nd app and what are the formulas in their OnSelect property? What is the Text property of your label controls? 

 

If both apps have the same data source and you remove all the records of this data source in your first app, then it is expected behavior that in your 2nd app, no records would show. But you need to first do a refresh of the data source. You can add a button and set its OnSelect property to:

Refresh(KennelUser)

The reason why the number become 0 after one day is that you migh closed the app and reload it again. During the process, the data source is refreshed when you reopening it.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dierenartsnl
Level: Powered On

Re: Deleted records are still found by filter, locate etc.

Thanks! The refresh part was what is missing. Guess I still have to adjust to cloud based datbases.