I would like to check if a record exist in a datasource before patching it in.
This works if the record was already there since before the last refresh of the datasource.
IF instead the record was just added in the PREVIOUS patching, then it is NOT FOUND.
In fact, it's not even listed in the drop down menu that I'm using to display the datasource.
IS THE REFRESH() FUNCTION AT FAULT??
// trying to refresh in order to get the latest data
Refresh('helpdesk-categorie'); // not working?????
// checking if the record exists
If(IsBlank(LookUp('helpdesk-categorie', Title = input1.Text)),
// if the record does NOT exist, then
EDIT: actually, even if you manually refresh the datasource, it's still going to patch the same data twice, before failing this test:
IsBlank(LookUp('helpdesk-categorie', Title = input1.Text))
Hi @v-yutliu-msft , thank for your reply and my apologies for taking so long to get back to you.
I am still experiencing this issue but I found a work around.
First, I collect the whole source into a collection (the source is only 1 column with no more than a couple hundred rows). When patching, I also collect the new row into the collection. Before patching, I check the collection and not the source.