Share
Report
9Hello,
I'm pretty new to PowerApps, but I'm building an app for work and having trouble with something. My app is using an Excel datasource. It's a pretty simple and easy setup. I have a table in the datasource, let's say Table1, and 3 columns, Complete, Task, and Owner. In the PowerApps form, the user's have the ability to select Yes or No for Complete, Task is view only, and they can enter their name in the Owner field. Once they fill this all out, they can print it. Now I want them to be able to clear the Complete and Owner fields out after they're done, so it's all blank again, except for the Task field. Here's what I have, but this only clears out the first row. I need all of the rows cleared out in one shot. My "Clear Form" button has this in the OnSelect function.
Patch(Table1,First(Search(Table1,"","Owner","Complete")),{Owner:"",Complete:" "})
What the above does is, blanks out the Owner and Complete fields in the first row. But I need it to do it for all the rows. Can't figure out how to do it. I'm sure it's pretty simple. I tried to remove the "First" statement, but that didn't fly. Any help would be greatly appreciated! Thanks!
All responses (
Answers (
