Announcements
I am creating a custom form from a sharepoint template list. The "assigned to" I am pulling from an excel table a list of names.
It lets me visualize the drop down name of lists on the custom form however it doesn't not appear on the form when selected and saved. How do I connect the two?
Hi @GEC ,
Assuming your Excel data source has the email address of the user, change the Update property of the Assigned To_DataCard to:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: $"i:0#.f|membership|{DataCardValueX.Selected.Value}", Department: "", DisplayName: "", Email: DataCardValueX.Selected.Value, JobTitle: "", Picture: "" }
In this you have to replace DataCardValueX with the name of the Combo Box inside the DataCard.
@BCBuizer Thanks for the quick response!
How would this change if I don't want to display the email address, job title, or picture? Just the dropdown with the name. It's just a single column with the name needed.
These fields are needed in case you want to save anything to a Person/Group type column, which is what the 'Assigned to' column seems to be. In case you don't want it to be a Person/Group type column (just save the email address), change the column type in SharePoint to Single line of Text.
The Update property of the DataCard should then be set to:
DataCardValueX.Selected.Value
It doesn't appear to be working. I added a new column on the sharepoint list with a combo box.
So when I added the formula DataCardValue7.Selected.value to the update I get an error that says the value is not recognized. I can select it here just fine but it won't populate on the sharepoint list.
But it also needs to appear here
Try replacing .Value with the name of the column that has the value that should populate the Requestor2 column.
@BCBuizer
That doesn't seem to be working either. In the excel table the column title is named Requestor then in the sharepoint list the column is labeled requestor2. I've tried both and it doesn't seem to be working. I've attached more screen shots of the data card properties.
HI @GEC ,
What is the error text you receive for this?
@BC
Expected Record
value.
Requestor2 was supposed to be a Text type column, but if it is expecting a record, it is not. Can you change it to a Text type?
@BCBuizer It's a custom data card so I'm not entirely sure to edit it.
Can it still be a text type with a drop down to pick from an excel table value?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
