Answered

Allow fill-in for column currently searching Office365 users

(0) Share

Report

Posted on by mlaurie

I have a situation in a form in which the current way a person is selected is to choose from a field that is set to look up anyone in the tenant. There is a need to allow a fill-in choice as the user needing to be selected hasn't been put into the tenant yet as they are a new-hire, transferring positions, etc. I found this script (inserted into the Update property) to allow the form to be saved without an invalid value.

If(Not IsBlank(DataCardValue2.Selected), DataCardValue2.Selected,{Value: DataCardValue2.SearchText, '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

The problem is the .searchtext is not being saved to the SharePoint column, all other fields are saving to their corresponding columns. Any ideas from the community?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mlaurie ,
Do you want to update data to the person column?
I suggest you patch the new employee's information to the person coulmn.
Then you could search him in the combo box.
Here's patch formula for your reference:
Patch(Patchtesting,
Defaults(Patchtesting), { Title:"SinglePerson", Person: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|michael@testing.com", Department:"", DisplayName:"Michael Shao", Email:"Michael@testing.com", JobTitle:"", Picture:"" }})

Here's a similar issue for your reference:
https://powerusers.microsoft.com/t5/General-Discussion/Saving-data-from-powerapps-to-SP-lists-person-Group-column/td-p/77329

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Verified answer

mlaurie 50 on at

Like (0)

Report
Copy link

Link copied!

Hello, thank you for your reply. I want to be able to only accept the text in the DataCardValue2.text and not patch the new employee in as I don't want multiple entries when they finally get a tenant user account created.

I spoke with the stakeholder and we have opted to use a text input field instead of a people picker all together. Thanks for your help!

Was this reply helpful? Yes No