Update edit form with checkbox

(0) Share

Report

Posted on by KPGlo08

Hi All,

I was wondering if you will be able to give me hints/suggestions with the scenario i have.

I am using share point list, which is connected to gallery, when user is selecting "pending task" then is directed to edit form. In the edit form there are 4 fields: Status, Checklist Result, Comments and Date/Time that needs to be updated. For make it more automized, i was wondering if a checkbox can be used to change their status accordingly.

Like, if the checkbox is checked, then

Status -> Completed;

Checklist Result -> 38;

Comments-> Final;

Date/Time->actual. (see attachment).

Tried to use "if statement", inside the edit form, but did not get positive response.

Thank you a lot for your reply.

Regards,

Karolina

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

gcmfaizan 1,022 on at

Like (0)

Report
Copy link

Link copied!
@KPGlo08 OnChange property of check box try this formula:
If(YourCheckBoxName.Value, UpdateContext({ StatusValue: "Completed", ChecklistResultValue: 38, CommentsValue: "Final", DateTimeValue: Now() }), UpdateContext({ StatusValue: Parent.Default, ChecklistResultValue: Parent.Default, CommentsValue: Parent.Default, DateTimeValue: Parent.Default }) )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
KPGlo08 4 on at

Like (0)

Report
Copy link

Link copied!

Hi gcmfaizan,

Thank you a lot for your suggestions. I tried it, but needed to workaround a bit, and still not success.
For some reason, formula you recommend gave me issues like: unexpected characters,( the commas after If statement and end of the UpdateContext).
For now i can see that in my Context Variables i see the values mentioned in the formula of UpdateContext, but can not override them in the referenced fields. (see attached printscreen)

Any other suggestions?
Looking for your reply.
Thank you !

Was this reply helpful? Yes No