Change Yes/No field when modify date field

(0) Share

Report

Posted on by sachk1

258

Hi,

I have a simple form with date field and choice field (Yes/No). when user changed the existing date field value, automatically choice column should be changed to No.

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
Hi @sachk1 ,

Set a Variable OnChange of the Date Picker

UpdateContext({varChanged: true})

and the Default of the Checkbox - assumeig you are saving to and displaying a data source field in it.

If( varChanged, false, Parent.Default )

also at Screen OnVisible

UpdateContext({varChanged: false})

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
sachk1 258 on at

Like (0)

Report

Hi thank you for reply., this is not working. error in Default of the choice field. any suggestions

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

@sachk1 ,

I assumed you meant yes/no (true false) - are you using a drop-down or a combo box to choose the value ?

Was this reply helpful? Yes No
sachk1 258 on at

Like (0)

Report

Hi,

I used a choice column in sharepoint. (Dropdwon ), by default its in "No" status. after a mail it change to "Yes". Then after that if user changed the date again I need to change to "No" status

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@sachk1 ,

OK - you did not specify the drop-down of combo box question, but I will give you both answers

Drop-down Default

If( varChanged, "Yes", Parent.Default )

Combo Box DefaultSelectedItems

{ Value: If( varChanged, false, YourChoiceFieldName.Value ) }

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
sachk1 258 on at

Like (0)

Report

Hi, thank you for helping. However the formula is not correct.

Was this reply helpful? Yes No
Verified answer

sachk1 258 on at

Like (0)

Report

The following works for the DefaultSelectedItems
{
Value: If (
varChanged,
false,
ThisItem.'Email Status'.Value
)
}

For the Default , the expression gives an error.

If(
varChanged,
"Yes",
Parent.Default
)

Is there any mistake done here?

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

@sachk1

Is this a drop down or combo box and what is the field name and type it is reading from/ writing to ?

Was this reply helpful? Yes No
sachk1 258 on at

Like (0)

Report

its a dropdown. I achieved through the above expression I mentioned and without an expression for default. And thats work well.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@sachk1 ,

If a drop down, the you need the Default property and writing to a Choice fiels

{ Value: If( varChanged,"Yes", ThisItem.YourChoiuceFieldName.Value ) }

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No