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
