Auto populate Branch choice field when new for submitted

[ShadowTech]

Hello,

I want to have the Branch field (Office Location) populated based on O365UserProfile.Officelocation. So if the Officelocation is "Fresno" choose "Fresno" in the choice Branch field in the new form.

Was trying something like this which is not working. Suggestions appreciated.

Set(vNewBranch, 
   Switch(varUser365Record.officeLocation,
       "Fresno", "Fresno",
       "Tulare", "Tulare",
       "Bakersfield", "Tulare",
       "Redding", "Redding",
       "Boise", "Boise",
       "Salt Lake City", "Salt Lake City",
       "Denver", "Denver",
       "San Diego", "San Diego",
       "Emeryville", "Emeryville",
       "Stockton", "Stockton",
       "Modesto", "Modesto",
       "Walnut", "Walnut",
       "Phoenix", "Phoenix",
       "Yuba City", "Yuba City"
   ))

Branch datacardvalue

vNewBranch

Thanks in advance.

[v-qiaqi-msft]

Hi @ShadowTech，

Could you please tell me that:

1. if the Branch field is a Choice column that has a Combo Box within the New Form?
2. how you set the Items property of the Combo Box?

Do you want to populate the Combo Box based on the Officelocation of the current user?

Generally, if you want to populate the Combo Box, you should set the DefaultSelectedItems property.

Please tell me the above details in your scenario.

[ShadowTech]

@v-qiaqi-msft No combo box. Just started this. Basically I have a choice field (Branch) in a new form that I would like to just hide and not have to have the user input anything there. I would like to have the users OfficeLocation auto populate the choice when the form is submitted.

example:

If the users o365userprofile.officelocation = "Fresno", the Choice is "Fresno".

Thanks. Hope that clarifies. 

[v-qiaqi-msft]

Hi @ShadowTech,

What kind of control do you add for the Choice column Branch in your new form? Generally it is a Combo Box generated by default.

Or you choose a TextInput to filled with the OfficeLocation and save this value to your Choice field in the SP list?

I need more details about your new form configuration and your SP list data set.

Not sure about the details of your scenario, I made a simple test for you.

Just Assume that you have a Text Input to populated with the location.

Set the Default property of the Text input as your variable:

vNewBranch

Set the Update property of the data card as below:

{Value:vNewBranch}

[ShadowTech]

@v-qiaqi-msft  combobox. Its the dropdown created by default for the Choice field. No text input.

Can I not use this?

Set(vNewBranch, 
   Switch(varUser365Record.officeLocation,
       "Fresno", "Fresno",
       "Tulare", "Tulare",
       "Bakersfield", "Tulare",
       "Redding", "Redding",
       "Boise", "Boise",
       "Salt Lake City", "Salt Lake City",
       "Denver", "Denver",
       "San Diego", "San Diego",
       "Emeryville", "Emeryville",
       "Stockton", "Stockton",
       "Modesto", "Modesto",
       "Walnut", "Walnut",
       "Phoenix", "Phoenix",
       "Yuba City", "Yuba City"
   ))

Or should I go a different route?

[v-qiaqi-msft]

Hi @ShadowTech,

Set() function should be set for the OnSelect property, where do you put this formula?

I have asked that how you set the Items property of the Combo Box at my first reply. If the Branch field is a Choice field, it should have options for itself.

For your need that populate the Branch with the user location, I don't think a choice field is a good choice. A single-line-of-text could be better to fit in your scenario.

Whatever, set the Items property of the Combo Box as below:

[Switch(varUser365Record.officeLocation,
       "Fresno", "Fresno",
       "Tulare", "Tulare",
       "Bakersfield", "Tulare",
       "Redding", "Redding",
       "Boise", "Boise",
       "Salt Lake City", "Salt Lake City",
       "Denver", "Denver",
       "San Diego", "San Diego",
       "Emeryville", "Emeryville",
       "Stockton", "Stockton",
       "Modesto", "Modesto",
       "Walnut", "Walnut",
       "Phoenix", "Phoenix",
       "Yuba City", "Yuba City"
   )] // Please remember to add the "[]" to format it as a Table.

Set the Update property of the data card as below:

{Value:Switch(varUser365Record.officeLocation,
       "Fresno", "Fresno",
       "Tulare", "Tulare",
       "Bakersfield", "Tulare",
       "Redding", "Redding",
       "Boise", "Boise",
       "Salt Lake City", "Salt Lake City",
       "Denver", "Denver",
       "San Diego", "San Diego",
       "Emeryville", "Emeryville",
       "Stockton", "Stockton",
       "Modesto", "Modesto",
       "Walnut", "Walnut",
       "Phoenix", "Phoenix",
       "Yuba City", "Yuba City"
   )}

Note that a Choice field has its own options, there is no need to use Switch() to re-configure the options for the Combo Box in the new form.

[ShadowTech]

@v-qiaqi-msft So I'm replacing the datacardvalue (Choices([@'Branch Repair'].Branch) with 

[Switch(varUser365Record.officeLocation,
       "Fresno", "Fresno",
       "Tulare", "Tulare",
       "Bakersfield", "Tulare",
       "Redding", "Redding",
       "Boise", "Boise",
       "Salt Lake City", "Salt Lake City",
       "Denver", "Denver",
       "San Diego", "San Diego",
       "Emeryville", "Emeryville",
       "Stockton", "Stockton",
       "Modesto", "Modesto",
       "Walnut", "Walnut",
       "Phoenix", "Phoenix",
       "Yuba City", "Yuba City"
   )] 

Correct?

Also, This choice field was created when connected to my SharePoint list. This is not a combobox that I inserted myself. There is a choice field called "Branch" in the SharePoint list. This is what I want auto populated.

Set() is on the onselect of the icon that makes the form visible. What should the entire set be then?

[v-qiaqi-msft]

Hi @ShadowTech,

I do not really know why there is another issue that you want the Set() function to make the form visible. I could not imagine the whole logic to make the form visible, so I am sorry that I could not help you on this need except that you could provide your logic.

In addition, if you want to make the form visible when the variable is triggered, please set the Visible of the new form as below:

If(vNewBranch,true, false)

Since you have other function you want to set for the form, you could keep your Set() function.

1). Keep your Set() function

2). Remember to set the Items of the Combo Box with the following formula if you want to keep the Set() formula:

[vNewBranch]

3). Set the DefaultSelectedItems property as below:

[vNewBranch]

4). Set the Update property of the Branch data card as below: 

{Value:ComboBox_Branch.Selected.Value}

[ShadowTech]

@v-qiaqi-msft Making the form visible is a non-issue. The form is hidden until an icon is clicked. That is irrelevant. I think I it might be better to just start a new thread. I don't think we are really connecting. I'm basically asking the same question but your formulas keep changing. I do appreciate your help.

Thank you.

[v-qiaqi-msft]

Hi @ShadowTech，

My formula changes based on your description. 

Why not post a screenshot to describe if you have a Combo Box or not?

Since you have asked it in this thread, we should keep our own patience on it.

In addition, the varNewBranch is the variable you set, I just replace it with the Whole Switch() formula, there is no difference.

If you really have a new form, there must be a Combo Box corresponding to the Branch Choice field unless you add a custom control instead.

1. Set the Items of the Combo Box
2. Set the DefaultSelectedItems of the Combo Box
3. Set the Update property of the Branch data card 

All the formula you could check the previous reply I posted.

Thanks for your co-operation.