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

LookUp Default for Database Table

I have a combobox pointing to a Dataverse Table named Solicitation.  On the Default I have added this formula, which takes me to the record. I can see it's found because of the data below the formula field, as you can see in the first screenshot. However, it does not show up as default:

LookUp(Solicitations, 'Solicitation Id'=SolicitationNumberNeeded.Text)

Solicitations is the table, 'Solicitation ID' is the field, SolicitationNumberNeeded.Text is the Solicitation ID number for the Solicitation record I'm trying to bring up.

 

The idea is that when the SolicitationNumberNeeded.Text changes, the default value of the Combobox Solicitation will change to the one with that Solicitation ID.  Thank you for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Super User
Super User

Hi @Heaven4ever2 ,

 

Please use this code to set the DefaultSelectedItems property, rather than the deprecated Default property.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

4 REPLIES 4
BCBuizer
Super User
Super User

Hi @Heaven4ever2 ,

 

Please use this code to set the DefaultSelectedItems property, rather than the deprecated Default property.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Thank you so much, @BCBuizer!  That worked 🙂

BCBuizer
Super User
Super User

Hi @Heaven4ever2 ,

 

Glad to have been of help. Can you please mark the correct post as the solution to your question for the benefit of the community?



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Hi @BCBuizer 

I have corrected it.  I'm new at this, as you can tell 😂.  Thanks again 🙂

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

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