Patching changed data from a collection back into a dataverse table including a Yes/No column

(0) Share

Report

Posted on by JezHolland

Good Day,

This particular issue has stumped me for the past few days.

I pull data into a collection (colProjRequests) from a dataverse table 'Project Requests'. In this dataverse table is a Yes/No toggle on a column called Request Active

I present this data, along with some related data in a Gallery.

I have added into the gallery a button that allows the user to close or open a request, and patches this back to the collection. Using this formula.

If(ThisItem.'Request Active' = 'Request Active (Project Requests)'.Yes,Patch(colProjRequests,LookUp(colProjRequests,ID=ThisItem.ID),{'Request Active':'Request Active (Project Requests)'.No}),Patch(colProjRequests,LookUp(colProjRequests,ID=ThisItem.ID),{'Request Active':'Request Active (Project Requests)'.Yes}))

I then filter the gallery on Yes/No status. This works.

However whenever I try to patch that collection back to the dataverse table it doesn't change the toggle for yes/no.

I have a separate button that patches the gallery back to the dataverse table and it uses the following formula.

Patch('Project Requests',colProjRequests)

I have looked at a few similar posts on this forum, and have tried a few other methods. I dont really want to revert to editing the dataverse table directly. Is anyone able to help, please?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @JezHolland

you can try this:

If( ThisItem.'Request Active', Patch( colProjRequests, LookUp(colProjRequests, ID = ThisItem.ID), {'Request Active': false} ), Patch( colProjRequests, LookUp(colProjRequests, ID = ThisItem.ID), {'Request Active': true} ) )

Patching back try this:

ForAll( colProjRequests, Patch( 'Project Requests', LookUp('Project Requests', ID = ID), {'Request Active': 'Request Active'} ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
JezHolland 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, whilst the first one works the 2nd doesnt. What isnt helpful is that it isnt throwing out any error messages so it looks like it might be working. It just isnt taking the value from that particular column in the collection.