Is there a way to clear out datacardvalue2 in an edit form if datacard value2 choice is changed?

(0) Share

Report

Posted on by DGWolfe

Hi all,

I have a workflow app, with an editable form that writes back to a SharePoint list.

One of the datacards links to a Team with two choices (choice field):

Team A

Team B

There is a second datacard that links back to a people column in SharePoint.

I have been asked to ensure if the team changes in datacardvalue1, then it clears the person listed in datacardvalue2 (but obviously no change if the form is edited but the team remains the same).

Any suggestions on the best way to execute this?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @DGWolfe ,

in the OnChange property of the first control reset the second control

Reset(DatCardValue2)

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
DGWolfe on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thank you. I did try this but the name remains the same. Could it be because datacardvalue 2 is linked to a person column? Not sure why it's failing?

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@DGWolfe ,

Resetting a control either directly or by a Variable trigger in its Reset function sets it back to its Default value, which may not be blank (except if the Form is on New Mode). What are the current Items and DefaultSelectedItems (I assume this is a Combo Box).

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @DGWolfe ,

Do you have anything in the Default property?
Reset will restore to default value.
If you clear that out, then it might work.

Edited: Noticed you updated the same. @WarrenBelz 😅
Hope this helps

Was this reply helpful? Yes No
DGWolfe on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
DefaultSelectedItems = Parent.Default.

Default = blank/empty.

Was this reply helpful? Yes No
DGWolfe on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R thanks, but I kept my default blank. So, still not sure why its failing.

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@DGWolfe ,

It is the DefaultSelectedItems that is doing this - what is the Items property and what is the name of the Person field you are displaying ?

Was this reply helpful? Yes No
DGWolfe on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

Person field name: Assignee
Items = Choices({@SPLIST].Assignee)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@DGWolfe ,

OK - you also need to be careful with this as you could easily delete existing data. OnChange of the first control put this

UpdateContext({varReset: false}); UpdateContext({varReset: true})

On the Reset of the second Control

varReset

At Screen OnVisible and at the end of your form save code

UpdateContext({varReset: false})

and lastly your DefaultSelectedItems

If( !varReset, Parent.Default )

Note that if the user saves the form without entering anything in the second box, you will delete the existing data in your list record field.

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
DGWolfe on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz legend as always! Thank you! It was the last two actions I didn't have that solved the issue 🙂

Was this reply helpful? Yes No