cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markaxtell
Frequent Visitor

Default Selected Items in Combo Box

Hi everyone, hopefully someone can help.

 

So I currently have a Combo Box that is displaying as default selected items the data from SharePoint using

 

 

LookUp(SiteDetails,BUNInput.Text=Title,DelHrsStartMon)

 

 

This returns the correct time from SharePoint and displays it in the combo box which is what i need.

But what i want to do now is have a toggle button that depends on what is pressed (true or false) i either get the above code or i get the time from another combo box.

I have so far tried the below

 

 

If(Toggle1.Value=true,FdOpSun.Selected.Value,LookUp(SiteDetails,BUNInput.Text=Title,DelHrsStartSun.Value))

 

 

 But i get an error of expected table.

 

Any help would be hugely appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

Try this:

 

If(Toggle1.Value=true,FdOpSun.Selected,LookUp(SiteDetails,BUNInput.Text=Title,DelHrsStartSun))

 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Jeff_Thorpe
Super User
Super User

Where is the IF() formula being used?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

In the Default Selected Items option of the combo box. 

Try this:

 

If(Toggle1.Value=true,FdOpSun.Selected,LookUp(SiteDetails,BUNInput.Text=Title,DelHrsStartSun))

 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,215)