I'm really new to Power Apps and looking for advice.
I'd like my app to start/navigate directly to a form in either edit or new mode, depending on if the users().email exists in the datasource (SP list). The contents of Item is set to display under the following condition:
LookUp(
'Phone Number Assignments',
'Employee Email Address'.Email = varUser
)
varUser is set as User().Email in the OnStart of the app
Currently, if Lookup is returned blank, the form simply says 'No item to display'. When the Lookup is not blank, it displays the Form. I have tried changing the FormMode to Edit or New depending, but not having any success. I'm not sure where is best to include the code to accomplish this. HOw do you go about doing this?
