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 (5)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(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 3,333 on at

Like
a
(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 155,840 Most Valuable Professional on at

Like
a
(1)

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
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @VO-16022037-0,

Just adding bit of optimized one (with WarrenBelz) avoiding Table:

ClearCollect( colValues, {Value: " "}, {Value: If(LookUp(TestResult, MaterialDoc = ThisItem.MaterialDoc, ddTestResult) = "PASS", "321", "CD")} )

This avoids Table() inside With and creates a collection directly.

Also, if you want a single string with empty space and the conditional value concatenated, you can do:

" " & ", " & If(LookUp(TestResult, MaterialDoc = ThisItem.MaterialDoc, ddTestResult) = "PASS", "321", "CD")

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VO-16022037-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

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