Selected Row refreshed after update the DataTable

[Anonymous]

Hi I am building a powerapps tablet which is able to create, edit, update and delete record. However, I met a problem that when I modify an item the details page will change to the default selected row.

For example, is when I select "Row 2" and go to view the detailScreen of "Row 2" then I proceed to the editScreen of "Row 2". After I submit the form, the detailScreen will changed to "Row 1" which is the default selection. The "Item" in my DetailForm is

DataTabel1.Selected

Thank you.

[Ramole]

Hi @Anonymous 

Check this it will help you also there is sample app Power Apps Reusable Forms 

[Anonymous]

I found that when I put this code 

InitiativeNameTxt.Text in 'Initiative Name'

 into

SortByColumns(Filter([@ProjectListing], (IsBlank(InitiativeNameTxt.Text) || IsEmpty(InitiativeNameTxt.Text) || InitiativeNameTxt.Text in 'Initiative Name') && (IsBlank(ValueDropDown.Selected) || IsEmpty(ValueDropDown.Selected) || 'Project Owner'.DisplayName = ValueDropDown.Selected.DisplayName)), "ID")

without the line of code it would have no problems which the dataTable would not default refresh and select the first row.

[Ramole]

Hi @Anonymous 

Why not use a gallery has more functionality 

[Ramole]

@Anonymous 

Capabilities

Now available

• Data in a Data table control is read-only.
• A single row is always selected in a Data table control.
• Link a Data table control to a connected or local data source.
• Adjust column widths in a Data table control while you run the app, though your changes aren't saved.
• A set of default fields appear in a Data table control when you link it to a connector that has implemented this capability, such as the Microsoft Dataverse. You can then show or hide these fields and others as necessary.
• Customize column width and heading text.
• Show hyperlinks in a Data table control.
• Copy and paste a Data table control.

Not yet available

• Customize the styling of individual columns.
• Add a Data table control in a form control.
• Change the height of all rows.
• Show images in a Data table control.
• Show fields from related tables.
• Use built-in functionality to filter and sort data by column heading.
• Add a Data table control in a Gallery control.
• Edit data in the Data table control.
• Select multiple rows.

Known issues

• No data appears if you use the FirstN function in the Items property.

data table per the official MS Documentation. 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-data-table 

[Anonymous]

I had tried gallery before but I met an issue of duplication data while search because there exists some null value in my data. I have also post the issue on the community as you can referred here.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Duplication-using-Filter-and-Patch-function/... 

[Ramole]

Hi @Anonymous 

I have posted a replay please check it 

[JasonSmithTBS]

I'm seeing this behavior with a change I made recently too. Previously the data table's data source was an unfiltered SharePoint list and after a data change was known to occur the application would call a Refresh('DataSourceList') and the data table would update but not change the selected item.

No, with a change to the data table's data source to be a filtered and added columns (calculated fields with data from another source list) when the data changes and the Refresh('DataSourceList') is called the data table updates as expected but now resets the selected (highlighted) row to the be the first row. When this happens, it does not run the OnSelect of any columns in that row which adds a complication to my application as other parts aren't updated as they would be if the user selected a specific row with a mouce click.

Has anyone else experienced this behavior and come up with a remedy?