If(Lookup(....)&If(Lookup(...)

(0) Share

Report

Posted on by dylandavis09

438

Something like this working for functions? Please just use Text property instead of OnVisible property. Thank you!

LookUp('DHS Students Users','Student Name' = User().FullName, 'L-Grade'.Value)&LookUp('Class of 20XX (Officers)', 'Student Name' = User().FullName, 'L-Grade'.Value)

Screenshot 2023-11-06 153902.png

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @dylandavis09 ,

Please try this:

In the first method, look up record through 'L-Grade' column.
Label1_109:LookUp('Class of 20XX (Officers)','L-Grade'.Value=LookUp('DHS Students Users','Student Name' = User().FullName, 'L-Grade'.Value),'Class of 20XX Groups') Label3_37:LookUp('Class of 20XX (Officers)','L-Grade'.Value=LookUp('DHS Students Users','Student Name' = User().FullName, 'L-Grade'.Value),'Head Sponsor')
In the second method, look up record through the name of the logged-in user.
Label1_109:LookUp('Class of 20XX (Officers)','Head Sponsor'=Upper(User().FullName),'Class of 20XX Groups') Label3_37:LookUp('Class of 20XX (Officers)','Head Sponsor'=Upper(User().FullName),'Head Sponsor')

Thanks for reading!
Rimmon

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-mengmli-msft, thank you for sending this. This is SOLVED about which functions to put in the label. 😊

I did put the "Label1_109" is worked with function.
LookUp('Class of 20XX (Officers)','L-Grade'.Value=LookUp('DHS Students Users','Student Name' = User().FullName, 'L-Grade'.Value),'Class of 20XX Groups')

Then I did put the "Label3_37" is worked with function.
LookUp('Class of 20XX (Officers)','L-Grade'.Value=LookUp('DHS Students Users','Student Name' = User().FullName, 'L-Grade'.Value),'Head Sponsor')

SharePoint List:

Thank you,
Dylan Davis

Was this reply helpful? Yes No