Collect() adds extra blank row after the proper row

(0) Share

Report

Posted on by FunkyStuntMunky

I have a combo box where I am search office 365 users, then OnChange I am adding the user to a collection. This is working except that it adds an extra row after each one

Collect(

    colGroupMembers,

    {

        Name: Trim(cboGroupMembers.Selected.DisplayName),

        Email: Trim(cboGroupMembers.Selected.Mail)

    }

);

Reset(cboGroupMembers)

 

Search Code for combo box:

 

Office365Users.SearchUserV2({searchTerm:Self.SearchText,isSearchTermRequired:true,top:15}).value

Categories:

Power Platform Build Tools

All responses (4)

Answers (0)

Suggested answer

Ram Prakash 5,284 Super User 2025 Season 1 on at

Like (0)

Report

Collect() adds extra blank row after the proper row

Hi,

Instead of Collect use Clear Collect

Subscribe for more : https://www.youtube.com/@rampprakash3991
Suggested answer

CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Collect() adds extra blank row after the proper row

The correct way to do is to use the OnSelect property and not the OnChange property.

Please remember to give a like👍and mark this reply Answered as it will help others in the future.
Suggested answer

FunkyStuntMunky 8 on at

Like (0)

Report
Collect() adds extra blank row after the proper row

OK answered my own question. Just checked the length of the item before running the Collect()

If( Len(cboSearchUsers.Selected.DisplayName) > 1, Collect( colGroupMembers, { Name: cboSearchUsers.Selected.DisplayName, Email: cboSearchUsers.Selected.Mail } ) ); Reset(cboSearchUsers)
FunkyStuntMunky 8 on at

Like (0)

Report

Collect() adds extra blank row after the proper row

after more testing, it appears it is due to the reset(cbogroupMembers) command. Is there a way to reset the search without triggering an OnChange event?