Forum Discussion

markmsc's avatar
markmsc
Resolver I
1 year ago
Solved

Using embedded Power App to delete a row in a report datasource

Hello all.  Pretty simple question here, really, but I've not turned up an example solution.  Would be grateful for a pointer.   I have a relatively simple Power BI report that displays the content...
Need Help
  • markmsc's avatar
    markmsc
    1 year ago

    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.

     

markmsc's avatar
markmsc
Resolver I
1 year ago

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.