I am trying to set up a Zap which pulls data from Clio into an Excel Spreadsheet which is located in a Business Group OneDrive or Sharepoint online. I have no issue pulling the data from Clio and can push it into a Google Sheet or an Excel spreadsheet on a personal (not shared) onedrive. But I don’t seem to find the way to access the group onedrive folders to be able to push there. Any help appreciated.
Best answer by Matt_Boyden
View original
Another vote for this capability.
We use Teams extensively and having access to the
<TEAM>/Documents/Folder would be extremely beneficial.
for sure we can work around it by sharing a folder in a personal OneDrive directory but that isn’t optimal.
Hello! I would share a workaround that one of our customers was able to use successfully to get around this limitation, in case it’s helpful for you all.
They used Microsoft's Power Automate's template to copy a shared file to their own account. Here is a screenshot of how they configured the template: 
This copies the file from Sharepoint locally, but does it go the other way?
Hi, my name is Elizabeth Snowdon. I’m a user researcher at Zapier. We want to talk to Zapier customers who are also evaluating or using Make/Integromat. This research will enable us to discover opportunities to improve Zapier’s core workflow.
Fill out the short survey below, and if you’re qualified, we will contact you to schedule a 30-minute interview. Those scheduled for an interview will be provided a gift card for your time.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
