cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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
Community Support

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.

View solution in original post

3 REPLIES 3
Frequent Visitor

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
Community Support

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.

View solution in original post

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

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Users online (37,204)