Answered

Automatic choice in a form

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I am now working on a form for my company. I am wondering is there a function that after the user type on the number in a box, other box will be automatically tick for the user. For example, in the attached image, after I type the number, the app will automatically determine whether the 'Thread Checking' is satisfactory or not according to the range I set. Thanks a lot.

Categories:

General Questions

form filling.JPG

I have the same question (0)

All responses (24)

Answers (1)

WarrenBelz 151,881 Most Valuable Professional on at

Like (0)

Report
Re: Automatic choice in a form

Hi @Anonymous ,

You did not say which box (drop-down?) needed to be populated or which were being compared (the two on the left with the one at right?), but the Default of the Drop-down (I assume it is not a combo box) would be something like

If( Value(YourThirdBox.Text) > Value(YourFirstBox.Text) && Value(YourThirdBox.Text) < Value(YourSecondBox.Text), "Satisfactory", "Whatever . . . ." )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Automatic choice in a form

Hi @WarrenBelz ，
Might I know where should I write the above code? Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Automatic choice in a form

Hi @WarrenBelz ,
Sorry for insufficient information given. I would like the RHS Thread to be in the range of 220-250 while LHS Thread within 300-350 so the thread checking will be satisfactory, otherwise, unsatisfactory.

Was this reply helpful? Yes No
WarrenBelz 151,881 Most Valuable Professional on at

Like (0)

Report
Re: Automatic choice in a form

Hi @Anonymous ,

Default of Drop-down (I assume it is not a combo box)

If( Value(YourRHSBox.Text) > =220 && Value(YourRHSBox.Text) <=250 && Value(YourLHSBox.Text) > =300 && Value(YourLHSBox.Text) <=350, "Satisfactory", "Unsatisfactory" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Automatic choice in a form

Hi @WarrenBelz ,
I typed in default but there is no response.

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Re: Automatic choice in a form

Hi @Anonymous ,

What is the Item property of Thread Checking Dropdown?

I assume it is not of Text and that is why you see error. Please hover on Error X to see the error message.

You could also click on App checker to see the error message as highlighted below -

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
WarrenBelz 151,881 Most Valuable Professional on at

Like (0)

Report

Re: Automatic choice in a form

@Anonymous ,

You are referring to the data card - you need to refer to the text box.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Automatic choice in a form

Hi @WarrenBelz @bipinshan ,
I just changed all three box's property to be Text, and referring to the text box. After I typed in the Default of the drop-down, and click to other area, and then click back, the things I type in default disappear.

Was this reply helpful? Yes No
WarrenBelz 151,881 Most Valuable Professional on at

Like (0)

Report
Re: Automatic choice in a form

@Anonymous ,

I am assuming the control is a drop-down (not a Combo Box as it needs DefaultSelectedItems). Make the Items of the Drop-down

["Satisfactory","Unsatisfactory"]

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Automatic choice in a form

Hi @WarrenBelz ,
I can not type in both Items and DefaultSelectedItems. After I typed, it will revert back to the original setting. I'm not sure if it is relevant but my form is connect to microsoft list.

Was this reply helpful? Yes No