Unanswered

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 Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

FunkyStuntMunky 8 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

FunkyStuntMunky 8 on at

Like (0)

Report
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)

Was this reply helpful? Yes No
Suggested answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Instead of Collect use Clear Collect

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

Was this reply helpful? Yes No