RemoveIf and UpdateIf not working with CDS LookUp field and variable

(1) Share

Report

Posted on by sammybridge

253

I have seen a few posts about this but nothing answers it properly.

I am trying to do a RemoveIf (and have previously tried UpdateIf) by using a variable as the right hand side of the code. I don't get any errors but it just doesn't remove anything from the source.

Has anybody managed to get this working?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @sammybridge ,

Your formula doesn't make sense. Please modify as below:

RemoveIf('NPI Profit and Losses', GUIDField in Filter('NPI Profit and Losses',ID.IDNew=NPlidvar).GUIDField)

Hope this helps.

Sik

Was this reply helpful? Yes No
sammybridge 253 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-siky-msft

Thanks for getting back to me. What do you mean when you say GUIDField?

Thanks

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sammybridge ,

GUIDField is a Field with Unique Identifier, which is unique index of the record generally. It is a default system field and can avoid errors caused by the same value.

For example: Account is the GUID field in Account Entity

Sik

Was this reply helpful? Yes No
sammybridge 253 on at

Like (0)

Report
Copy link

Link copied!

Thank you this has worked perfectly

Was this reply helpful? Yes No