How to extract filtered data from Edit Grid to Excel for UiPath Apps ? Since there is no direct way, has anyone done this ?

@tilarapiyush this is how you can do..a sample implementation initialize a datatable on page load of main, chnage columns as needed BuildDataTable(New DataTable(String.Empty), New DataColumn() { New DataColumn("Name", GetType(String)), New DataColumn("Email", GetType(String)), New DataColumn("Typ…

Hi @tilarapiyush There’s no direct method to export filtered Edit Grid data to Excel in UiPath Apps. Find below link, [image] How to extract data from Edit Grid to Excel Apps @hgaber105 This scenario is not directly supported using search feature on EditGrid. It can be…

There is no Data Source option in Text Box. Not sure how to proceed on this solution. [This image shows a development dashboard interface with fields for attachment details and customizable text input settings. (Captioned by AI)]

@tilarapiyush What is mentioned above is not to use datasource in text box Basically the filtering in edit grid is done via the search text box..but as the value of the search text box could not be extracted..we use a separate text box instead of search and add the expression to filter the grid an…

Getting error on this. <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/5/e/0/5e0b070494f2d433bd6206cf49cf0fa561ab7fb6.png" data-download-href="/uploads/short-url/dpWvw5koJEjuXnZURZpW7SrskU6.png?dl=1" title="The image shows a configuration interface with an error message indicating that 'CopyToDataTable' is not a member of 'IEnumerable(Of ChemistryOrders)', suggesting an incorrect method usage in the expression editor. (Captioned by AI)">[The image shows a configuration interface with an error message indicating that 'CopyToDataTable' is not a member of 'IEnumerable(Of ChemistryOrders)', suggesting an incorrect method usage in the expression editor. (Captioned by AI)]

@tilarapiyush [image] Anil_G: we use a separate text box instead of search and add the expression to filter the grid and also at the same time the same expression can be used to send to process and save as excel edit grid datasource will give full data again not filtered data..you need to fi…

Is it possible for user to select the filter criteria dynamically and that filter to be passed to process?

@tilarapiyush Yes with the use of textbox the filter criteria would be dynamic only and based on the textbox Cheers

Thanx for this clarification Anil. I was able to resolve this. However, I am trying to download the filtered results by enabling a RPA process in background but when I use the same AND condition with 4 filters and any of the filter values comes in as blank (not filled in app output), no entity reco…

@tilarapiyush glad you were able to resolve Now coming to next one could you please elaborate or show some screenshots to understand it cheers

I have 4 filters which user will update depending on their requirement. Somtime they may update 2 of these, sometimes 3 and so on. It has to be an AND condition. But when any of these field value is null (not filled by user), data service is not fetching any records. However in Apps this is not he …

How to extract filtered data from Edit Grid to Excel in UiPath Apps

Help Apps

prashant1603765 (Prashant Kumar) May 15, 2025, 1:38pm 2

Hi @tilarapiyush

There’s no direct method to export filtered Edit Grid data to Excel in UiPath Apps.

Find below link,

Happy Automation!

Topic		Replies	Views
How to extract data from Edit Grid to Excel Apps excel , apps	8	378	May 15, 2025
Extract Data from excel after Apply Filter Help datatable , excel	3	3683	October 29, 2018
Create an excel from datatable by applying few filters Help studio	3	1114	July 24, 2019
Extract filter data from excel Studio excel , studio , question	6	1245	September 30, 2021
Need to download data in CSV after filtering data in edit grid Apps question , apps	0	41	January 14, 2025

How to extract filtered data from Edit Grid to Excel in UiPath Apps

Related topics