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,
