Answered

Sharepoint Column as Dropdown

(0) Share

Report

Posted on by Harika_1

I have dropdown hardcoded with the values with Q1 , Q2, Q3 in the power apps drop down
In the SharePoint I have Agile and sigma and gamma have values 0,1,2 for all the (Q1 , Q2, Q3)
for more understanding refer the images attached
Now, In the power apps based on Job code selected the agile sigma and gamma should show the values correspondingly
if i select the Job Code Q1 Agile gamma and sigma should show 1,2,0 and so on.

Please help me with this.
Thank You.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

timl 37,262 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Harika_1

The formula you would use for the "Agile" text input control would look like this:

Switch( cboJobCode.Selected.Value, "Q1", LookUp(SharePointList, c_name="Agile").Q1, "Q2", LookUp(SharePointList, c_name="Agile").Q2, "Q3", LookUp(SharePointList, c_name="Agile").Q3 )

For sigma and gamma, you would adapt the above the formula to reference sigma or gamma.

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

if i select the Job Code Q1 Agile gamma and sigma should show 1,2,0 or 1,2,2

Was this reply helpful? Yes No
Harika_1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @developerAJ , It should Show 1,2,2
Sorry My bad!
and Also instead of hardcoding values as Q1,Q2,Q3 in the dropdown is there a way to pull them from the Sp List?
@timl @developerAJ

Was this reply helpful? Yes No
Verified answer

developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

You need to change sharepoint
cname column values: q1,q2,q3
columnnames: Agile sigma gamma
that should be your design

Was this reply helpful? Yes No
Harika_1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a million, It worked !!!

Thanks again for the quick replies and helping the community grow🙏

Was this reply helpful? Yes No