Hi,
I have come across a strange problem, I have two search buttons with OnSelect property as
Set(srch,Sort(Filter('[dbo].[PSA2AC]',ACSearchInput.Text in ACProject),ACProject)) for one and OnSelect property as Set(srch,Sort(Filter('[dbo].[PSA2AC]',PSASearchInput.Text in PSAProject),PSAProject))
GalleryItems : If(IsBlank(ACSearchInput.Text)&&IsBlank(PSASearchInput.Text),Sort('[dbo].[PSA2AC]',ACProject),srch)
But when I serach for record and some values show up in gallery when I edit or delete them for filtered records,they donot updated automatically after editing or deleting, even after deleting it will still show in the flltered gallery,so here user thinks he has han't deleted the record and same for the editing also,
I would like to know how they get updated instantly , I tried Refresh of database after deletion and editing but it doesn't work.
For example you can see from the screenshot I have searched for record and when I edit one record and save it from the search results the record doesn't get updated automatically
