On Change property query

(0) Share

Report

Posted on by sankhlay

183

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

I have the same question (0)

All responses (9)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
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.

Was this reply helpful? Yes No
sankhlay 183 on at

Like (0)

Report

~~thank you for your response. Let me try this and share my results with you~~

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
cdwhite 1,067 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
sankhlay 183 on at

Like (0)

Report

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

Was this reply helpful? Yes No
sankhlay 183 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (0)

Report
Choice columns are actually single column collections with one item.

Try:
{ Value: VarItem.WorkLocation}

Was this reply helpful? Yes No
sankhlay 183 on at

Like (0)

Report

I tried with default as well as the Items property, did not work.

Was this reply helpful? Yes No
sankhlay 183 on at

Like (0)

Report

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

Was this reply helpful? Yes No