Can't patch CDS entity or ClearCollect from it

(0) Share

Report

Posted on by StuartRidout Microsoft Employee

Hi,

I have a really simple CDS entity SystemUsers (to differentiate from the default Users entity). It only has two fields

System User Email and System User Name (neither of which are set as required).

I am trying to patch a record into this entity using the following but it doesn't work.

Patch(SystemUsers,Defaults(SystemUsers),{cr842_systemuseremail:User().Email,cr842_systemusername:User().FullName})

I also tried reading back out of it to see if that worked using the following but that didn't work either

ClearCollect(SomeUsers,SystemUsers)

If I have a gallery bound to SystemUsers that works, and if I create an edit form bound to SystemUsers I can write an entry that way.

I've attached a screenshot of the entity here in case there is anything obvious. Has anyone got any ideas as I am pulling my hair out and there is very little left!

Categories:

Entities

CDS entity.PNG

All responses (1)

Answers (1)

Verified answer

StuartRidout Microsoft Employee on at

Like (0)

Report

Re: Can't patch CDS entity or ClearCollect from it

Ignore me ... the reason the code didn't work was that I had the button set to View rather than Edit and I didn't realise that meant you can't click it and the code was never getting called. You live and learn! #everydayisaschoolday

Move along now, nothing to see here!