cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oatman2000
Regular Visitor

MS Forms Choice Field to SharePoint List Decision Pill using Power Automate

Hi Team,

 

I created a form in MS Forms and I've figured out how to pass pretty much all the information over to a SharePoint / MS List, except for a single picklist.

 

I'm looking to fill the decision of a single (not multi) picklist dropdown to populate a decision pill option in SharePoint Lists.

I've been able to work the logic using a multi selection but can't figure out how the single works??

 

Please and Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @Oatman2000 ,

 

I have a test Form with a choice question:

vjefferni_0-1651132284795.png

and a Choice column which includes the same options as the choice question of the Form:

vjefferni_2-1651132415167.png

 

In the flow, I use the custom value from outputs of the get response details action:

vjefferni_3-1651132458563.png

vjefferni_4-1651132487981.png

 

I submitted the Form and got the new item inserted in the list correctly:

vjefferni_5-1651132551571.png

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

5 REPLIES 5
Oatman2000
Regular Visitor

You can easily format the column in SharePoint to "Text" and it will receive the decision from MS Forms. 

Doing this breaks any manual input being a dropdown choice. 

v-jefferni
Community Support
Community Support

Hi @Oatman2000 ,

 

I have a test Form with a choice question:

vjefferni_0-1651132284795.png

and a Choice column which includes the same options as the choice question of the Form:

vjefferni_2-1651132415167.png

 

In the flow, I use the custom value from outputs of the get response details action:

vjefferni_3-1651132458563.png

vjefferni_4-1651132487981.png

 

I submitted the Form and got the new item inserted in the list correctly:

vjefferni_5-1651132551571.png

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Oatman2000
Regular Visitor

Thanks for this! It did work, however now in SharePoint it's showing as a decision pill but missing the color. 

When I click into it... I receive a color choice and it will fix, but I manually have to do this each time. 

 

2022-05-12_9-57-16.png

2022-05-12_9-57-43.png

Hi @Oatman2000 ,

 

The newly added custom values for choice column will be without color, it's by design in SharePoint list.

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Oatman2000
Regular Visitor

Medium is one of the 3 choices in the column. 

It's not like it's a type in field. 

 

When I go to investigate it in edit mode it changed over to the correct color. 

Feels like a bug.

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!

Users online (6,657)