Very Basic If Statement not working.

(0) Share

Report

Posted on by ShondaT

228

Can anyone give me an idea why this is rendering an error:

If(NCAForm_1.Mode = FormMode.New, User().Email, Parent.Default)

The other issue I'm having is that my gallery will not filter on the user which is part of the solution the above code is in.

I've set the variable onStart as required, but when I add the filter function to the gallery it returns no records. When I hover over the variable the message provided is "We didn't find any data."

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@ShondaT

Coalesce(Parent.Default, User().Email)

In New forms, Parent.Default is blank.

Activate Named Formulas in the settings and in App.Formulas

useremail = User().Email;

You can then filter your gallery with useremail.

Was this reply helpful? Yes No
ShondaT 228 on at

Like (0)

Report

@Drrickryp I'm so very sorry but I am not following what you're saying very well. This code appeared to work in one of Shane Young's videos. So I'm still at a complete loss. If you could explain further I'd really appreciate it.

Was this reply helpful? Yes No
NZ0090 317 on at

Like (0)

Report

@ShondaT Can you share what the error message is? Click on the x > Get help for this error

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

Like (0)

Report

@ShondaT

Coalesce() reads its elements from left to right until it finds a non blank one) in new forms Parent.Default is blank but otherwise it will have a value.

Was this reply helpful? Yes No