cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tduncan1
Level: Powered On

Data validation before writing to excel

What would be the best method in validating data from an excel sspreadsheet through power apps?

5 REPLIES 5
Super User
Super User

Re: Data validation before writing to excel

Try this video: PowerApps Conditional Formatting and Popups

 

I show you how to use IsMatch() function to do some validation and how to pop up warning text if they get things wrong.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
tduncan1
Level: Powered On

Re: Data validation before writing to excel

Thank you.

 Does the IsMatch or Match Function go through the table to verify if the input already exist?

Super User
Super User

Re: Data validation before writing to excel

Nope. In that case I would create some logic that does a Lookup in the table for the new value. If your lookup comes back IsEmpty then you know you are all set.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
tduncan1
Level: Powered On

Re: Data validation before writing to excel

Could send an example?

Highlighted
Super User
Super User

Re: Data validation before writing to excel

I am too kind. Smiley Tongue 

 

If(IsEmpty(LookUp(DataSourceToCheck, ColumnToCheck = TextInput1.Text)),"It doesn't exist","It does exist")

 

Does that help? Smiley Happy 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 205 members 4,940 guests
Please welcome our newest community members: