I am running Sharepoint Online and have a question about Export to Excel using a workflow.
I currently have an Approval workflow that is initiated when the user fills out their web form. I want to be able to export this data to an excel spreadsheet once the request is approved.
I can't seem to find anything on how to do this, there are tons of Export Custom List to Excel questions online but none that seem to actually address my issue.
Please let me know if you have any clarifying questions!
I've used the "Export to Excel" feature to create a data connection. That will work for getting the information into excel but once the data is there I will need one last user to change a field from "New" to "Complete" on every field that says new on the list. Is there a way to workflow changes to multiple data list entries at once?