Hi @Crimcrow ,
Could you please share a bit more about the issue that you mentioned?
Do you only want to display one item (combined result) within the Number1 Dropdown?
Further, which column do you use to store the Number1 Dropdown value within your SP list data source?
I assume that you only want to display one item (combined result) within the Number1 Dropdown, and want to patch this Number1 Dropdown value into your SP list, is it true?
If you want to patch this Number1 Dropdown value into your SP list, I think the Patch function could achieve your needs. I have made a test on my side, please take a try with the following workaround:
Set the OnSelect property of the "Submit" button to following formula:
Patch(
'YourSPList',
Defaults('YourSPList'),
{
...,
ZoneFiled: Number1Dropdown.Selected.Value, /* <-- ZoneField represents the Text type field in your SP list, which used to store the Number1 Dropdown value */
...
}
)
Note: I assume that you use Text type column in your SP list to store the Number1 Dropdown value.
If you use Choice type column to store the Number1 Dropdown value, please modify above formula as below:
Patch(
'YourSPList',
Defaults('YourSPList'),
{
...,
ZoneFiled: {
Value: Number1Dropdown.Selected.Value
}, /* <-- ZoneField represents the Text type field in your SP list, which used to store the Number1 Dropdown value */
...
}
)
In addition, if you use the SubmitForm() function to submit your form data, you could also consider take a try with the following workaround:
Set the Update property of the Zone Data card to following:
Number1Dropdown.Selected.Value
Set the Default property of the Number1 Dropdown control to following:
Table(ThisItem.ZoneField)
Note: I assume that you use a Text type column in your SP list to store the Number1 Dropdown value.
More details about Patch function in PowerApps, please check the following article:
Patch function
Best regards,
