Answered

return custom error if matching record not found in Sharepoint list

(0) Share

Report

Posted on by loha

I have a sharepoint list which contains the ID field and an email field. I want to search the sharepoint list for the ID and check that the email address matches before writing back todays date and time into another field.

this is what I have so far:

Patch('MySharePointList', LookUp('MySharePointList', ID = txt_SignOutID.Text And 'Email Address' = txt_SignOUTEmail.Text & MatchOptions.IgnoreCase),{'EXIT Date and Time': Now()});

Navigate(SplashScreen,ScreenTransition.Fade)

I want to notify the app user if the ID and email do not match and allow them to try again rather than navigating back to the splashscreen. Could someone help with how I can do this? @WarrenBelz maybe?

thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

@loha ,
You could use an If(!IsBlank() to make sure a record exists on your lookup. (! Works as not)
If(!IsBlank(LookUp('MySharePointList', ID = txt_SignOutID.Text And 'Email Address' = txt_SignOUTEmail.Text & MatchOptions.IgnoreCase)),
Patch('MySharePointList', LookUp('MySharePointList', ID = txt_SignOutID.Text And 'Email Address' = txt_SignOUTEmail.Text & MatchOptions.IgnoreCase),{'EXIT Date and Time': Now()}) And
Navigate(SplashScreen,ScreenTransition.Fade))

Was this reply helpful? Yes No
loha 53 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply! I have tried to implement this and I'm getting an invalid argument type error on the Patch:

Was this reply helpful? Yes No
loha 53 on at

Like (0)

Report
Copy link

Link copied!

Got rid of the error, but now it doesn't update the SP List with the current date and time when the ID and email matches:

Was this reply helpful? Yes No
Verified answer

turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

@loha ,
Try putting this notify in place of your patch and lets make sure we are getting a record.
Notify("success")

Was this reply helpful? Yes No
loha 53 on at

Like (1)

Report
Copy link

Link copied!

Thank you - this notify helped me troubleshoot the code! So when i put the notify code in place of the patch, it didn't return anything. I tried removing the matchcase.ignore and its working now! I've no idea why, but I'll play around with the matchcase as I need it.

thanks for all your help, it's very much appreciated 🙂

Was this reply helpful? Yes No