Unanswered

Patch Person or Group column in SharePoint and get data from a Combo Box

(0) Share

Report

Posted on by Lynette Sanchez

I have an “Assigned To” person or group field in my SharePoint List. I am using a Combo Box for the Assign To column in power apps (I will only have 1 person in this field)

How do I get the drop down to display the person name for people in my organization.
How do I get the patch to update the fields for the current item
How do I get patch to Create a new item when necessary.

Patch will Save but creates a new item and I need to get the Assigned To working as well. Any assistance is very much appreciated.

SP List:

Assign To in Power App:

Items = Choices('IT Hardware'.'Assigned To')

DisplayFields = ["DisplayName"]

SearchFields = ["DisplayName"]

Save button

Patch:

Patch(

'IT Hardware',

Defaults('IT Hardware'),

{

Asset: DataCardValue9.Text,

'Assigned Name': DataCardValue10.Text,

'Asset ID': DataCardValue11.Text,

Manufacturer: DataCardValue15.Text,

'Model/Version': DataCardValue16.Text,

'Bar Code': DataCardValue17.Text,

'Asset Status': DrpAssetStatus.Selected,

'Asset Type': DrpAssetType.Selected

}

);

Notify("Update successful", NotificationType.Success)

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lsanchez29 ,

Assuming DataCardValue10 is the Combo Box mentioned and 'Assigned Name' is a Text field, you should need

'Assigned Name': DataCardValue10.Selected.DisplayName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Lynette Sanchez 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you 'Assigned Name': DataCardValue10.Text is a Single line of text in SHarePoint. What I am trying to understand is how to get a dropdown or combo box for Assigned To which is a Person or Group in SharePoint. I need assistance with the combo box and how to Patch to SharePoint (Update current item and ability to create a new item. Data Source SharePoint and Office365 Users
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@lsanchez29 ,

Can you please list the field names and types together with the control names and types (and Items if drop downs) of all the elements you want to patch from and to.

Lynette Sanchez

11 on at

Like (0)

Report

Copy link

Link copied!

Hello, I think I've gathered the information you were requesting. Please note that I have changed the names to reflect the proper naming convention for the App. I've also include an example of the app for reference, thank you for taking the time to assist.

SharePoint Display Name	SharePoint Internal Name	Type	Power App
Asset	Title	Single line of text	Txt_Asset
Assing Name	Asset_x0020_Name	Single line of text	Txt_DataAssgndName
Asset Id	Asset_x0020_ID	Single line of text	Txt_AssetId
Asset Status	Asset_x0020_Status	Choice	Drp_AssetStatus	Drop Down -Choices([@'IT Hardware'].'Asset Status')
Manufacturer	Manufacturer	Single line of text	Txt_Manufacturer
Model	Model_x002f_Version	Single line of text	Txt_Model
Asset Type	Asset_x0020_Type	Choice	Drp_AssetType	Drop Down - Choices([@'IT Hardware'].'Asset Type')
Bar code	BarCode	Single line of text	Bar_Reader	BarcodeReader1
Assign To	Assigned_x0020_To	Person or Group	Cmb_AssignTo	Office365Users.SearchUser({searchTerm:Cmb_AssignTo.SearchText}.DisplayName

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@lsanchez29 ,

Based on the values you have posted

Patch( 'IT Hardware', Defaults('IT Hardware'), { Asset: Txt_Asset.Text, 'Assigned To': { Claims: "i:0#.f|membership|" & Lower(Cmb_AssignTo.Se3lected.Mail), Department: "", DisplayName: Cmb_AssignTo.Selected.DisplayName, Email: Cmb_AssignTo.Se3lected.Mail, JobTitle: "", Picture: "" }, DataCardValue10.Text, 'Asset ID': Txt_AssetId.Text, Manufacturer: Txt_Manufacturer.Text, 'Model/Version': Txt_Model.Text, 'Bar Code': First(BarcodeReader1.Barcodes).Value, 'Asset Status': DrpAssetStatus.Selected, 'Asset Type': DrpAssetType.Selected } ); Notify( "Update successful", NotificationType.Success )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps