Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Data Validation

Posted on 26 Nov 2024 12:07:50 by
Hello,

Can you use Power Apps to validate user input against data in a database, i.e. if I ask for them to provide an email address, it must correspond to one we have in our database?
 
Thanks,
 
James
  • Suggested answer
    mmbr1606 Profile Picture
    mmbr1606 9,852 on 26 Nov 2024 at 12:37:38
    Data Validation
    hey
     
     
    yes u can do this for example with this:
    LookUp(DataSource, Email = TextInput1.Text)
    
    if you want to show a error message for example you can use:
    If(IsBlank(LookUp(DataSource, Email = TextInput1.Text)), "Email not found", "Email verified")
    
    if it was helpful please mark as verified answer
     
     
    cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard