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

All responses (8)

Answers (1)

MIA27 on at

Like (0)

Report

Re: My combo box control bring additional row - How to control

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.
Verified answer

WarrenBelz 146,645 Most Valuable Professional on at

Like (1)

Report
Re: My combo box control bring additional row - How to control

@MIA27 ,

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

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

Like (0)

Report

Re: My combo box control bring additional row - How to control

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.
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: My combo box control bring additional row - How to control

@MIA27 ,

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

Like (0)

Report

Re: My combo box control bring additional row - How to control

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.
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: My combo box control bring additional row - How to control

@MIA27 ,

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

Like (0)

Report

Re: My combo box control bring additional row - How to control

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.
WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report

Re: My combo box control bring additional row - How to control

@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