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:

Connecting to Data

Using Apps Using Formulas

Connectors

All responses (5)

Answers (2)

Harika_1 on at

Like (0)

Report

Re: Sharepoint Column as Dropdown

Thanks a million, It worked !!!

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

developerAJ 2,855 on at

Like (0)

Report

Re: Sharepoint Column as Dropdown

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

Like (0)

Report

Re: Sharepoint Column as Dropdown

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
developerAJ 2,855 on at

Like (0)

Report

Re: Sharepoint Column as Dropdown

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

timl 34,933 Super User 2025 Season 1 on at

Like (0)

Report
Re: Sharepoint Column as Dropdown

@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.