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