Sharepoint get list with condition

Hi friends

I need to get list from Sharepoint where the status is " Open " and process it , and finally update the status to “Completed” .
do you have any idea to achieve it. We have "get list " activity. but its not getting the list with this status. and i dont know how to update the status


You can use DataScrapping to extract the records to a datatable

After that check the selector for Update and make it dynamic and check how it is changing to row by row

Accordingly you can write your logic that check whether the row is submitted then click on update

Its a basic help you can try

Hope this helps you