Export SharePoint list but not all rows.

[TimoMigchielsen]

Hello!

I basically want to export a SharePoint list but only there rows where Status (column) is equal to "Vrijgegeven". How can I do this?

Database looks like this: https://gyazo.com/7cc354bcd5069b02f3e28270c25f1a0b

[mdevaney]

@TimoMigchielsen 
Do you know how to create a SharePoint List 'View'?

Create a new view with a filter on only rows having the status 'Vrijgegeven' then click the Export to Excel button (in SharePoint).  I assume you are OK to do this manually outside the PowerApp.

If the app must do the export, it would have to be accomplished in Power Automate.  Here's a link to that forum: 
https://powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[TimoMigchielsen]

Thank you for your answer. Is there a way to change the whole column to the same value?

So what if I filter on the status "Vrijgegeven" and want this value to be changed into "Gemonteerd" for all values? @mdevaney  

[TimoMigchielsen]

I basically need to do both. I need to export all the rows that have the Status "Vrijgegeven" and then I need to change all these rows from "Vrijgegeven" to "Gemonteerd". How can I do this?

[mdevaney]

@TimoMigchielsen 
In SharePoint:

• Filter the table on Status Vrijgegeven
• Click the Quick Edit button in SharePoint
• Write the new value Gemonteerd in one cell
• Copy and paste to the rest
  
  

Simple + Effective 🙂

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[TimoMigchielsen]

Okay, so there is no way to do all rows at once? 

And how can I only export the rows that have status as vrijgegeven?

@mdevaney