Hi @PowerAppsJunkie ,
Could you please share a bit more about the Region column in your SP list? Is it a Choice type column or Single line text column?
For your first question, I have made a test on my side, please take a try with the following workaround:
Add a Dropdown control (Dropdown1) within your app, set the Items property to following:
1. The Region column is a Choice type column:
Distinct('SharePoint List 1', Region.Value)
2. The Region column is a Single text type column:
Distinct('SharePoint List 1', Region)
Add a Label within your app, set the Text property to following:
Concat( /* <-- Region is Choice type column */
Filter('SharePoint List 1', Region.Value = Dropdown1.Selected.Result),
Name & "; "
)
or
Concat( /* <-- Region is Single line text type column */
Filter('SharePoint List 1', Region = Dropdown1.Selected.Result),
Name & "; "
)
For your second question, If you want to patch the concatenated Name items and selected region value (from the Dropdown1) back to your SharePoint List 2, I think the Patch function could achieve your needs. Please consider take a try with the following workaround:
Add a Button (called "Submit") within your app, Set the OnSelect property of the "Submit" button to following:
Patch( /* <-- Region column is 'SharePoint List 2' is Choice type column */
'SharePoint List 2',
Defaults('SharePoint List 2'),
{
Names: Concat(Filter('SharePoint List 1', Region.Value = Dropdown1.Selected.Result), Name & "; " ),
Region: {
Value: Dropdown1.Selected.Result
}
}
)
or
Patch( /* <-- Region column is 'SharePoint List 2' is Single line text type column */
'SharePoint List 2',
Defaults('SharePoint List 2'),
{
Names: Concat(Filter('SharePoint List 1', Region.Value = Dropdown1.Selected.Result), Name & "; " ),
Region: Dropdown1.Selected.Result
}
)
Please consider take a try with above solution, check if the issue is solved.
Best regards,
