Mar 02, 2023 04:21 PM
I am supposed to create an app in Power App. My data source is Airtable. Therefore I want to export the csv file from AIrtable to SharePoint or Excel Online automatically on daily basis. Kindly let me know whether this is possible and documentation related to this
Mar 03, 2023 04:58 AM
This is very easy using Make.com, where you can use their CSV modules, their Excel modules, their SharePoint modules, etc.
if you’ve never used Make before, I’ve created a video of some basic navigational tips here, with more tips to come in the future. Post any questions over there, where there are several Make experts onhand.
Mar 06, 2023 12:20 AM
I am not allowed to use any third party tool..
Thanks for ur response
Sep 19, 2023 06:47 AM
For those who are ok using a third party tool - I have built csvgetter.com.
The app allows you to create the export links needed to complete a lot of export proceeses like this, and is secure, powerful and flexible.
Here are a couple of step by step guides for the above case:
Airtable export to Excel (Windows / sharepoint)
Airtable export to Excel (MacOS)
For any questions about how the app stores data and thinks about security and privacy - hit me up!