Possible to save attachments in OneDrive data source when app owner is Gmail?

[GreenFlux]

I know you can connect multiple data sources and use sheets from different providers, but what about mixing up the attachment archive folder?

The Workflow/Report attachment path is relative to the default app folder, so you can only work within that root directory.

And the app’s default app folder seems to also be limited to the data source that app owner uses to log in.

My app owner logs in with Gmail, but I want to save attachments in a OneDrive folder. The OneDrive account has been added as a data source, but it seems that feature is limited to where sheets and email templates are stored-- but not the actual PDFs produced by the templates!

Does anyone know if this is possible using native AppSheet features? I have some other ideas involving GAS, Microsoft Flow or Zappier. Just want to make sure I’m not missing some built-in way to do this in AppSheet.

@Aleksi, @Steve, @LeventK, @MultiTech_Visions, @Fabian, any ideas?

[Aleksi · Accepted solution]

Unfortunately that’s correct, you can save files only to your main data source at this moment.

[GreenFlux]

Bummer. Thanks for confirming, though.

I think I’m just going to cc an Office365 email and use MS Flow to save attachments to OneDrive.

[Martina_Barnett]

Hi Aleksi
Apologies if this is the wrong train to comment like this on, please feel free to redirect where applicable.
I have an app based on SmartSheet data. I have my word templates in Google Drive and the attachments generated by reports from these templates are saved nicely in the Google Drive folder.
My company is moving away from Google Drive and onto One Drive.
I’ve tried to set up the same send and archive routines using OneDrive and it’s not working. The emails are being sent, but not saved.
How do I set that up properly? Are there and ‘gotchas’ for OneDrive that isn’t there for Google Drive?
Many thanks
Martina

[Shaun_Stringer]

Hi Aleski. Is this still true?

If my main data source is a GSheet in Google Drive, am I able to add a OneDrive account simply to store PDF attachments and photos in that are generated by the app?

I am trying to avoid switching fully to Office365 due to some of the app functionality issues associated with running the apps through Microsoft. Unless those no longer exist either??

As always, thanks for your help.

[SkrOYC]

Custom folder path for a copy of files from bots and form uploads Feature Requests

Hi everyone! My client wants the app to put a copy of the file that’s uploaded to be saved on the company’s cloud storage. This should also apply to the files made through bots/workflows/reports. I know that files made through bots are saved to the “Default app folder” under Info → Properties. I also know that there is a security measure in order to prevent someone having access to the cloud storage where the app is located to delete a file that was uploaded through a form. This would break t…

[Steve]

Shaun_Stringer:

If my main data source is a GSheet in Google Drive, am I able to add a OneDrive account simply to store PDF attachments and photos in that are generated by the app?

Nope.

[Shaun_Stringer]

Thanks for the confirmation, Steve.

Any update relating to using OneDrive and Excel as the main data source? The main issue I came across on Appsheet’s support article is that if any linked excel spreadsheet is open anywhere, the app will not be usable until it is closed. If this is correct, is it likely to remain this way for the foreseeable future?

This is not an issue for me at this time. I just want to make sure my information is correct.

[Steve]

To the best of my knowledge, your understanding is correct. I am unaware of any impending change to that.

[okushi_david]

Hello Steve,
My apps data source are from the onedrive, but my appsheet login is a google account, i have my workflow attachments saved to the default google drive folder, but when i try to open from the app it says the file path may have been moved, deleted or changed, is it possible to change my workflow attachment file path to a onedrive folder and be able to view the file from the app, or is there a reason or another fix to why it says file path may have been moved or deleted

[Steve]

okushi_david:

is it possible to change my workflow attachment file path to a onedrive folder

No, as I already said.

okushi_david:

is there a reason or another fix to why it says file path may have been moved or deleted

Perhaps because the file doesn’t exist within the path you supplied?

[okushi_david]

The file exists in the file path specified

Above is the file path on the data source

Above is the file in that path on my google drive

[Steve]

How are you trying to open the file from the app?

[okushi_david]

I have a file column with the source

Then i have an automated document creation for the file that creates the file and sets the value for that column

Then i have an open an external file action on the app

[Aleksi]

It sounds your main account is still Google, correct?

[Martina_Barnett]

Hi Aleksi
Apologies. I only saw your reply now. No, the main account is now Office365 and the company is closing all access to the google account soon.
Many thanks
Martina