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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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