Greetings,
Microsoft keeps changing the way Power Automate works. Methods I used in the past to do a certain thing no long work. I try to look up the new method to do something online and I'm swamped with a bevy of OLD ways to do things that no longer work because the tools work differently. So, I'm coming here for a live discussion on the matter.
What I'm doing is submitting a Microsoft Forms form. Then Power Automating the data to a SharePoint list. I have some questions that are of the choice type with one possible answer, and they automate to S.P. just fine. The snag is when on another choice question it allows multiple choices. Of course, if multiple items are selected that creates an array. However, if only 1 item is selected then the result is a string.
In the past I had utilized compose with JSON and then used select to select that data, written to the Value of the compose Output. But that doesn't want to work now. I've tried various methods I've seen online, all to no avail. Here is my flow edit. I'm trying to get "Area Supported" into the SP List.
The MS Form question for Area Supported is marked as choice with multiple answers possible. The SP column for it is marked as a choice column as well.
When I run the flow with various methods I've gotten an answer of "Operations Support", or "[\"Operations Support\"]", or "Operations Support\"]", or, or, or but I can't get it to have just Operations Support in the S.P. List, or Operations Support, plus anything else selected.
Can someone please illuminate me regarding Microsoft's way to do this THIS week?
It would be greatly appreciated and eliminate lots of frustration.
Here's the pertinent body of my flow:
Thanks,
Scott
Thanks for the suggestion, I wasn't thinking about marking it as the solution. I was just leaving a note so others didn't waste their time solving the issue.
Marking it as resolved would do a better job of not wasting others time than just leaving a note on the post! It would take it off the "to do board" entirely. Good call. I'll use that going forward. Although I'll still post any resolutions I find for others to use as well.
Best regards,
Scott
Hi @mcgeeks ,
Glad to see you solved the issue.
Please consider marking your own reply as the solution.
Best Regards,
Wearsky
Never mind all. I was able to get a "Fresh" way of doing this by typing 2024 before my search to get newer answers! Whoop!
My kudos to Reza Dorrani who has been an excellent resource for various things with all his posted videos!
The answer starts at 11:39 in this video! Power Automate Microsoft Forms Connector tutorial with Attachments - YouTube
It regards getting "Microsoft Forms" multiple answers, from a multiple-choice question, into a SharePoint list appropriately.
WarrenBelz
146,765
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional