Answered

Validate text input if it's exactly the same as in the backend

(0) Share

Report

Posted on by macsevet

I'm building a form, where the user has to choose an item from a drop down and then add it's price manually to a text field. If the price typed in is incorrect, then an error message should come up.

I am using a collection from an excel table as the backend for validation, I added the below to the error text label in question, but it's not working and I am not sure why.

Coalesce(
Parent.Error,
If(
!IsBlank(DataCardValue31.Value) &&
!IsMatch(DataCardValue31.Value, Dropdown4.Selected.'PO Price')
"Incorrect price"
)
)

DataCardValue31: the text label where the price needs to be typed in

Dropdown4: is the field where the price automatically gets filled in, once the user chooses the item from another drop down. This one is not visible, I just wanted to add it for the validation

'PO Price': the name of the column, that contains the correct price in the backend

Could someone please help me? Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @macsevet,

Could you try the following code:
Coalesce( Parent.Error, If( !IsBlank(DataCardValue31.Text) && //Should the condition below throw an error "cannot compare text to number" //replace DataCardValue31.Text with Value(DataCardValue31.Text) DataCardValue31.Text <> Dropdown4.Selected.'PO Price' "Incorrect price" ) )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
macsevet 35 on at

Like (0)

Report
Copy link

Link copied!
Thank you @LaurensM for the quick reply! Unfortunately this neither worked 😞
These errors came up:
Expected operator: we expect an operator, such as +, * or &
Unexpected characters: characters used in an unexpected way
Unexpected characters: contains "Eof" where "ParenClose" is required
Incompatible types for comparison (although I tried both methods you mentioned): Number, Error
Invalid number of arguments: received 1, expected 2 or more
Sorry I'm quite a beginner in this, so I don't really have a clue on how to move on 😞

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @macsevet,

My apologies, I should proofread my code more often - I missed a comma after Dropdown4.Selected.'PO Price':
Coalesce( Parent.Error, If( !IsBlank(DataCardValue31.Text) && //Should the condition below throw an error "cannot compare text to number" //replace DataCardValue31.Text with Value(DataCardValue31.Text) DataCardValue31.Text <> Dropdown4.Selected.'PO Price', "Incorrect price" ) )

I hope this helps!

Was this reply helpful? Yes No
macsevet 35 on at

Like (1)

Report
Copy link

Link copied!

OMG, it worked, thank you so much for your prompt help @LaurensM 🙂

Was this reply helpful? Yes No