Answered

The specified user i:0#.f|membership| could not be found

(0) Share

Report

Posted on by cbernier12

248

I'm using a dropdown box to pull values from the Office365 connector and submit to SharePoint people picker, however this doesn't work when the dropdown is blank.

Claims: "i:0#.f|membership|" & Lower('dropdown'.Selected.UserPrincipalName) I tired .Mail too, same issue.

It is returning only a value of i:0#.f|membership|

and errors out with "the specified user i:0#.f|membership| could not be found"

if I add a user it works fine and submits to SharePoint. This is new because I didn't have this issue in the past. Any ideas on how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @cbernier12,

When constructing the Person column schema manually (e.g. in the Update of the DataCard or within a Patch statement) you will have to wrap this in an if statement to not return anything in case of an empty selection:

If( //Only provide the Person record when a selection is made !IsBlank(DropdownName.Selected), //Provide your SP Person column schema here { DisplayName: ..., Claims: ... } )

Without using an If statement, you would send the following record to SP when no selection is made - causing the error.

{ DisplayName: "", Claims: "i:0#.f|membership|", Department: "", Email: User().Email, JobTitle: "", Picture: "" }

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
cbernier12 248 on at

Like
a
(0)

Report
Copy link

Link copied!
@LaurensM
Thanks, when I add this to the start of the if( statement
!IsBlank
it says !IsBlank not recognized and invalid.

Was this reply helpful? Yes No
cbernier12 248 on at

Like
a
(1)

Report
Copy link

Link copied!

@LaurensM never mind, I fixed it, I needed to move the SharePoint column above that statement.

Was this reply helpful? Yes No