Answered

Combo Box Once Sorted Will Not Post Data

(0) Share

Report

Posted on by theBrianL

I have ComboBox1, which is a People box that is connected to a SalesList that updates the MainList in a people picker field called Name. In the Items property it has SalesList. It works fine until I try to sort the list.
I added Sort(SalesList.SalesDisplayName,Ascending). It sorts the list, but then adds these numbers at the bottom of each name like 6824,7815,etc, which are not in the list at all. ? Then when I select the whole card Name_DataCard4 it shows the Update formula which only allows ComboBox1.Selected, whereas before I was using ComboBox1.Selected.Name. It doesn't allow ComboBox1.Selected.Result either. So the data doesn't post to the SP List. Any idea what is causing this behavior?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-liwei-msft on at

Like (0)

Report

Hi @theBrianL

Could you please tell me:

What type of columns are Name and SalesDisplayName?

Best Regards,

Levi

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

Name is Person and Group(People Picker) and SalesDisplayName Single Line of Text.

Was this reply helpful? Yes No
v-liwei-msft on at

Like (0)

Report
Hi @theBrianL

Do you want to update the person column of the main table based on the text column of SalesList?

You need to use the Office365Users connector.

I made a test for your reference:

1.

2.

Sort(NEW,SalesDisplayName,Ascending).SalesDisplayName

3.

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpanderUser", Claims: "i:0#.f|membership|" & Lower(First(Office365Users.SearchUserV2({searchTerm: ComboBox1.Selected.SalesDisplayName}).value).Mail), Department: "", DisplayName: ComboBox1.Selected.SalesDisplayName, Email: "", JobTitle: ".", Picture: "." }

Best Regards,

Levi

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

OK I'm not currently using 365. The whole thing works fine and updates the list and adds the person in the people picker field (name). It's just that when I try to add a sort formula, all of this strange behavior happens.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (1)

Report

Hi @theBrianL

Please try:

Sort(SalesList,SalesDisplayName,Ascending).SalesDisplayName

Best Regards,

Levi

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

Well that worked except I left off the .SalesDisplayName at the end. Thank you!

Was this reply helpful? Yes No