Toggle (yes/no) choice does not stick

(0) Share

Report

Posted on by Misa

248

Hello again.

I created a canvas app that is connected to a sharepoint list. I have a screen that has a gallery on the left and form data on the right. One of the columns is a yes/no toggle. When the user chooses a yes/no, the choice reverts back to the original. The formulas that i am using are:

OnCheck: Patch('Letter Templates',LookUp('Letter Templates',ID=gal_EmpList.Selected.ID),{'Has the pdf been exported?':true,'Exported by whom':User().FullName,'Exported Date':Now()});

UnCheck: Patch('Letter Templates',LookUp('Letter Templates',ID=gal_EmpList.Selected.ID),{'Has the pdf been exported?':false,'Exported by whom':User().FullName,'Exported Date':Now()});

Default on the datacard: Blank

Default on field: If(ThisItem.'Has the pdf been exported?'= true, true, false)

When the user toggles, you can see in the gallery the one that was selected "blinks" and then goes back to the original choice.

Any ideas?

Thank you for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Hi @Misa ,

You could set the toggle's default to:

LookUp('Letter Templates',ID=gal_EmpList.Selected.ID).'Has the pdf been exported?'

Best Regards,

Bof

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

Thank you for your response @v-bofeng-msft. I tested the formula and it is still reverting back.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Misa ,

Could you please show me some screenshots?

In addition, maybe you could try:

OnCheck: Patch('Letter Templates',LookUp('Letter Templates',ID=gal_EmpList.Selected.ID),{'Has the pdf been exported?':true,'Exported by whom':User().FullName,'Exported Date':Now()});Refresh('Letter Templates');ResetForm(FormName)

UnCheck: Patch('Letter Templates',LookUp('Letter Templates',ID=gal_EmpList.Selected.ID),{'Has the pdf been exported?':false,'Exported by whom':User().FullName,'Exported Date':Now()});Refresh('Letter Templates');ResetForm(FormName)

Default on the datacard: Blank

Default on field: LookUp('Letter Templates',ID=gal_EmpList.Selected.ID).'Has the pdf been exported?'

Best Regards,

Bof

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

Of course @v-bofeng-msft . To make sure i send the correct screenshots, which would you like?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Misa ,

Could you please show me ,

Where is the toggle? In the gallery or in a form?

What is gal_EmpList? Is it a gallery?

What is gal_EmpList's items property? What is the form's data source? What is the form's item property?

What is 'Has the pdf been exported?'? Is it a 'Yes/No' column?

Bes Regards,

Bof

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

@v-bofeng-msft
Where is the toggle? In the gallery or in a form? The toggle is on the form, not the gallery
What is gal_EmpList? Is it a gallery? gal_Emplist is the gallery
What is gal_EmpList's items property? What is the form's data source? What is the form's item property? Items property: Filter('Letter Templates', lbl_SearchBox.Text in 'Employee Name'.DisplayName || lbl_SearchBox.Text in 'Employee Name'.Claims)
What is 'Has the pdf been exported?'? Is it a 'Yes/No' column? Yes

Form.PNG

Field.PNG

Gallery.PNG

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Misa ,

Could you please tell me:

What is the form's data source? What is the form's item property ?

If the form's data source is 'Letter Templates' and the form's item is gal_EmpList.Selected, you could try:

OnChange: Patch('Letter Templates',ThisItem,{'Has the pdf been exported?':Self.Value,'Exported by whom':User().FullName,'Exported Date':Now()});

Toggle's default : ThisItem.'Has the pdf been exported?'

Best Regards,

Bof

Was this reply helpful? Yes No
Misa 248 on at

Like (0)

Report

My apologies @v-bofeng-msft . Yes you were correct. I commented out the formulas in both OnCheck/UnCheck and added the formula to OnChange and the toggle stayed. Woohoo!

Thank you so much for your assistance!!

Was this reply helpful? Yes No