Unanswered

Cascading Dropdowns choices retrieve a Text Column Value

(0) Share

Report

Posted on by criscles

I have a SPO List containing 4 columns. 3 are Choice columns and one is a Single Line of Text column as below

Portfolio (Choice)	Program (Choice)	Role (Choice)	RoleCode (Text)
Corporate Services	Human Resources	Employee	CSHREMP
Corporate Services	Human Resources	Manager	CSHRMGR
Corporate Services	Information Management	Employee	CSIMEMP

In my App I have 3 cascading dropdowns to select a Portfolio (ddPortfolio), then Program (filtered on Portfolio - ddProgram), then Role (filtered on Program - ddRole). My cascading options are working fine.

I would like a label in the app to display the corresponding RoleCode based on the dropdown choices. I am at a loss to figure out how to go about this as I cannot use the Selected.Value of the ddRole given the result resolves as something that exists multiple times in the list (i.e. "Employee"). Am being too ambitious ?

Thankyou in advance.

Anthony

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Consider this:

LookUp(Datasource,Role = ddRole.Selected.Value,RoleCode )

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
criscles 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Datasource,Role and RoleCode are incompatible types as Role is Choice (Record) column and RoleCode is Text.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please what formula do you have on the dropdown?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
criscles 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24
In my Portfolio dropdown (ddPortfolio) - Items > Choices('Network-Access-Profile-Roles'.Portfolio)

In my Program dropdown (ddProgram) - Items > Filter(Choices('Network-Access-Profile-Roles'.Program), Value in Filter(AddColumns('Network-Access-Profile-Roles',"R1",Program.Value),Portfolio.Value=ddPortfolio.Selected.Value).R1)

In my Role dropdown (ddRole) - Items > Filter(Choices('Network-Access-Profile-Roles'.Role), Value in Filter(AddColumns('Network-Access-Profile-Roles',"R2",Role.Value),Program.Value=ddProgram.Selected.Value).R2)

Appreciate your assistance. Thanks