Unanswered

IF Blank use my lookup Syntax help.

(0) Share

Report

Posted on by juliowastaken

I am trying to make it where if Visit Type is blank... use the Amount column... to my Total Amount... if Visit Type has a value... use Visit Type Amount for my Total Amount column. I am having a hard time trying to get this to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Gochix 1,935 Moderator on at

Like (1)

Report
@juliowastaken ,
Not sure why you are having a hard time to get this working if you are half way through. Just add another LookUp() function.
If( IsBlank(LookUp('Stipend Amount','Study' = dpSPSelectStudy.Selected.Study,Amount)), LookUp('Stipend Amount', 'Visit Type' = PSVisitType.Selected.Value, 'Visit Type Amount'), LookUp('Stipend Amount', 'Visit Type' = PSVisitType.Selected.Value, 'Amount') )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
juliowastaken 75 on at

Like (0)

Report

This seems to somewhat be working... Now I can see the Total Amount if Visit Type is selected, but when nothing is selected it doesn't show the Amount in Total Amount.

Was this reply helpful? Yes No
Verified answer

Gochix 1,935 Moderator on at

Like (1)

Report
@juliowastaken ,
try this:
If( IsBlank( PSVisitType.Selected.Value), LookUp('Stipend Amount','Study' = dpSPSelectStudy.Selected.Study,Amount), If( !IsBlank( LookUp('Stipend Amount', 'Visit Type' = PSVisitType.Selected.Value, 'Visit Type Amount')), LookUp('Stipend Amount', 'Visit Type' = PSVisitType.Selected.Value, 'Visit Type Amount'), LookUp('Stipend Amount', 'Visit Type' = PSVisitType.Selected.Value, 'Amount') ) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
juliowastaken 75 on at

Like (0)

Report

Thank you!!!!! I really appreciate it. 🤝

Was this reply helpful? Yes No