Unanswered

Data Table Operations in PAD - Filter, Sort, Conditions

(0) Share

Report

Posted on by Abisheck_Canary

Data table operations – Do we have options like sort, filters, multiple filters, Filter with Queries? without using SQL any other ways to achieve this one.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

There are no native actions to do that in PAD, but you can use Run .NET script to do it.

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

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Abisheck_Canary 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick response!!! Can you suggest me some useful links for that too, it'll be helpful.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not a C# / .NET developer. I just know from peers that it's possible to do it via C# scripts, but have never implemented it myself. This thread explains how to add a column into a table using a C# script: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/How-to-add-a-column-into-a-variable-table/m-p/2312720

I'm quite sure there aren't many resources about using C# in PAD yet, as this is a very new feature. If you want to find a tutorial on how to do a specific task (like filtering a table) in C#, you should not look for tutorials on how to do it in PAD, as you won't find anything. You just need to search for tutorials on how to do it in plain C#.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No