Refresh Datatables

(0) Share

Report

Posted on by Dhiran

143

Hi,

I have a screen where I have 2 buttons which set the value of a variable (filterValue) to a text string. I also have a dat table which filters the data source based on the filterValue but it does not seem to update when I click on the either button.

Is there a way to refersh the data table on the click of the button.

Dhiran

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... on at

Like (0)

Report

If the DataTable is connected to a SP list you can Always perform a Refresh(SpListName) on a Behavior formula like OnSelect of a button

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @Dhiran,

Could you please share more details about the Items proeprty of the Data Table control?

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Set the OnSelect property of the "Available" button to following:

Set(filterValue, "Site Services - Available")

Set the OnSelect property of the "Lost/Stolen" button to following:

Set(filterValue, "Lost/Stolen")

Set the Items property of the Data Table control to following:

Filter('20181204_case5', 'Location/Status'.Value = filterValue) /* <-- 20181204_case5 represents my SP list data source*/

The GIF screeshot as below:

Please check if you have set proper value for the filterValue variable. Also please check if you have typed proper filter condition within your filter formula.

In addition, you could also consider take a try with the following workaround:

Set the OnSelect property of your first button to following:

ClearCollect(
FilteredResult,
Filter('YourDataSource', ColumnName="TextString1")
)

Set the OnSelect proeprty of your second button to following:

ClearCollect( FilteredResult, Filter('YourDataSource', ColumnName="TextString2") )

Set the Items property of the Data Table control to following:

FilteredResult

Best regards,

Kris

Was this reply helpful? Yes No
Dhiran 143 on at

Like (0)

Report

Thank you for the detailed response. I believe you can only get the refresh to work after you add the Clearcollect statement to the buttons?

Was this reply helpful? Yes No