My combo box control bring additional row - How to control

(0) Share

Report

Posted on by MIA27

I am using Teams power app.

I have a combo control, whose properties are as below:

Default selected item :

If(gblReturnNewRecord,LookUp(PartsReturnStatus, ReturnStatus = "INITIAL"),LookUp(PartsReturnStatus, ReturnStatus = SearchResultGallery_3.Selected.'Status (cr333_status)'))

Items:

PartsReturnStatus

(the above is my collection name)

For new entry it is ok. It gives me 3 row to select.

But while selection during the already saved old records shows me to select as below, it should not repeat as shown (InProgress showing twice

Please guide how to control it to

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,042 Most Valuable Professional on at

Like (0)

Report

@MIA27 ,

That is not a repeat - the top item is what you have selected and the bottom panel is all the available selections.

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

You mean, What Is selected is going at the bottom, which is normal way of combo box.

Got Confused, as my My ClearCollect code and the sequence of the data to populate is as below:
ClearCollect(
PartsReturnStatus,
{ReturnStatus: "INITIAL"},
{ReturnStatus: "IN-PROGRESS"},
{ReturnStatus: "COMPLETED"}
);

Therefore, as image shows the selection is going at the last,
So, what ever out of this 3 I select, will show at the bottom.

BUT the strange this is that some time it is happening, during the above type I tested again and found it shows below, then how come it is normal, as it shows not repeated, its shows what data is available is selected /highlighted :

Please guide if I am understanding correct.

Was this reply helpful? Yes No
WarrenBelz 153,042 Most Valuable Professional on at

Like (0)

Report

@MIA27 ,

OK - I see it now - I think you need to look at the content of your PartsReturnStatus collection

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

As I mentioned in my earlier post below is the collection which I am using. Also please note in my first post how I am using the Item and defaultSelectedItems :
ClearCollect(
  PartsReturnStatus,
  {ReturnStatus: "INITIAL"},
  {ReturnStatus: "IN-PROGRESS"},
  {ReturnStatus: "COMPLETED"}
);

Do you think, it need to be corrected.

Was this reply helpful? Yes No
WarrenBelz 153,042 Most Valuable Professional on at

Like (0)

Report

@MIA27 ,

Why are you using it for the DefaultSelectedItems ? You do not need to do this.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Sorry I created the confusion, I will clarify in details:
The property are as below :

On Screen visible property, the collection code is there:
ClearCollect(
  PartsReturnStatus,
  {ReturnStatus: "INITIAL"},
  {ReturnStatus: "IN-PROGRESS"},
  {ReturnStatus: "COMPLETED"}
);

On Default selected item Property below code is there:
If(gblReturnNewRecord,LookUp(PartsReturnStatus, ReturnStatus = "INITIAL"),LookUp(PartsReturnStatus, ReturnStatus = SearchResultGallery_3.Selected.'Status (cr333_status)'))

On Items property below code is there(which is collection name):
PartsReturnStatus

And you can refer to my both images which I pasted in my earlier post.
Kindly advise.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,042 Most Valuable Professional on at

Like (1)

Report
@MIA27 ,

If this is the Items, how can there be a duplicate ?

ClearCollect( PartsReturnStatus, {ReturnStatus: "INITIAL"}, {ReturnStatus: "IN-PROGRESS"}, {ReturnStatus: "COMPLETED"} );

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Dear Mr. Warren,
Good Morning and Thank you for your reply.

Its strange for me as well.
If error or issue, to happen all the time. not some time and some time not.

I suspect, that while developing I am switching to several screen in design mode , may be the reason.
If it will be on running mode only, hopefully will have no issue.

Some time get confused in this power app and get lost in between Power app for teams and Power app. standard,
And after several correspondence on the community posting come to know this is not there or for teams should be written another way. As have developed in MS Access application for more than 15 years with the VBA coding mainly for service/maintenance industry, never face such situations.
Thank you once again.

Very best regards.

Was this reply helpful? Yes No