cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShadowTech
Post Prodigy
Post Prodigy

Auto populate Branch choice field when new for submitted

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @ShadowTech

This makes the issue clear.

You should keep the Items formula that generated by default.

However, you should change your formula a little bit because there is a little difference of format between your choices and your Switch() formula.

 

Set(vNewBranch, 
   Switch(varUser365Record.officeLocation,
       "Fresno", "10 Fresno",
       "Tulare", "05 Tulare",
       "Bakersfield", "06 Tulare",
       "Redding", "07 Redding",
       "Boise", "14 Boise",
       "Salt Lake City", "03 Salt Lake City",
       "Denver", "13 Denver",
       "San Diego", "12 San Diego",
       "Emeryville", "01 Emeryville",
       "Stockton", "04 Stockton",
       "Modesto", "11 Modesto",
       "Walnut", "09 Walnut",
       "Phoenix", "08 Phoenix",
       "Yuba City", "02 Yuba City"
   )) // Format each city as the way you set for the Choices options

 

1). Modify your Set() function as above

2). Set the DefaultSelectedItems property of the Combo Box as below:

 

[vNewBranch]

 

3). Set the Update property of the Data card as below:

 

ComboBox_Branch.Selected

 

vqiaqimsft_1-1628063766794.png

To sum up:

  1. Modify your Set() formula to make the city format same as the options from your dropdown list
  2. Set the DefaultSelectedItems property of the Combo Box as [vNewBranch]
  3. Set the Update property of the Data card

 

Best Regards,
Qi

View solution in original post

@v-qiaqi-msft Got it working with the following:

 

DefaultSelectedItems = [vNewBranch]

 

Update = DataCardValue63.Selected

 

Thanks again for your help.

View solution in original post

13 REPLIES 13
v-qiaqi-msft
Community Support
Community Support

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.

Best Regards,
Qi

@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. 

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}
Best Regards,
Qi

@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?

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.

Best Regards,
Qi

@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?

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}
Best Regards,
Qi

@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.

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.

Best Regards,
Qi

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,527)