undefined

(0) Share

Report

Posted on by Venkateswarlu_1

HI, I got one requirement I already tried but is not working please help me.

Patch(EmpTask,LookUp(EmpTask,ID=Gallery1_1.Selected.ID),{Assignee:NameUser.Text});

in the above formula orange color it showing error i don't know ?

Actually My requirements is NameUser.Text Value i will assigend to the Assignee Field But It is not working.

Show in bellow image. Please help me.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Fredrik_A 3,644 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
What exactly is the Assignee column? Is it text or a Person column?

If its a person column you need to patch it differently, if you have the email of the person in NameUser.Text try doing it like this:

Assignee:{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Department: "", Claims: "i:0#.f|membership|" & NameUser.Text, DisplayName: Office365Users.UserProfileV2(NameUser.Text).displayName, Email: NameUser.Text, JobTitle: "", Picture: "" }

Was this reply helpful? Yes No
LowCodeJim 314 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Venkateswarlu_1,

You will need to refer to the data text box "DataCardValue3" to get the text value. So your patch should be:
Patch(EmpTask,LookUp(EmpTask,ID=Gallery1_1.Selected.ID),{Assignee:DataCardValue3.Text});

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Venkateswarlu_1 51 on at

Like (0)

Report
Copy link

Link copied!

I am try in formula Patch(EmpTask,LookUp(EmpTask,ID=Gallery1_1.Selected.ID),{Assignee:DataCardValue3.Text});
but DataCardValue3.Text can not coming to the assignee field show in the below images.
IN image 1 gallery assignee field is empty in second row.

Was this reply helpful? Yes No
Venkateswarlu_1 51 on at

Like (0)

Report
Copy link

Link copied!

Assignee column it is text field with empty data.

Was this reply helpful? Yes No
Verified answer

LowCodeJim 314 Moderator on at

Like (1)

Report
Copy link

Link copied!

The issue is likely due to the form being reset upon submission, thus the field is blank when you are setting it in your collection. The option would be to either do the patch before the submit or store the variable into a temporary variable and patch it if the submission is successful etc.

Was this reply helpful? Yes No
Venkateswarlu_1 51 on at

Like (0)

Report
Copy link

Link copied!

Thank you 😊

Was this reply helpful? Yes No
Venkateswarlu_1 51 on at

Like (0)

Report
Copy link

Link copied!

Hi,SharePointJB I have Another Requirement in below image see i have Gallery, in that when i select first apply button at the time it is disabled remain button's are visible it is possible. Please Help Me.
I already write some code Please check It once.

Was this reply helpful? Yes No
LowCodeJim 314 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you sure the column name in your collection is "Apply_1"? That looks more likely just the name of the button in the gallery. Change "Apply_1" to whatever the column name is in the EmpTask collection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Venkateswarlu_1 51 on at

Like (0)

Report
Copy link

Link copied!

Apply_1 is a button it is there in gallery. In the button come every row of the gallery. i Want hide that fist button when i click on remain button will be visible.

Was this reply helpful? Yes No