Skip to main content

Notifications

Community site session details

Community site session details

Session Id : qnGpNcu8fKAoLc40FNrj+K
Power Automate - Building Flows
Answered

The ever changing ways Power Automate will work...

Like (0) ShareShare
ReportReport
Posted on 20 May 2024 18:00:01 by 27

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.

 

mcgeeks_0-1716226921988.png

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:

 

mcgeeks_2-1716227783488.png

 

 

Thanks,

Scott

  • SM-15101351-0 Profile Picture
    27 on 21 May 2024 at 13:49:12
    Re: The ever changing ways Power Automate will work...

    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

  • v-xiaochen-msft Profile Picture
    on 21 May 2024 at 03:16:30
    Re: The ever changing ways Power Automate will work...

    Hi @mcgeeks ,

     

    Glad to see you solved the issue.

    Please consider marking your own reply as the solution.

     

    Best Regards,

    Wearsky

  • Verified answer
    SM-15101351-0 Profile Picture
    27 on 20 May 2024 at 18:33:34
    Re: The ever changing ways Power Automate will work...

    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.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,765 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard