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!
Hi @nealhicks1 ,
Try the below. In the Join with, just push 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
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):
And to expand on each section:
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
Hi @eric-cheng,
Thanks for the idea!
Here is what I did:
Here are the options I have for the first 'Enter key' field:
Do you know what needs to go in the two Map fields?
Thanks again!
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
Hi @eric-cheng,
Ah, I see! Thanks for the clarification.
Here's what happened:
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! 🙂
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:
It just inputs a line break.
Any other thoughts?
Hi @nealhicks1 ,
It should still display the red asterisk. You can save and run the flow.
--------------------------------------------------------------------------
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.
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:
And here is the Join section:
And the Compose:
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
Planner
--------------------------------------------------------------------------
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,
Certainly, let me try explaining this a bit better, and sorry for the confusion.
Here is my flow in its current, functional form:
And to break down in more detail:
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:
The problem is that in the Planner task, the data comes in looking like:
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!!
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.
--------------------------------------------------------------------------
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 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!
Just checking in again, if anyone has any thoughts on how to make the above happen. Really do appreciate everyone's time.