Answered

Navigate to a screen based on Len & LookUp of TextInput

(0) Share

Report

Posted on by officeadmingsf

I want to first check is TextInput2 has Len = 1. If so, I want to check if the value exists in Table1 using a LookUp function. If not, I want to navigate the user to a new screen and reset the form. the line of code would look something like this, I just don't know where to put it / how to implement it.

If(Len(TextInput2) = 1, If(LookUp(Table1, RFID = TextInput2.Text).Email = Blank(), And(Navigate('New User Screen'), ResetForm(EditForm1))))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

cds 1,001 on at

Like
a
(1)

Report
Copy link

Link copied!

put it on OnChange of the textinput

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @officeadmingsf

Another option is, Have this logic in the selection of the gallery itself. So that the user will redirect either edit screen or New mode directly if a business wants.

Example

But if you want the logic in the edit screen then as @cds mentioned we can do onchange event

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Verified answer

officeadmingsf 37 on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up creating a button that had Visibility settings of If(Len(TextInput2.Text) = 1, If(LookUp(Table1, RFID = TextInput2.Text).Email = Blank(),true, false), false) and OnSelect of Navigate('New User Screen'); ResetForm(EditForm1). But thank you for your suggestions!

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @officeadmingsf,

Glad that you have sloved your issue by adding a button.

You can mark your reply as a solution. This will benefit other community members who stuck with the same question.

Best regards,

Allen

Was this reply helpful? Yes No