cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Use ComBox to drive the population of other fields?

@simms7400 

As mentioned before, that formula will not validate on Default or DefaultSelectedItems because it is a lookup that returns a string value (TA).

If your DropDown Items are set to RD_Indication_List and the field you are displaying is TA then you only need to put the formula - Lookup(Rd_Indication_List, Alias=DataCardValue2.Text) in the DefaultSelectedItems property.

You WANT this to be a full record.  The ComboBox is already defined to handle which field to use.  If you try to assign a field from that lookup, you will get an error.  So, just set the above formula and see if that gets you where you are looking to go.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Post Prodigy
Post Prodigy

Re: Use ComBox to drive the population of other fields?

@RandyHayes 

 

Hi Randy - okay that formula validates, but it doesn't return anything.

 

Keep in my mind, my "TA" field is not part of the "RD_Indicatin_List" data source.  My Editform and all fields (except the ComboBox) have a data source of "rdInvestments".

 

My "TA" field is connected to the "TA" column in "rdInvestments".  Is this why it doesn't return anything?

 

 

Highlighted
Post Prodigy
Post Prodigy

Re: Use ComBox to drive the population of other fields?

Furtermore, my "TA" field is a choice field.  And I have confirmed the TA values in "RD_Indication_List" are available in the choices in the "TA" field which is connected to "rdInvestments".

Highlighted
Post Prodigy
Post Prodigy

Re: Use ComBox to drive the population of other fields?

@RandyHayes 

 

And I should have clarified something else, but I didn't think it would be relevant.

 

Ultimately, this is an EditForm so if an end user is creating a new data element, I want the TA field to populate with the value from "RD_Indication_List" (aka the purpose of this entire thread so far).  However, if it is a change request, I want to just use the "Default.Parent" logic and I would toggle between the two with a simple If statement. Because if its a change request, I need to give the end user the ability to switch etween TA value (hence why its a choice field).  I DONT want them chosing TA when it's a new data element, as explained above.

 

Thank you!

 

Thanks!

Highlighted
Super User
Super User

Re: Use ComBox to drive the population of other fields?

@simms7400 

I have seen the picture of your RD_Indication_List columns.

Can you share a picture of your rdInvestments so I can see the columns of interest there as well.

 

I'm not understanding the statement that the "TA" field is not part of the RD_Indication_List, but then you say the "TA" field is connected to the "TA" column in "rdInvestments".  Is there a TA in investments and indication or just exactly what?  And I also, in reviewing, see you are using the IND_DESC with the Alias field in your combobox6.  Not sure how that ties to the data.

 

Also, you keep mentioning Choice field.  Are you referring to the column type in the datasource?  I thought that was a Lookup to another list?  This is important to know as Choice fields are different.

 

But, try to fill in those blanks for me and definitely some pictures of the data definition would be very helpful at this point as I'm getting a little lost in the thread here.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Post Prodigy
Post Prodigy

Re: Use ComBox to drive the population of other fields?

@RandyHayes 

 

I'm sorry! Let me clarify.

 

As you know, I have a "TA" column in my "RD_Indication_List" data source.  However, I have a "TA" Choice DataCard field on my EditForm which is connected to a "TA" column in the "rdInvestments" source.  So to answer your question, yes, there is a "TA" field in both "RD_Indication_List" and "rdInvestments".

 

Furthermore, yes, the "TA" field in "rdInvestments" is a choice SharePoint data type hence my mentioning of "Choice" in earlier communication.

 

choice.jpg

So quick recap.  If an end user is submitting a new request (i.e. there is not InvesmentId yet assigned), I want to use the logic we have been talking about in this thread to return the TA value based on the value of ComboBox in "RD_Idication_List".  But if it is a change request (i.e. an InvestmentID is assigned [as seen above]) then I want to just leverage default logic and return the value from "rdInvestments" where this TA field is connected to.

 

I plan to just use some simple If logic to check whether it is a new or change request and then use the application logic.

 

Once we can get this formula working, it should be smooth sailing after that.

 

Thank you for all your help, Randy!

 

Highlighted
Super User
Super User

Re: Use ComBox to drive the population of other fields?

@simms7400 

We'll get there!! Smiley Happy  It's always a challenge to completely understand the data and the scenario.

 

I think I am following a little more now with your explanation.  You are referring to the datacard as the field in this case. That is fine. 

 

Okay...so, my concern then is this.  If the user is submitting a new request, then they would be picking from a list from the TA value in the RD_Indication_List??  How does that correspond to the choices?  If your column does not have the exact same values or allow for additional items, then that is not going to help much.  You would either need to have those conditions for your choice column, or you would need to store the value in another column.

 

So, that's the big question now...do the choices for the choice column match what is in the RD_Indication_List?  And, if so, then is it the Alias that you want to display to the user and then fill in the TA with the TA value from the RD_Indication_List? (I think that might be what you are referring to).

 

Let's see if we can get this wrapped up for you.  If we need to, I'd be happy to Skype with you and look at it first-hand along side of you.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Post Prodigy
Post Prodigy

Re: Use ComBox to drive the population of other fields?

@RandyHayes 

 

Hi Randy -

 

Per your first question, if the user is submitting a new request, I don't want them picking anything. I want the TA DataCard to populate with the TA value in the "RD_Indication_List" based on the value in the ComboBox.

 

However, when end users are submitting a change request, I want to give them the ability to choose a new TA if they wish using the native Choice functionality of the TA DataCard which is connect to the "rdInvestments" data source.

 

But, perhaps I'm going about this all wrong? I'm open to any suggestions.

 

Ultimately, the reason for either scenario is when a new data element is create, there is a "business" requirement to set certain attributes based on the value of the ComboBox value. Think of the "RD_Indication_List" as the "business mapping".

 

Then, since this isn't a perfect world, there may be exceptions made where the TA value needs to be changed so then an end user will intitate a change request and choose the new TA.

 

More importantly, yes, the values in both TA columns are the same. 

 

So in conclusion, if it's a new request (and using our example) the value "CVM" would be derived from the "RD_Indications_List" table based on the ComboBox value and then when submitted, it would populate the TA column in "rdInvestments".  Then, if that needed to be changed, and end user would initiate a chane request, and in the default would be "CVM" but then they could choise from the drop down the correct one and resubmit.

 

Thank you so much Randy! I  hope we dont need to skype as I'd hate to take anymore of your time. I already feel indebted to you 🙂

Please let me know if you require any additional clarification.  Thanks!!!

Highlighted
Super User
Super User

Re: Use ComBox to drive the population of other fields?

@simms7400 

 

Per your first question, if the user is submitting a new request, I don't want them picking anything. I want the TA DataCard to populate with the TA value in the "RD_Indication_List" based on the value in the ComboBox.

But, you do want them picking something from the ComboBox.  In this case something from the RD_Indication_List...the Alias or something else?  AND...once they pick that, you want the TA value from the RD_Indication_List that is based on their selection to be the value in the TA column of the Investment record?  If that is correct...then the question still remains, do the choices correspond to the value in the TA columns of the RD_Indication_List?  They will need to.

 

However, when end users are submitting a change request, I want to give them the ability to choose a new TA if they wish using the native Choice functionality of the TA DataCard which is connect to the "rdInvestments" data source.

That seems pretty basic.  You just want them to pick another TA value from the choices of the Investment record TA column.

 

But, perhaps I'm going about this all wrong? I'm open to any suggestions.

No, I think you are on the right track. I appologize that I'm just struggling to keep the pieces together in my mind as we go along.  Again, always easier when you're close to the data and scenario...as you are.

 

Ultimately, the reason for either scenario is when a new data element is create, there is a "business" requirement to set certain attributes based on the value of the ComboBox value. Think of the "RD_Indication_List" as the "business mapping".

 

Then, since this isn't a perfect world, there may be exceptions made where the TA value needs to be changed so then an end user will intitate a change request and choose the new TA.

 

More importantly, yes, the values in both TA columns are the same. 

THAT is good news!  Answers the question I had above.

 

So in conclusion, if it's a new request (and using our example) the value "CVM" would be derived from the "RD_Indications_List" table based on the ComboBox value and then when submitted, it would populate the TA column in "rdInvestments".  Then, if that needed to be changed, and end user would initiate a chane request, and in the default would be "CVM" but then they could choise from the drop down the correct one and resubmit.

I think I've got it!

 

Thank you so much Randy! I  hope we dont need to skype as I'd hate to take anymore of your time. I already feel indebted to you 🙂  

Oh no worries.  I am very happy to help out.  I always want everyone's experience with PowerApps to be a pleasant one.  Sometimes it's a bridge to cross.

Please let me know if you require any additional clarification.  Thanks!!!

I think it is good...let me review everything now and see what I can put together for you.  


 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Post Prodigy
Post Prodigy

Re: Use ComBox to drive the population of other fields?

@RandyHayes 

 

Thank you so much, Randy!!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,794)