cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
egornua1
Helper V
Helper V

choice values from input form

Hi All,

 

i have a flow create an entry in a list from another list using input form (selected item)

 

Information passed from list 1 to 2 successfully but having issue with the choice values and this will impact PBI dashboard.

See below the entry comes in with " " and 

the colour values are when the user selects them manually from list 2.

i need the " values to reflect manual selection.

 

i have tried a compose and item expression but no joy.

Appreciate the support

 

 

choicePA.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @egornua1 

 

Thanks for the screenshare. So the fix we applied is we need to iterate this a loop to get each value. Then format the value (see below)  and append to an array for the multichoice update. 

 

{

"Value": "item()"

}

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

6 REPLIES 6
Caspar_Rubin
Solution Supplier
Solution Supplier

Hey,

 

I usually use the Select Data Operations Action to copy multi-select choice & person fields...

 

Like this:

 

  • Get items from List A. 
  • Loop through those items with the Apply to each action.
  • Use Select and put the Dynamic content from the get items action.
    In my case, that's Devices, it's the multiple-choice column's name. Don't use Value or Item here.
  • In the Map section of the Select Action, put value on the left side (key) and the Expression item()?['Value'] on the right side (value)
  • Then in the Create item action, you can use the Dynamic content Output from the select in the multi-select choice field.

 

 

Caspar_Rubin_1-1666271440426.png

 

It will then create the new items and the multiple-choice fields will be set correctly:

 

Caspar_Rubin_2-1666271687595.png

 

cheers

 

 

 

egornua1
Helper V
Helper V

@Caspar_Rubin - Thank you.

Problem is it doesn't allow me to select value from the "From a selected file" trigger.

The choice value i need is within that trigger form, it doesn't reside in list 1

Any other suggestions appreciated. cheers

egornua1
Helper V
Helper V

@Caspar_Rubin - Thank you.

Problem is it doesn't allow me to select value from the "From a selected file" trigger.

The choice value i need is within that trigger form, it doesn't reside in list 1

Any other suggestions appreciated. cheers

egornua1
Helper V
Helper V

 

Hi All,

how would i get the choice values, given they are only in the input in the for a selected item trigger.

thank you

Choice2.JPG

 

abm
Super User
Super User

Hi @egornua1 

 

Thanks for the screenshare. So the fix we applied is we need to iterate this a loop to get each value. Then format the value (see below)  and append to an array for the multichoice update. 

 

{

"Value": "item()"

}

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
egornua1
Helper V
Helper V

@abm - Thank you for the great support provided, much appreciated.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,401)