Solved: Enter text Manually as well in Dropdown

manish94 · ‎07-04-2021

Hi,

I have created a form where I have Dropdown which is linked with each other and have a seperate sharepoint list just for Representative name and Number. When clicked on particular Name, the phone no. will be automatically selected from that sharepoint list. Now I want to enter text and phone no. manually as well. The flow is for word template.

Rep Number Properties:

Items: Filter ('Rep name and number' , RepName=Dropdown.selectedtext.value)

Rep Number DATA CARD - Update property -

repnameValue.Selected.'Mobile Number'

v-jefferni · ‎07-07-2021

Hi @manish94 ,

OK... I found after submitting the search text would be cleared from the combo box. So, we need to set some variables to store the search texts:

OnSelect of the submit button:

Set(varRepName, Combobox2.SearchText);
Set(varNumber, Combobox1.SearchText);
SubmitForm(Form)

OnSuccess of the Form:

If(
   !IsBlank(varRepName) &&
    IsBlank(
           LookUp(
                  SPlist,
                  Name = NameCombobox.SearchText
           )
   ),
   Patch(
         SPlist,
         Defaults(SPlist),
         {
          Title: varRepName,
          Number: varNumber
         }
   )
)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

v-jefferni · ‎07-05-2021

Hi @manish94 ,

If these two are Combo boxes, you could try and use the search text as the typed in strings to update to the data source:

Update of Name data card:

If(
   IsBlank(NameCombobox.Selected),
   NameCombobox.SearcText,
   NameCombobox.Selected.Value
)

Update of Number data card:

If(
   IsBlank(NumberCombobox.Selected),
   NumberCombobox.SearcText,
   NumberCombobox.Selected.Value
)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

manish94 · ‎07-05-2021

Hi @v-jefferni ,

Both the field is Dropdown field. Is there any option for this one?

Thank you

v-jefferni · ‎07-05-2021

Hi @manish94 ,

If they are dropdowns, there is no way to type in any texts for them. You will need separate Text input box to let users type in, but this may cause conflicts when update to data source if a dropdown item has been selected and texts have been typed in the text input at the same time. So you will need to set strict conditions to help the App judge which should be updated.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

manish94 · ‎07-05-2021

Hi @v-jefferni ,

So in Items property of the Rep Number i have: Filter('Ascent Rep Name and Number', ascentRepName=Dropdown1.SelectedText.Value). How can I change to combobox if I change both the dropdown to combobox option.

v-jefferni · ‎07-05-2021

Hi @manish94 ,

You could add combo box in each data cards the copy and paste Items formulas. The two kinds of controls are basically the same.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

manish94 · ‎07-05-2021

@v-jefferniI added the Combo box but when I click on Representative Name it doesn't sync with the Phone no. I created the Items manually for both Name and Number. is there a way we can link both input if a particular name is selected the particular phone no be automatically selected.

v-jefferni · ‎07-05-2021

Hi @manish94 ,

If you would like to make Combo boxes auto select an item from the data source, you will need to set the DefaultSelectedItems property.

On your end, Number combo box DefaultSelectedItems set to:

NameCombobox.Selected

OR vice versa.

But you need to note that you will not be able to let the Number combo box reference to Name combo box again since this is so called circular reference. If you do so, you will receive an error message as follows:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

manish94 · ‎07-05-2021

I Tried to do that but it seems there is some kind of issue.

The sharepoint list I created has Name and Number only.

The porperties of my Rep Num:

Items: 'Ascent Rep Name and Number'.'Mobile Number'

DefaultSelectedItems: RepnameCombobox.Selected

UPDATE: If(IsBlank(RepnameCombobox.Selected),RepnameCombobox.SearchText,RepnameCombobox.Selected.'Mobile Number')

And :

Properties of Repname is

Items: 'Ascent Rep Name and Number'.ascentRepName

update: If(IsBlank(Dropdown1.Selected),Dropdown1.SearchText,Dropdown1.Selected.ascentRepName)

The issue is when I click the RepName it doesn't show anything in the Mobile no. field.

v-jefferni · ‎07-05-2021

Hi @manish94 ,

Try and use the list name as the Items property: 'Ascent Rep Name and Number' , then you could select the display field and search field:

So the thing is you need to make the Items property of the two Combo boxes totally the same, then it would be easy enough to make the Number combo box auto select the same item as the Name combo box selected. Otherwise you will need the LookUp function to go to the list data source to find the same item.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.