Hi,
Can someone help me, i have a powerapp form text input which when submitted falls nicely in database A. This input needs to be compared with a measurement criteria database b item.
In short there are three problem i'm facing
1) upon submit the system should calculate if the user input is lesser than database B item then reveal a radio selection and set it to fail and display a label sentence "u passed please go next item" . At the same time it will set checkbox in diagram to weld repair.
2) if the input is greater than database B we are supposed to toggle to (pass) button and reveal a another set of toggle button.
3) last toggle question should reveal a sentence with a calculation field under skim cut value where user input minus database b divide 2.
I got some screenshots here to show you what i actually wanted.
Solved! Go to Solution.
Hi @nchandran ,
Do you want to compare the user input (Line Item 1 Text Box) with the ACLineitem1 column in your data base B (a SP List)?
Is there only one record existed in your data base B?
Based on the issue that you mentioned, I think If function could achieve your needs. Please take a try with the following workaround:
Set the OnSelect property of the "Submit" button to following:
Set(
SubmittedLineItem1,
Patch('Your Database A', Defaults('Your Database A'), {LineItem1Column: Value('Line Item 1'.Text)})
)
Note: The LineItem1Column represents the number column in your database A, which used to store the Line Item 1 text box (User Input).
Set the Default property of the Radio control to following:
If( !IsBlank(SubmittedLineItem1) && SubmittedLineItem1.LineItem1Column < First('Your database B').ACLineitem1, "Fail", !IsBlank(SubmittedLineItem1) && SubmittedLineItem1.LineItem1Column > First('Your database B').ACLineitem1, "Pass" )
Add a Label (Label1), set the Text property to following:
"u passed please go next item"
set the Visible property to following:
If(Radio1.Selected.Value = "Fail", true, false)
Set the Default property of the "Weld Repair + machine" Checkbox to following:
If(
Radio1.Selected.Value = "Fail", true,
Radio1.Selected.Value = "Pass", false
)
Set the Default property of the "Skimcut" Checkbox to following:
If( Radio1.Selected.Value = "Pass", true, Radio1.Selected.Value = "Fail", false )
Add aother Label (Label2) under the "Skimcut" Checkbox, set the Text property to following:
"The calculation value is " & SubmittedLineItem1.LineItem1Column - First('Your database B').ACLineitem1/2
set the Visible property of the Label2 to following:
If( Radio1.Selected.Value = "Pass",
true,
false )
Please take a try with above solution, check if the issue is solved.
Best regards,
Hi @nchandran ,
Do you want to compare the user input (Line Item 1 Text Box) with the ACLineitem1 column in your data base B (a SP List)?
Is there only one record existed in your data base B?
Based on the issue that you mentioned, I think If function could achieve your needs. Please take a try with the following workaround:
Set the OnSelect property of the "Submit" button to following:
Set(
SubmittedLineItem1,
Patch('Your Database A', Defaults('Your Database A'), {LineItem1Column: Value('Line Item 1'.Text)})
)
Note: The LineItem1Column represents the number column in your database A, which used to store the Line Item 1 text box (User Input).
Set the Default property of the Radio control to following:
If( !IsBlank(SubmittedLineItem1) && SubmittedLineItem1.LineItem1Column < First('Your database B').ACLineitem1, "Fail", !IsBlank(SubmittedLineItem1) && SubmittedLineItem1.LineItem1Column > First('Your database B').ACLineitem1, "Pass" )
Add a Label (Label1), set the Text property to following:
"u passed please go next item"
set the Visible property to following:
If(Radio1.Selected.Value = "Fail", true, false)
Set the Default property of the "Weld Repair + machine" Checkbox to following:
If(
Radio1.Selected.Value = "Fail", true,
Radio1.Selected.Value = "Pass", false
)
Set the Default property of the "Skimcut" Checkbox to following:
If( Radio1.Selected.Value = "Pass", true, Radio1.Selected.Value = "Fail", false )
Add aother Label (Label2) under the "Skimcut" Checkbox, set the Text property to following:
"The calculation value is " & SubmittedLineItem1.LineItem1Column - First('Your database B').ACLineitem1/2
set the Visible property of the Label2 to following:
If( Radio1.Selected.Value = "Pass",
true,
false )
Please take a try with above solution, check if the issue is solved.
Best regards,
Thank you kris.
@v-xida-msft wrote:Hi @nchandran ,
Do you want to compare the user input (Line Item 1 Text Box) with the ACLineitem1 column in your data base B (a SP List)?
Is there only one record existed in your data base B?
Based on the issue that you mentioned, I think If function could achieve your needs. Please take a try with the following workaround:
Set the OnSelect property of the "Submit" button to following:
Set(
SubmittedLineItem1,
Patch('Your Database A', Defaults('Your Database A'), {LineItem1Column: Value('Line Item 1'.Text)})
)Note: The LineItem1Column represents the number column in your database A, which used to store the Line Item 1 text box (User Input).
Set the Default property of the Radio control to following:
If( !IsBlank(SubmittedLineItem1) && SubmittedLineItem1.LineItem1Column < First('Your database B').ACLineitem1, "Fail", !IsBlank(SubmittedLineItem1) && SubmittedLineItem1.LineItem1Column > First('Your database B').ACLineitem1, "Pass" )Add a Label (Label1), set the Text property to following:
"u passed please go next item"set the Visible property to following:
If(Radio1.Selected.Value = "Fail", true, false)Set the Default property of the "Weld Repair + machine" Checkbox to following:
If(
Radio1.Selected.Value = "Fail", true,
Radio1.Selected.Value = "Pass", false
)Set the Default property of the "Skimcut" Checkbox to following:
If( Radio1.Selected.Value = "Pass", true, Radio1.Selected.Value = "Fail", false )
Add aother Label (Label2) under the "Skimcut" Checkbox, set the Text property to following:
"The calculation value is " & SubmittedLineItem1.LineItem1Column - First('Your database B').ACLineitem1/2set the Visible property of the Label2 to following:
If( Radio1.Selected.Value = "Pass",
true,
false )Please take a try with above solution, check if the issue is solved.
Best regards,
User | Count |
---|---|
184 | |
122 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
130 | |
85 | |
78 |