Populate a SharePoint List column with choices selected in another multiple choice select column

Question

I want to populate a SharePoint List column called 'booked city' with choices that were selected in column called 'liked cities'?

E.g.

Liked Cities column has 10 cities to choose from, multiple cities can be chosen.

Customer A1 has chosen 4 cities, while customer A2 has chosen 3.

Choices for Booked City would be all cities that were chosen in column Liked Cities only 1 can be booked.

The list of choices for each customer will be different in column Booked City and will include only the choices of cities they have chosen in Liked Cities.

Customer ID Liked Cities Booked City

A1 London, Paris, New York, Moscow Moscow

A2 Moscow, Dublin, Sydney Dublin

Hope this helps, I had a look in other threads, was not able to find the same question, in most cases it is opening a new range of choices based on a selection.

Many thanks in advance for helping.

Answer 1

Here are steps to achieve this:

1.Create a Liked Cities multiple choices column has 10 cities.

2.Create a Booked City single choice column has 10 cities same as Liked Cities multiple choices column.

3.In the SharePoint list -> Integrate -> Power Apps -> Customize forms.

4.Booked City_DataCard1 -> DataCardValue4 -> Advanced -> Unlock to change properties -> Items -> Filter(Choices([@'0205'].BookedCity), Value in DataCardValue3.SelectedItems.Value)

Note: You need to replace '0205' with the name of your SharePoint list and DataCardValue3 with the name of the control for the Liked Cities field.

5.Save and publish the form to the SharePoint list.

6.Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.