Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

New to Power Automate - Help with assigning value from one SharePoint list to another

(0) ShareShare
ReportReport
Posted on by

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:

  • The Apple Group (TAG)
  • The Orange Group (TOG)
  • The Pear Group (TPG)

In the source site, this translates to a drop-down (single value) which is:

  • TAG
  • TOG
  • TPG
  • Fruit Salad


What I am trying to do is, when copying across from source:

SourceDestination

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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard