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?

Capture.PNG

All responses (4)

Answers (1)

sammybridge 253 on at

Like (0)

Report

Re: RemoveIf and UpdateIf not working with CDS LookUp field and variable

Thank you this has worked perfectly
v-siky-msft on at

Like (0)

Report

Re: RemoveIf and UpdateIf not working with CDS LookUp field and variable

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
sammybridge 253 on at

Like (0)

Report

Re: RemoveIf and UpdateIf not working with CDS LookUp field and variable

Hi @v-siky-msft

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

Thanks
Verified answer

v-siky-msft on at

Like (0)

Report
Re: RemoveIf and UpdateIf not working with CDS LookUp field and variable

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