Set Assigned User to current user in CDS

[Dr_David_Banner]

Hi

I'm really new to PowerApps so please bare with me

I'm trying to update a field in the CDS with the current user - the idea is for the user to assign the item to themselves

I've created a label using the user().FullName function and called it "Userfullname" 

I have a custom field in the CDS called "Assigned To" and this is the command I am using so far (unsuccessfully)

Patch([@Alerts], ThisItem, {'Assigned To' : Userfullname})

can anyone help? 

thanks

[eka24]

I guess the formula is inside a Gallery.

Use

Patch([@Alerts], ThisItem, {'Assigned To' : User(). FullName})

Or if a variable, OnStart of the App or Onvisible:

Set(Userfullname,User().FullName)

Then change your formula to:

Patch([@Alerts], ThisItem, {'Assigned To' : Userfullname})

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dr_David_Banner]

thanks @eka24 

I appreciate your help with this

I have tried 

Patch([@Alerts], ThisItem, {'Assigned To' : User().Fullname})

the error I get is: 

The type of the argument "qrs_AssignedTo" does not match the expected type 'Record'. Found Type 'Text'

[eka24]

Use

Patch([@Alerts], ThisItem, {'Assigned To' : {Value:User().Fullname}})

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dr_David_Banner]

thanks again, I now have another error message: 

invalid argument type. Expecting a Record Value, but of a different schema

missing column. Your formula is missing a column "Access Mode" with a type of 'OptionSetValue'

thanks

[Dr_David_Banner]

The custom field "Assigned to" in the CDS is a lookup field linked to the user entity BTW

[v-siky-msft · Accepted solution]

Hi @Dr_David_Banner ,

Since the Assign To is a lookup field, you need to save a record of parent entity to that field. Please try this:

Patch([@Alerts], ThisItem, {'Assigned To' : LookUp(Users,'Full Name'=Userfullname.Text)})

Hope this helps.

Sik

[Dr_David_Banner]

thanks, that is working perfectly, much appreciated