Hello:
I am creating a Sales Proposal PowerApp that has many choices of products, each product has it's own screen
"Screen 1" is just customer information
"Screen 2 through 10" are different products that the sales rep can choose from, They can choose 1 product or all 10
Each product screen asks for the customer information and I do not want the sales rep to have to fill it out again each time they pick another product for the proposal. Each screen represents a different SharePoint List
Screen 1
Screen 2 through 10
Once Screen 1 is populated and no matter which screen the sales rep chooses, I want the customer information pre-populated from Screen 1
I have tried this, however its not working
If(editform2.mode=FormMode.New,LookUp(CustomerName_DataCard7,ItemNumber=DataCardValue406.Text,CutomerName))
Thanks for the help in advance!
What if you try to create global variables with the Screen 1 objects values?
For example, on the event below
Try to set the values of the objects. like
Set(DCV406,.text)...
Then on the other screens, you populate where you want with DCV406.text...
Set the Default property of DataCardValue44 (and any other ones you need) to the following formula:
Coalesce(Parent.Default, Form8.Updates.CutomerName)
I hope this is helpful for you.
@Anonymous
I am halfway there, thanks!
After I created the variable, I then when to the Screen - Datacard and for Default I added this
My value in the screen is now "false"
The source has data
What am I doing wrong on the when entering Default=DCV406
Thank You Again!
You cannot assign values like that in PowerApps.
Please change the formula on the TextInput control to:
Coalesce(Parent.Default, Form8.Updates.CutomerName)
Make sure you have not changed the Default property on the DataCard. It should still be ThisItem.yourFieldName
David, just missed the UpdateContext, take a look i just create a simple example:
Set the variable on the On Start as you did
On the control that you are using to navigate to the other screens, set the UpdateContext
And also on the screen that you navigate in, set on the OnVisble another UpdateContext
@Anonymous
You are mixing context and global variables in your examples. They are not connected.
The solution is quite simple:
Coalesce(Parent.Default, Form8.Updates.CutomerName)
There is no need for variables as the first form already has the values needed...just reference it!
Got it, it works for me in this way, didn't know about this Coalesce function! Thanks for that'll try to start using this approach also.
Always learning 😃
@Anonymous
That's the spirit...keep on learning! 😁
Yes, learn the Coalesce function - it is one of the most powerful and useful functions in PowerApps. Pus it will save you a lot of typing time...
If(IsBlank(myControl.Text), If(IsBlank(myOtherControl.Text), "Something"), myOtherControl.Text), myControl.Text)
is replaced with:
Coalesce(myControl.Text, myOtherControl.Text, "Something")
First argument that is NOT blank in a Coalesce will be used.
Just make sure you are matching types.
ex. Coalesce("Text", 2) will not work. Coalesce("Text", "2") would (although it would simply return the first - but the concept here is coalesce the same types)
User | Count |
---|---|
260 | |
109 | |
93 | |
57 | |
41 |