cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hetvik
Helper I
Helper I

Filter unwanted columns from List Rows Action - Dataverse CDS

Hi All

 

I would like to remove unwanted columns from the result set of List Rows action from dataverse(cds).

1.  I am using List rows action to get the data from dataverse with dynamic filter criteria. -

 

Capture.PNG

 

2. Once I got the results I am passing in the list of columns to be deleted to flow
Capture.PNG

3. Here I would like to loop through the result set and delete the columns based on the array of column names sent in above step(2)
can anyone please let me know how to do this.

 

2 REPLIES 2
Mira_Ghaly
Dual Super User II
Dual Super User II

@Hetvik 

If you want to remove specific columns from the List rows you can alternatively use the  Select Data Operation to select only the columns that you need as below:

Mira_Ghaly_0-1618790773684.png

Let me know if this makes sense!

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi Mira

I can't use select because as my columns are not fixed . I would get the columns to be deleted at runtime.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,854)