Forum Discussion
Using embedded Power App to delete a row in a report datasource
Just for completeness, I solved it. The underlying table is a single-column primary key, identity type. Accordingly, it wasn't being passed into the app and so I couldn't do anything with it there. I modfied the report-app definition to incliude the key, and then changed my Remove function in the app to include LookUp by the key:
Remove('schema_name.table_name', LookUp('schema_name.table_name', mytableID = Gallery1.selected.mytableID))
and that works fine.
That seems to be more of a PowerApp question - maybe post in their forum? Microsoft Power Platform Community Forum Thread
Note: Patch can only update an existing record or create a new one. It cannot delete records.
Yes, my mistake on Patch and also accidentally posting to the wrong place. I steered here out of habit and didn't even realize it!