Unanswered

Using a toggle in a gallery to edit a SharePoint item

(0) Share

Report

Posted on by NewUser2626

Hello,

I am wondering if it is possible to add a toggle in a gallery that when changed, will change the content of an item in the SharePoint site connected to the Gallery?

For example, I have an "Active/Inactive" Column in my SharePoint site. When the toggle is turned on, I would like the "Active/Inactive" field of the corresponding item to change from Active to Inactive.

Is this a possibility within Power Apps, and how might I go about executing this function?

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@NewUser2626

Let’s assume your SharePoint list has a column called Active/Inactive and is a Choices type column. It has two options “Active”, “Inactive”

Put this code the Items property of your gallery

your_sharepoint_list

Then place a toggle inside the gallery. Use this code in the OnChange property:

Patch(your_sharepoint_list, LookUp(your_sharepoint_list, ID=ThisItem.ID), {‘Active/Inactive’.Value=If(ThisItem.Toggle1.Value,“Active”, “Inactive”)})

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
NewUser2626 2 on at

Like (0)

Report
Copy link

Link copied!

Hello @mdevaney

Thank you for your response, when I input the code into the OnChange property of the toggle, a red line appears underneath the end part of the code - {‘Active/Inactive’.Value=If(ThisItem.Toggle1.Value,“Active”, “Inactive”)}. How can I edit this to be able to change an item in my sharepoint list when the toggle is turned on.

Thank you

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @NewUser2626 ,

Is "Active/Inactive" choice type?

I assume that yes.

Please set like this:
1)insert a gallery, set its Items: your sharepoint list

2)insert a toggle inside the gallery

set the toggle's Default:

ThisItem.Active/Inactive.Value="Active"

set the toggle's OnChange:

If(togglename.Value, Patch(sharepoint list name,ThisItem,{Active/Inactive.Value:"Active"}), Patch(sharepoint list name,ThisItem,{Active/Inactive.Value:"Inactive"}) )

Best regards,

Was this reply helpful? Yes No