cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gazzo1967
Level 8

Populate text input based on answers to Question Answers

Hi All

I have something i would like to do on my App

I have 10 choices questions with the answer selection from

Development

Minor Development

Safety Critical

 

I would like to populate a textinput with

If answers selected as 'Minor Development' are 3 or more of the 10 questions then the textinputfield would populate as 'Failed Assessment'

Or if just 1 or more answers from the 10 questions are selected as 'Safety Critical' the textinput would populate as 'Failed Assessment'

 

Else the textinput would populate as  'Assessment Passed'

 

I'm new to this but in trying to understand formula logic but this one is beyond me!

I would assume i need to use IF statement on the textinput value

 

Gary

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Populate text input based on answers to Question Answers

@gazzo1967 

Gary,

I wasn't entirely sure from your post if you have individual controls for each question and if they were dropdowns, or if you had a Gallery of questions with dropdowns...or just what!

 

So, it seemed easier to throw together a sample app with some options for you.

In this app, there are the separate controls way (left in app) and the Gallery way (right in app).

Take a look and see if this helps you with your formulas.

 

I hope it helps out and let me know if there are questions.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Populate text input based on answers to Question Answers

@gazzo1967 

Gary,

I wasn't entirely sure from your post if you have individual controls for each question and if they were dropdowns, or if you had a Gallery of questions with dropdowns...or just what!

 

So, it seemed easier to throw together a sample app with some options for you.

In this app, there are the separate controls way (left in app) and the Gallery way (right in app).

Take a look and see if this helps you with your formulas.

 

I hope it helps out and let me know if there are questions.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

gazzo1967
Level 8

Re: Populate text input based on answers to Question Answers

Hi @RandyHayes 

Thank you for replying.

I can see the logic of your examples and like them Man Happy

Thank you for the help Smiley Very Happy

Gary

 

Super User
Super User

Re: Populate text input based on answers to Question Answers

@gazzo1967 

Gary, no worries, it will still work the same way.  The formula doesn't really care about the source of the dropdown lists, only the values in them.  So the solution should still work for you.

But, if you're stuck on anything in particular, just post back and I'll have at it.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,281)