Hello, I have a sharepoint list "ItemList" with the following columns "Title" "Out" "User"
I would like to use patch so that when the app user clicks a button it will find the first instance from the list where the row has a value of "NO" in the "Out" column, and then update that row to change "NO" to "YES" and the append the Users name to the "User" Column
Sample data is as follows
| Title | Out | User |
| I1 | YES | Ben |
| I2 | NO | |
| I3 | NO | |
A successful use of the button would change the data to as follows
| Title | Out | User |
| I1 | YES | Ben |
| I2 | YES | Dan |
| I3 | NO | |
My button so far is as follows
Patch( 'ItemList', LookUp('ItemList', Out=NO), { User: "Dan" } )This looks to be correct but it is displaying an error on Out=NO Name isn't valid. This identifier isn't recognized.
