I have a sharepoint list with documents containing a employee clock and dept number. I have an app where the employee can add records. Before they click save to submit the new document I want to check to make sure that clock and dept is not already in the list. I was trying to use filter but must have issue with syntax
On the submit check mark I have this
if (countrows(filter('lyn overtime',clock = textinput1.text, 'dept no'.value = datacardvalue13.selected.value))=0,submitform(editform1))
I'll add the notify later if I can ever get this filter to work.
Hi, try the below
If (IsBlank(LookUp('lyn overtime', clock = textinput1.text && 'dept no'.value = datacardvalue13.selected.value)),SubmitForm(editform1),Notify( "Record already exists", NotificationType.Warning))
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.