Hi Everyone,
I could really use some help please. I am self-taught in this space, watching training videos etc but have come across a problem that I cannot seem to overcome.
I have a flow which, when a new item is loaded into one SharePoint list, it creates an entry in another list, copying across several values to corresponding fields (i.e. Customer Name, Product Name etc etc).
The issue I have is this. There is one column in the source site which is a multi select, for example purposes, the values are:
In the source site, this translates to a drop-down (single value) which is:
What I am trying to do is, when copying across from source:
Source | Destination |
The Apple Group (TAG) | TAG |
The Orange Group (TOG) | TOG |
The Pear Group (TPG) | TPG |
If all 3 selected.... | Fruit Salad |
It's probably something very simple or it may not even be achievable, but would appreciate any guidance here. Have checked a few forums but can't seem to find something specific to this scenario.