Answered

Problem with Patch and Toggle switch

(0) Share

Report

Posted on by JulianTaylorUCL

Background:
Excel table stored in Sharepoint, which is populated in turn from a MS Bookings application via a Automated flow.
I created a vertical gallery (blank) and added my fields (BookTime, Name, ID, Email)
I added a toggle switch (AttendedToggle) which will set "Yes" into the Attended field (text)

True text value is "Yes" and false text value is "No"
Toggle switch default

If(IsBlank(ThisItem.Attended), false, true)

My OnCheck value is:

Patch(
 MyTable,
 Filter(MyTable,Email = ThisItem.Email),
 {
 Attended:Text("Yes")
 }
)

And this does not work. I tested the Patch by adding

Defaults(MyTable),

and the script works perfectly, and adds a new row with "Yes" in the Attended column.

What am I doing wrong here please?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JulianTaylorUCL

Make sure that the Attended field in the SharePoint list is a text field, as the toggle switch is set to update the field with a text value ("Yes"). If the Attended field is a different data type, such as a boolean or number, the toggle switch may not be able to update the field correctly.

Patch(
MyTable,
Filter(MyTable, Email = ThisItem.Email),
{
Attended: true
}
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
mbarbosa 146 on at

Like
a
(0)

Report
Copy link

Link copied!

You can also verify that the Email string you're comparing is Ok. Because if it adds a new line, maybe the problem is that is not finding the correct line to patch because of the email comparison.

Was this reply helpful? Yes No
JulianTaylorUCL 11 on at

Like
a
(1)

Report
Copy link

Link copied!
Many thanks. I identified the problem as being a connectivity issue between PowerApps and the Excel spreadsheet where I was using the MS Bookings Booking_id as the ID for each row. I changed that to using __PowerAppsId__ and was able to get it running fine using

Patch( MyTable, ThisItem, {Attended: AttendedCheckBox.Text} )

Thanks for your help!

Was this reply helpful? Yes No