Looking for some help please.
I’m trying to patch a combo box to a SharePoint Choice Column (Checkbox) but can’t seem to get anywhere. I can patch to a simple choice column, however after reading tutorials and videos on YouTube for combobox I’ve hit a dead end. Ive highlighted in red the patch string i found online, i think im nearly there, but need the forum help.
Solved! Go to Solution.
Hi @Mac,
Is the Products 2 column a Choice type column (which enables multiple options) within your SP list?
Do you want to save a Combo box selected values/options into the Products 2 column of your SP list?
Further, could you please share more details about the error message with the formula that you provided?
I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
Set the OnSelect property of the "Patch" button to following formula:
Patch(
'20181015_case13',
Defaults('20181015_case13'),
{
Title:"PowerAppsTest2",
FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
}
)
On your side, you should type following:
ForAll( CallBack, Patch( 'Call Back Form', Defaults('Call Back Form'), { Customer_x0020_Name: CustomerName, Title: Number, ... Products_x0020_2: ForAll(
DataCardValue17.SelectedItems,
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value: Value
}
) } ) )
Or
ClearCollect( ChoiceCollection, ForAll(DataCardValue17.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value}) ); ForAll( CallBack, Patch( 'Call Back Form', Defaults('Call Back Form'), { Customer_x0020_Name: CustomerName, Title: Number, ... Products_x0020_2: ChoiceCollection } ) )
Best regards,
Kris
Hi @Mac,
my simple suggestion is to get rid of choice columns in PowerApp by either changing the column type in SharePoint to single line of text or adding a calculated column with the choice column selected and using that instead.
Hi @Mac,
Is the Products 2 column a Choice type column (which enables multiple options) within your SP list?
Do you want to save a Combo box selected values/options into the Products 2 column of your SP list?
Further, could you please share more details about the error message with the formula that you provided?
I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
Set the OnSelect property of the "Patch" button to following formula:
Patch(
'20181015_case13',
Defaults('20181015_case13'),
{
Title:"PowerAppsTest2",
FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
}
)
On your side, you should type following:
ForAll( CallBack, Patch( 'Call Back Form', Defaults('Call Back Form'), { Customer_x0020_Name: CustomerName, Title: Number, ... Products_x0020_2: ForAll(
DataCardValue17.SelectedItems,
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value: Value
}
) } ) )
Or
ClearCollect( ChoiceCollection, ForAll(DataCardValue17.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value}) ); ForAll( CallBack, Patch( 'Call Back Form', Defaults('Call Back Form'), { Customer_x0020_Name: CustomerName, Title: Number, ... Products_x0020_2: ChoiceCollection } ) )
Best regards,
Kris
Hello @v-xida-msft ,
In this example:
Patch(
'20181015_case13',
Defaults('20181015_case13'),
{
Title:"PowerAppsTest2",
FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
}
)
Is there a way to concatenate an additional value outside the ForAll statement? For example, I have an "Other" option in the combobox which allows text input (OtherInput). So I would want to do something like:
FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})&", "Value: OtherInput.Text
This doesn't work, but I wanted to see how I might do this.
thanks
I had a similar issue.
I need to paste multiple selected items in a combobox to a sharepoint list text column.
This is how I did this inside Patch:
Patch(DestinationList,{TextColum: Concat(ComboBox.SelectedItems,VariableValue,", ")}
Concat(ComboBox.SelectedItems,VariableValue,", ")
This separates the items selected in combobox with ", " and converts the whole into text and allows me to patch the Sharepoint list.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
70 | |
50 | |
46 | |
20 |
User | Count |
---|---|
254 | |
120 | |
84 | |
79 | |
68 |