Data Table

[patty789]

Hello,

How can i make a record that is showing on a data table to disappear from the list but not delete from the SP datasource. User selects this record and as soon as user is done answering this response the record that user selected should not show back in the data table. Is this possible. 

[mdevaney]

@patty789 

The general approach to this is to put your Sharepoint List in a collection and make the collection your data table's datasource instead.  When the user is done making their response they would click a submit response button.  In the button's OnSelect property you would use a REMOVE function to delete the record from your collection while at the same time using PATCH to update the record in your SP List.  Give this idea a try and let me know what questions you have.

Remove function docs by MS:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-remove-removeif

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[patty789]

@mdevaney I was wondering if doing a filter will work on this scenario. 

[mdevaney]

I had not thought of using FILTER but yes that could also work. You would still need to create a collection but the purpose would now be to hold the ID of any edited records. Your gallery items property would look like this

Filter(your_datasource_name, Not(ID in edited_id_collection))

Of course, you would need to COLLECT the ID into a single column collection when the user clicks the button to submit changes.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[Anonymous]

@patty789 you could add a 'Helper Column' into your SP datasource, call it RecordEdited. This column's default could just be blank.

Then as per @mdevaney recommendation's pull your SP data into a collection and set the Data Table to this collection.

Filter this collection to only show blanks in the column RecordEdited. Then, once a user updates the selected record, change the RecordEdited column to "Yes" and the Data Table should be filtered as per your needs.

One the good things about this approach is that the updated record/s Patch back to your SP data source will be easy because the schemas of the collection and SP match exactly.

Hope this helps