On Change property query

(0) Share

Report

Posted on by sankhlay

187

Hello All,

wanted some clarity on On Change property in a form control.

I have a data card value where the users would input a unique value pertaining to an employee. There are 5 more corresponding columns that currently the user inputs.

I have a database of that information in a SharePoint list and based on the input in the first data card (unique value), I would want the other few fields to update the details from database.

I tried the lookup formula in the on change property of the 2nd data card value, but have no luck. I also tried this in other data cards value box.

Request you to help.

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @sankhlay,

OnChange property only supports behaviour function like Patch(), Set(), Navigate(), LookUp() is non-behaviour function.

You need to set the OnChange property of the first data card value as a variable:

Set(varItem,LookUp())

Then assign the specific field of the record from the varItem, set the Default property of other datacardvalue as varItem.FieldName.
sankhlay 187 on at

Like
a
(0)

Report
Copy link

Link copied!

~~thank you for your response. Let me try this and share my results with you~~
Chris-D 1,246 on at

Like
a
(0)

Report
Copy link

Link copied!

If you then want to prevent the user from modifying these fields, you can either set the DisplayMode to Displaymode.Disabled or put a transparent rectangle over the text box.
cdwhite 1,069 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sankhlay ,

Please try the lookup formula in the Default property of the 2nd datacard.
The OnChange property will only trigger if the user physically changes the values in DataCard2 or onwards.

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net
sankhlay 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for all your help. I was able to work with the variable.
sankhlay 187 on at

Like
a
(0)

Report
Copy link

Link copied!

I had one more question. I have a couple of choice columns; I am unable to update them based on the default property.

I used VarItem.WorkLocation
Chris-D 1,246 on at

Like
a
(0)

Report
Copy link

Link copied!
Choice columns are actually single column collections with one item.

Try:
{ Value: VarItem.WorkLocation}
sankhlay 187 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried with default as well as the Items property, did not work.
sankhlay 187 on at

Like
a
(0)

Report
Copy link

Link copied!

@Chris-D - Am I missing anything on this.