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:

General Questions

All responses (6)

Answers (1)

theBrianL on at

Like (0)

Report

Re: Combo Box Once Sorted Will Not Post Data

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

v-liwei-msft on at

Like (1)

Report

Re: Combo Box Once Sorted Will Not Post Data

Hi @theBrianL

Please try:

Sort(SalesList,SalesDisplayName,Ascending).SalesDisplayName

Best Regards,

Levi
theBrianL on at

Like (0)

Report

Re: Combo Box Once Sorted Will Not Post Data

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.
v-liwei-msft on at

Like (0)

Report
Re: Combo Box Once Sorted Will Not Post Data

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
theBrianL on at

Like (0)

Report

Re: Combo Box Once Sorted Will Not Post Data

Name is Person and Group(People Picker) and SalesDisplayName Single Line of Text.
v-liwei-msft on at

Like (0)

Report

Re: Combo Box Once Sorted Will Not Post Data

Hi @theBrianL

Could you please tell me:

What type of columns are Name and SalesDisplayName?

Best Regards,

Levi