Trying to Use a Patch Function to Update A DataVerse Table Record

(0) Share

Report

Posted on by cfarrell0208

I am trying to have an enroll button in my canvas app update the 'Remaining Seats' Column in my DataVerse table.

Here is my code:

ForAll(SelectedCourses, Patch('College Courses', LookUp('College Courses', 'Class Name' = ThisRecord.'Class Name'), {RemainingSeats : RemainingSeats - 1}))

The first time I reference RemainingSeats it is recognized, but the second time I get an error saying "Name isn't valid. 'RemainingSeats' isn't recognized. I don't know how to fix this.

Screenshot 2023-09-23 171517.png

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

If you are trying to refence itself against itself (like in Sql) it doesn't work like that. sorry :-(.

At the moment you are doing that, it has no idea what you are referring too because the LookUp, is about getting a reference for the patch command, not for property values.

You'd have to already have this value stored somewhere(variable, gallery.Selected, collection etc)

Does SelectedCourses have it? If so, use it like your 'Class Name = ThisRecord.'Class Name',if not, then you would have to do a lookup in place of the 2nd RemainingSets

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
cfarrell0208 6 on at

Like (1)

Report

Thank you so much!!! It worked 😀

Was this reply helpful? Yes No