Power Platform Community Forum Thread Details

i would like you to help me with this problem :

Set(foundUserRecord, LookUp ( Users, Username = TextInput1.Text && Password = TextInput1.Text )); If(!IsBlank(foundUserRecord), If( foundUserRecord.Level = "Admin", Navigate(Dashboard), If( foundUserRecord.Level = "Industrial Sv", Navigate(Dashboard), If( foundUserRecord.Level = "Academic Sv", Navigate(Dashboard), Navigate('Student Details') ) ) ); Notify("Invalid username or password"))

in this code it says "Incompatible types for comparison. These types can't be compared: Record, Text."

i have a table name users and a column name level. the column is a choice.

i want to do a login page that can make user insert their username and password. After login it will navigate to the certain page based on the level. can u help me its urgent. thankyou

WhatsApp Image 2024-02-15 at 01.19.01_9dfe167c.jpg

Categories:

Using connectors

Hi , @rosee08

You can try to use this code:
Set(foundUserRecord, LookUp ( Users, Username = TextInput1.Text && Password = TextInput1.Text )); If(!IsBlank(foundUserRecord), If( foundUserRecord.Level.Value = "Admin", Navigate(Dashboard), If( foundUserRecord.Level.Value = "Industrial Sv", Navigate(Dashboard), If( foundUserRecord.Level.Value = "Academic Sv", Navigate(Dashboard), Navigate('Student Details') ) ) ); Notify("Invalid username or password"))