Share
Report
271I've built an app that uses a repeatable gallery to put various fields of data into a Collection, and then the user click a Submit button, and the data in the Collection is patched to a SharePoint list. It's all working well except for one field. In my gallery input data card, I have a person search combo-box for selecting a person from our Office365Users connector. The search and select function work fine... but I can't figure out how to get the Record to save to the Collection. I believe the issue might be how the Collection is being created in the first place, i.e. that specific field needs to be created in a way that accepts a record - but I've tried several approaches without success.
This is the OnSelect code of the button that creates the collection:
ClearCollect(
colItemsV2,
{
ItemNumber: varItemNumber,
Item: "",
RequestedFor: Blank(), //I thought this would create a "Record" type field in the collection, but ???
RequestedForDisplay: "",
Cost: 0,
Quantity: 0,
QuantityType: "Item(s)",
DateNeeded: Today(),
DeliveryRequired: false,
ItemComments: "",
Source: "",
SourceURL: "",
Subtotal: 0,
ShowSaveButtons: true
}
);
Navigate(scr_ComposeOrder, ScreenTransition.Fade);
And this is the code that saves the data to the Collection:
Patch(
colItemsV2,
ThisItem,
{
Item: inp_Itemv2.Text,
RequestedFor: "" , //Not sure what to do here. The input field is a combo-box search for a person in our Office365User connection.
Cost: Value(inp_Costv2.Text),
Quantity: Value(inp_Quantityv2.Text),
QuantityType: inp_QuantityTypev2.Selected.Value,
DateNeeded: dp_DateNeededv2.SelectedDate,
DeliveryRequired: ckbx_DeliveryReqv2.Value,
ItemComments: inp_ItemComments.Text,
Source: inp_Sourcev2.Text,
SourceURL: inp_SourceURLv2.Text,
Subtotal: Value(inp_Costv2.Text) * Value(inp_Quantityv2.Text),
ShowSaveButtons: false
}
);
I've tried using "RequestedFor: cb_UserSearch;" and that does appear to add the record to the collection. But then when I try to Patch the collection to the SharePoint list, that's where I get stuck. I cannot figure out what needs to go after RequestedFor in the Patch to the SP List. Here's the code I have, with ???? being the confounding part...
ForAll(
colItemsV2,
If(!IsBlank(Item),
Patch(
'Procurement Request Line Items',
Defaults('Procurement Request Line Items'),
{
Title: Item,
RequestedFor: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & ????,
Department: "",
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
},
Cost: Cost,
All responses (
Answers (
