Filter Datatable - Memory Usage Spike up

(1) Share

Report

Posted on by WN-06111524-0

Hi community,

I am facing an issue with filter datatable action. The datatable contains 140K+ rows with 10 columns. Reading datatable process was complete successfully however filtering it takes more memory usage than reading it.

is there any alternatives to filter this datatable without consuming a lot of memory?

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

trice602 16,397 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Move this upstream, meaning I recommend doing this filter on a large dataset in Dataverse. So use Dataflows and send your raw dataset this, filter it there, exactly as you are in your condition, then send the results to a Dataverse table. Then connect to your table in your PAD and #keepgoing.

Think upstream. #bestpractice

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 16,397 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post filter datatable - memory usage spike up in this category power automate desktop from 11/06/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,397 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No