Deleted records are still found by filter, locate etc.

(0) Share

Report

Posted on by dierenartsnl

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

dierenartsnl 9 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
dierenartsnl 9 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No