Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Find Selected Check box and assign value

(0) ShareShare
ReportReport
Posted on by 2

Issue

Using AI Build to pick up a selection in a paper form across 5 fileds, you know a rating system 1 -5

AI builder is trained and works well picking up the selection. 

So the data extracted from the forms ok comes in as individual fields

for example: 

Question1_Strong_disagree : unselected

Question1_disagree  : unselected

Question1_ Neutral : selected

and so on (hopefully one selection only) 

 

Question

How can i find the selected option then apply a value on the selection.  Kinda of like like a count if for excel if strong_disagree= selected question1_mark = 1, if strong_agree selected question1_mark = 5 

 

Then i guess error handling if it finds 2 selected for one value? 

 

Any thoughts could be appreciated 

 

Paper forms example

 Strong Disagree DisagreeNeutral Agree Strong Agree
Question 1    X   
Question 2     x
      
      
  • simone.saunders Profile Picture
    2 on at
    Re: Find Selected Check box and assign value

    Moved a little forward if this helps. 

    I can get the values into an array 

    [
    "Question_1",
    {
    "1": ":unselected:",
    "2": ":unselected:",
    "3": ":unselected:",
    "4": ":unselected:",
    "5": ":selected:"
    }
    ]
     
    I can use the select  action to find selected value, however it doesn't give me the number.  Is there away i can get that as well? 

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!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,017 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow