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

Capture.PNG

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-siky-msft on at

Like (0)

Report
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

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

Like (0)

Report

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

Thank you this has worked perfectly

Was this reply helpful? Yes No