Answered

Lookup and show choices using in EditForm for New

(0) Share

Report

Posted on by dylandavis09

442

Look up the Head Sponsor, Sponsor 1, and Sponsor 2 associated with the current user, then match them in the 'L-grade.' Afterward, look up the 'Class of 20XX Fundraising Items' to find the 'L-grade' and display the corresponding grade level based on the matched user.

Screenshot 2023-12-13 at 8.18.45 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi , @dylandavis09
Can you try to use this code :
LookUp('Class of 20XX Fundraising Items', 'L-Grade'.Value = LookUp( 'Class of 20XX (Officers)' , ('Head Sponsor'=User().FullName || 'Sponsor 1' = User().FullName || 'Sponsor 2'=User().FullName) ).'L-Grade'.Value)

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

Which one, we supposed to be in property? I just added in Defaults.

My name is already in the list and linked with L-Grade: (see below)

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi , @dylandavis09
Dose the control is a Combo box Control?
If this , you can put it in the DefaultSelectedItems :

LookUp('Class of 20XX Fundraising Items', 'L-Grade'.Value = LookUp( 'Class of 20XX (Officers)' , ('Head Sponsor'=User().FullName || 'Sponsor 1' = User().FullName || 'Sponsor 2'=User().FullName) ).'L-Grade'.Value).'L-Grade'

If the Control is a DropDown , you need put this code in the "Default" property:
LookUp('Class of 20XX Fundraising Items', 'L-Grade'.Value = LookUp( 'Class of 20XX (Officers)' , ('Head Sponsor'=User().FullName || 'Sponsor 1' = User().FullName || 'Sponsor 2'=User().FullName) ).'L-Grade'.Value).'L-Grade'.Value

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

Success! I put in theDefaultSelectedItems. It's worked.

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (0)

Report
Copy link

Link copied!

@v-yueyun-msft Few minutes, now it's not show anymore. 😞

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

Like (0)

Report
Copy link

Link copied!

Hi , @dylandavis09
What is your Form Mode in your side ?
You can try to use the NewForm(FormName) in your Button-OnSelect to test?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (1)

Report
Copy link

Link copied!

I just found it out and fixed, and worked again. I have same the datasource is 'Class of 20XX Officers' instead of 'Class of 20XX Fundraising Items'. 🙂

Was this reply helpful? Yes No