Remove specific one value from Combo box

(0) Share

Report

Posted on by Sri

559

Hi All,

I have a form which list all the details from a SharePoint. I have a text input field which loads the selected Id from gallery. Based on gallery selected ID that respective details will be viewed in form. I have a field called Action on RPC which when selected only as duplicate a combo box will be loaded with all the RPC Id's from the SharePoint list. My requirement now is For eg. when the text input field has Id as 7(which will load from the gallery automatically when selected) the combo box should omit the selected Id and should list the other ID values. I am not sure how it can be done.. Any suggestions or help on this.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (2)

Verified answer

Akser 1,546 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Uthhra,

Let's say your selected ID is stored in a variable called 'varSelectedID'. In that case, the 'Items' property of your combo box would be:
Filter(DataSource, IsBlank(varSelectedID) Or ID <> varSelectedID)

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

Hi @Akser
My items property of combo box is:
'RPC - Request Form'.'RPC ID'

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
?
Filter('RPC - Request Form', IsBlank(varSelectedID) Or 'RPC ID' <> varSelectedID).'RPC ID'

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@Akser ,
It worked perfectly. Thank you so much. Can we add two field values to display in combo box. For eg ( Id -3 and description - new change). Can I display both in a combo box s (3 - new change)

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
Sure, that's why I did not refer to a specific column in my initial response.

AddColumns( Filter('RPC - Request Form', IsBlank(varSelectedID) Or 'RPC ID' <> varSelectedID), "SearchColumn", $"{'RPC ID'} - {Description}")

You need to make a couple changes in your combo box settings (E.g. Set the newly added 'SearchColumn' as your 'DisplayField' and 'SearchField').

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@Akser ,
I added the above code and I'm getting an error stating
unexpected character. the formula contains 'CurlyOpen' where 'ParenClose' is expected

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
AddColumns( Filter('RPC - Request Form', IsBlank(varSelectedID) Or 'RPC ID' <> varSelectedID), "SearchColumn", $"{'RPC ID'} - {Description}")

Was this reply helpful? Yes No
Sri 559 on at

Like (1)

Report
Copy link

Link copied!

@Akser ,
Thanks a lot. It worked perfectly.

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@Akser
Listing is happening in combo box but while submitting its not saving and showing a delegation warning.

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
Since the setup of your combo box changed, you should also adjust your Patch. For example, this is how you get the ID of the selected item on your combo box:
NameOfYourComboBox.Selected.'RPC ID'

Was this reply helpful? Yes No