Answered

patch people picker to SharePoint person field

(0) Share

Report

Posted on by holland1994

I have a people picker in my app that is connected to a SharePoint person field. When I try and patch the field I get an error. The section of the patch formula is below. I get the error 'The type of this argument does not match the expected type 'Table'. Found type 'Record'.' What is wrong with my formula?

'Strat Comm Partner Email':{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(
LookUp(
Office365Users.SearchUser(),
DisplayName = TicketDetailStratCommPartnerComboBox.Selected.DisplayName
).Mail
),
Email: LookUp(
Office365Users.SearchUser(),
DisplayName = TicketDetailStratCommPartnerComboBox.Selected.DisplayName
).Mail,
Picture: "",
JobTitle: "",
Department: "",
DisplayName: TicketDetailStratCommPartnerComboBox.Selected.DisplayName
}

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@holland1994

If the formula is expecting a Table then most likely your person column in your list is allowing multiple selections.

Please consider changing your Formula to the following:

'Strat Comm Partner Email': With({_user:Lower(LookUp(Office365Users.SearchUser(),DisplayName = TicketDetailStratCommPartnerComboBox.Selected.DisplayName)}, Table( { Claims: "i:0#.f|membership|" & _user.Mail), Email: _user.Mail, Picture: "", JobTitle: "", Department: "", DisplayName: _user.DisplayName } ) )

You don't need the odata.type any longer and you should take the expensive searchusers function into one lookup - in the above it is done once and assigned to a scoped variable.

I hope this is helpful for you.

Was this reply helpful? Yes No
holland1994 11 on at

Like (0)

Report
Copy link

Link copied!

Now i'm getting an error with (LookUp(Office365Users.SearchUser(),DisplayName = TicketDetailStratCommPartnerComboBox.Selected.DisplayName)} It says invalid argument type (record) expected text.

Also, it doesn't like the .mail. it says invalid use of '.'

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@holland1994

Sorry, left out a closing paren.

Formula should be:

'Strat Comm Partner Email': With({_user: Lower( LookUp(Office365Users.SearchUser(), DisplayName = TicketDetailStratCommPartnerComboBox.Selected.DisplayName ) ) }, Table( { Claims: "i:0#.f|membership|" & _user.Mail), Email: _user.Mail, Picture: "", JobTitle: "", Department: "", DisplayName: _user.DisplayName } ) )

I separated it all above so I made sure I was matching parens.

Was this reply helpful? Yes No
holland1994 11 on at

Like (0)

Report
Copy link

Link copied!

I'm still getting errors

Was this reply helpful? Yes No
holland1994 11 on at

Like (0)

Report
Copy link

Link copied!

removed the Lower function which helped. Now I'm getting invalid number of arguments and unexpected use of colon

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@holland1994

Ha...I found where my missing ending paren went from before. I've now got an extra one in there.

Sorry, we type these formulas out by hand in the forum and there is no formula editor to aid in syntax.

When you mentioned Lower...I realized I had move that part to the wrong place and left its closing paren in place.

It's still early here, so my morning coffee has not kicked in yet 😴 ☕

Formula should be:

'Strat Comm Partner Email': With({_user: LookUp(Office365Users.SearchUser(), DisplayName = TicketDetailStratCommPartnerComboBox.Selected.DisplayName ) }, Table( { Claims: "i:0#.f|membership|" & Lower(_user.Mail), Email: _user.Mail, Picture: "", JobTitle: "", Department: "", DisplayName: _user.DisplayName } ) )

Was this reply helpful? Yes No