web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps need help in Patch and...

Power Apps

Answered

need help in Patch and lookup functions

(0) Share

Report

Report

Posted on by IMathur

291

Hi Folks,

Below is the formula, i am using but it is giving me delegation error for Email property, how can i implement this:

Patch(changepoint, LookUp(changepoint, ProjectStatus.Value = "Completed" && Customer.Email= User().Email), {columnA: true} )

Customer is multi person or group column in changepoint (sharepoint list)

Please help!

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

GarethPrisk 2,828 on at

Like
a
(0)

Report
Copy link

Link copied!
Add a Global variable for your app, in the App's OnStart.
Set(gblUserEmail, User().Email);
Their email won't ever change during the session, and if you include the User() (or other non-delgable) functions as part of a delegable function, you'll see that warning.
Patch(changepoint, LookUp(changepoint, ProjectStatus.Value = "Completed" && Customer.Email= gblUserEmail), {columnA: true} )
IMathur 291 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GarethPrisk ,

Please see the image below,
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IMathur ,

There are a delegation error and incompatible type error on Customer.Email= User().Email part code, both error is because that the Customer column is Multi-selected person/group column.

The single-selected person/group column does support delegation when referring to the its Email, but Multi-selected person/group column doesn't support delegation.

Another issue is that Customer.Email code returns a single-column table with all customers' Email, but User().Email only returns a Text, that causes the incompatible type error.

The workaround:

Set(gblUserEmail, User().Email); Set(varID, LookUp(AddColumns(changepoint,"NewColumn",Concat(Approver,Email)), ProjectStatus.Value = "Completed" && gblUserEmail in NewColumn).ID); Patch(changepoint,{ID:varID},{columnA: true})

Hope this helps.

Sik

Join the conversation