cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nealhicks1
Helper III
Helper III

Connected Form to Planner using Power Automate - Need help formatting multiple choice output

Hi everyone,

 

I've connected a Form to Planner using a Power Automate flow, and I've successfully been able to pull information from the Form and create a new Planner task.

 

What I am having trouble figuring out is how to apply text formatting to the outputted results. For example, one of the answers to the Form have multiple selectable choices, and if all of them are selected, the output in the task created in Planner looks like this:


["Choice 1","Choice 2","Choice 3","Choice 4"]

 

What is the best way to implement formatting that will make it look like this:

 

Choice 1

Choice 2

Choice 3

Choice 4

 

Thanks so much in advance!

18 REPLIES 18
eric-cheng
Solution Sage
Solution Sage

Hi @nealhicks1 ,

 

Try the below.  In the Join with, just push the ENTER key once.

ericcheng_1-1628126938899.png

 

ericcheng_0-1628126918161.png

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

nealhicks1
Helper III
Helper III

Hmm, apologies, I am not sure where to try adding that Join segment.

 

Let me paste in the structure of my flow, just for reference (and clarity):

 

nealhicks1_0-1628128955569.png

 

And to expand on each section:

 

nealhicks1_1-1628129086015.png

 

nealhicks1_2-1628129146792.png

nealhicks1_3-1628129323706.png

And the above "Areas" is an example of an area with multiple selectable choices, that return as:

["Choice 1","Choice 2","Choice 3","Choice 4"]

 

Please let me know if anything needs further clarification, and thanks so much again!

Hi @nealhicks1 ,

 

Add the Select action before your Create Planner task action.

 

In the From field, pass your multi select Forms field 

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

nealhicks1
Helper III
Helper III

Hi @eric-cheng,

 

Thanks for the idea!

 

Here is what I did:

nealhicks1_0-1628181643118.png

 

Here are the options I have for the first 'Enter key' field:

nealhicks1_1-1628181679140.png

Do you know what needs to go in the two Map fields?

 

Thanks again!

eric-cheng
Solution Sage
Solution Sage

Hi @nealhicks1 

 

Sorry, please remove the Select and add the Join.  Not sure why I said Select lol.  Please refer to my screenshot.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

nealhicks1
Helper III
Helper III

Hi @eric-cheng,

 

Ah, I see! Thanks for the clarification.

 

Here's what happened:

nealhicks1_1-1628210220799.png

 

I referenced your screenshot and saw that your 'Join with' field was blank, but mine is requiring input. Any thoughts on what needs to go there?

 

Thank you so much, I really appreciate all your help with this! 🙂

eric-cheng
Solution Sage
Solution Sage

Hi @nealhicks1 ,

 

Click on the field and hit the enter key once.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Hi @eric-cheng,

 

Unfortunately, all that does is this:

nealhicks1_0-1628269910124.png

 

It just inputs a line break.

 

Any other thoughts?

eric-cheng
Solution Sage
Solution Sage

Hi @nealhicks1 ,

 

It should still display the red asterisk. You can save and run the flow.

 

Screenshot_20210807-121519_Chrome.jpg

 

Screenshot_20210807-121609_Chrome.jpg

 

Screenshot_20210807-121234_Chrome.jpg

 --------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Hi @eric-cheng,

 

Ah, I was able to save it, but I am still seeing the output as:

["Choice 1","Choice 2","Choice 3","Choice 4"]

 

Not sure what I am missing here. Sorry for the trouble.

 

eric-cheng
Solution Sage
Solution Sage

Hi @nealhicks1 ,

 

Can you post the run history and expand your Join action, similar to my screenshot.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Hi @eric-cheng,

 

Here is the run history, let me know if you need to see specific segments:

nealhicks1_0-1628345124990.png

 

And here is the Join section:

nealhicks1_1-1628345151655.png

And the Compose:

nealhicks1_2-1628345166290.png

 

I'm happy to share any additional details that are needed, please let me know!

Hi @nealhicks1 ,

 

Can you explain clearly what you are trying to do.

 

Your opening post asks about how to format the multi choice array to a line separated list.

 

Sharepoint

 

Screenshot_20210808-114711_Chrome.jpg

Planner

Screenshot_20210808-115656_Teams.jpg

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

nealhicks1
Helper III
Helper III

Hi @eric-cheng,

 

Certainly, let me try explaining this a bit better, and sorry for the confusion.

 

Here is my flow in its current, functional form:

nealhicks1_0-1628464175783.png

 

And to break down in more detail:

nealhicks1_1-1628464448226.png

 

nealhicks1_2-1628464500694.png

nealhicks1_3-1628464589406.png

nealhicks1_4-1628464680101.png

 

So the Areas and Support Type are both dynamic content types that receive input from a MS Form.

 

Each of those on the form have four possible selectable options. For Areas, the four possible choices are:

 

nealhicks1_5-1628465191860.png

 

The problem is that in the Planner task, the data comes in looking like:

nealhicks1_6-1628465269065.png

 

What do I need to do to make sure the data comes in looking like:

 

Areas:
Rapid Cycle Improvement

Comprehensive Process Improvement

Improvement of Transformed Process

Automation Effort

 

Thank you so much and let me know if this needs more clarification!

 

 

Just wanted to check in, any thoughts on this? Many thanks!!

eric-cheng
Solution Sage
Solution Sage

Hi @nealhicks1 ,

 

In your planner task, are you referencing the output of your Join action or are you still referencing the original Forms response?  You need to remove the reference I highlighted in red and specify the output of Join.

 

ericcheng_0-1628648310367.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

nealhicks1
Helper III
Helper III

Hi @eric-cheng,

 

Ah yes, apologies, I was referencing the wrong output. I changed it to the output of Join, but now the problem is that no matter whether a single option or all options are selected, it always outputs all four options in the task item. I need a way for it to parse the Form Areas output and only output the options that are selected, instead of all four options. Is there a way to add that logic to the process? I'm trying a few things but so far haven't been successful.

 

Thanks so much!

nealhicks1
Helper III
Helper III

Just checking in again, if anyone has any thoughts on how to make the above happen. Really do appreciate everyone's time.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,064)