Answered

Set DataCardValue from Gallery selection

(0) Share

Report

Posted on by Jon Studsrud Microsoft Employee

Hello, So i'm looking for guidance on how to set a datacardvalue based on a selection from a gallery.

Currently I have an edit form that has a "Customer" field - DataCardValue2. The default is set to "ThisItem.Customer2" which works properly setting the the text to my customer value from a Sharepoint List. Keep in mind this value could be blank

Next to the form I have a gallery called Gallery2 that is populated by an excel spreadsheet filled with customer information. I filter this gallery based on a text field.

What I want to do is the following

1) Load the form, if there is a customer value in the SP List, populate DatavalueCard2

2) If the DatavalueCard2 field is blank I want to give the end user the ability to lookup the customer in the gallery, select the appropriate customer and then take that value and update the DatavalueCard2 field.

3) Also, if the DatavalueCard2 is populated already, the end user can still lookup a customer, select it and override existing value in event they made a mistake.

From what I have read I need to use set a variable and then use Updatecontext. I have tried this but I'm running into issue with my If logic I think. Looking for some help on best practice and how to code this.

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Studz02 ,
There are a couple of ways of doing this, but I will stick with the Variable concept you mention.
On the OnSelect of the gallery, put this
UpdateContext({vCustomer:ThisItem.Customer}); Reset(YourFormCustomerControl)
On the Default of the customer control in your form
If( !IsBlank(vCustomer), vCustomer, Parent.Default )
Then in the Save code add this
UpdateContext({vCustomer:Blank()})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Jon Studsrud Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. This worked out great. Just curious, is this the best approach? or would you have gone a different route?
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Studz02 ,
You can use the code directly in the Default of the control and reset it, but a Variable is probably cleaner.