Answered

How To: Patching people selection with if is blank

(0) Share

Report

Posted on by mattthew

I have patched through a people selection using Shane Young's tutorial . The issue I came across is if it is not selected it won't patch through. How can I wrap a function around it to still patch through the rest of the values and leave that selection blank?

Error received if left blank: 'The specified user could not be found'

{Title: galProjectList.Selected.'Short Title',
Collaborator: {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Claims: "i:0#.f|membership|" & Lower(DS_Collab_Select.Selected.Mail),
 Department: "",
 DisplayName: "",
 Email: DS_Collab_Select.Selected.Mail,
 JobTitle: ".",
 Picture: "."
 },

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

KrishnaV 5,023 on at

Like (1)

Report
Hi @mattthew ,

Sorry for the little late in reply, here is the code snippet to patch even though we don't have value for people field.
Patch( 'Project Details', Defaults('Project Details'), {Title: galProjectList.Selected.'Short Title'}, If( !IsBlank(DS_Collab_Select.Selected.Mail), { Collaborator: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Claims: "i:0#.f|membership|" & Lower(DS_Collab_Select.Selected.Mail), Department: "", DisplayName: "", Email: Lower(DS_Collab_Select.Selected.Mail), JobTitle: ".", Picture: "." } } ) );
Here is the working model of the above code block.

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps, then please consider Accept it as the solution and give thumbs-up to help the other members find it more.

Was this reply helpful? Yes No
mattthew 65 on at

Like (0)

Report

Thanks @KrishnaV

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Krishna,

Actually, I tried on the same, I am not getting any error, but only people picker is not updating to blank, remaining fields are okay, could you help on the same

Patch(
'Patch', ThisItem,
{ Title: DataCardValue1.Text},
// {REGION: DataCardValue2.Selecteditems}
If(
!IsBlank(DataCardValue3.Selected.Email),
{
Person:{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Claims: "i:0#.f|membership|" & Lower(DataCardValue3.Selected.Email),
Department: "",
DisplayName: "",
Email: User().Email,
JobTitle: ".",
Picture: "."
}
}
)

)

Was this reply helpful? Yes No