DropDown Items

(1) Share

Report

Posted on by VO-16022037-0

hey,

I'm trying to do the items tab on my drop down with:

if my colselected (it's always just one item = 1 row) on the status column = "CD",

then the drop down only shows me options for ["CD"] (i also need a blank option).

if not, if the status = "Result", then look up on the list "TestResult", for that same code on the column MaterialDoc on the colselected and read off of the ddTestResult column within the list.

if the column = Pass, then my drop down only shows me options for ["321"] (i also need a blank). If "Fail", it shows me the same as before, ["CD"].

I was trying something like:

If(

!IsBlank(LookUp(colSelected, Status = "CD")),

[" ", "CD"],

LookUp(

TestResult,

MaterialDoc = ThisRecord.MaterialDoc,

ddTestResult

) = "PASS",

[" ","321"],

[" ","CD"]

)

it was giving me different errors. any idea what can be done?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Kalathiya 1,684 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @VO-16022037-0,

Assuming that you are using the form control inside have dropdown/combobox control.

Please try below code:
With( { resultStatus: LookUp( TestResult, MaterialDoc = selectedRecord.MaterialDoc, ddTestResult ) }, If( selectedRecord.Status = "CD", ["", "CD"], If( resultStatus = "PASS", ["", "321"], ["", "CD"] ) ) ) Note: // selectedRecord - Replace this with your selected record. Use a variable if you're storing the selection, or reference the relevant control (e.g., Dropdown1.Selected) if the value depends on another dropdown

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Suggested answer

11manish 847 on at

Like (0)

Report
Copy link

Link copied!

Try below :

With(
{
varStatus: First(colSelected).Status,
varMaterialDoc: First(colSelected).MaterialDoc,
varResult: LookUp(
TestResult,
MaterialDoc = First(colSelected).MaterialDoc,
ddTestResult
)
},
If(
varStatus = "CD",
["", "CD"],
varStatus = "Result" && varResult = "PASS",
["", "321"],
["", "CD"]
)
)

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @VO-16022037-0,

Posting in case any of the previous results do not work with a couple of suggestions.

Firstly, you only need one of two results, so why bother with any test on "CD". Also the Combo Boxes (and other Table controls) can be inconsistent when given dynamic multiple Items options, so this should work if your problems are here
With( { _Item: If( LookUp( TestResult, MaterialDoc = ThisItem.MaterialDoc, ddTestResult ) = "PASS", "321", "CD" ) }, Table( {Value: " "}, {Value: _Item} ) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No