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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,569)