cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to connect to Dropbox (or FTP) in Powerapps without specifying excel file

I am trying to create a PowerApp that consolidates information from a number of sources (Facebook, Twitter, a Dropbox folder and an FTP folder).

 

I can make connections to all four within Powerapps environment, but when I add them as datasources to a Powerapp the Dropbox and FTP ones insist on me specifying an Excel file to link to. I don't  want to link to an Excel file - I just want to use the "get files in folder" functions.

 

I feel like I am missing something basic here. I have worked out I could create a flow to do this, concatenate the file list and pass back to PowerApps ti deconcatenate but that seems like a long way around.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to connect to Dropbox (or FTP) in Powerapps without specifying excel file

Hi @mstavers ,

Do you want to use the "Get files in folder" action of Dropbox connector within your app?

 

Based on the issue that you mentioned, I think you have some misunderstanding on the data source types in PowerApps.

Currently, within PowerApps, there are two types of data source -- Tabular data source (e.g. SP list, SQL Table, etc) & Action data source (e.g. Office 365, Azure, etc). The Dropbox connector is a Tabular data source within PowerApps. When you connect to a Tabular data source from an app, you would be prompted to select a specific table to connect to.

More details about the data source types in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list

 

If you want to use the "Get files in folder" action of Dropbox, I think the Microsoft Flow could achieve your needs. You could consider fire a flow from your app, then return proper values from your flow back to your app.

More details about returning data back to an app from a flow, please check and see if the following blogs would help in your scenario:

https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

More detials about firing a flow from an app, please check if the following video would help in your scenario:

https://www.youtube.com/watch?v=1wl9AtxWdkg

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted

Re: How to connect to Dropbox (or FTP) in Powerapps without specifying excel file

Hello mstavers,

 

I think you should create a Flow that uses the Dropbox connector to get list of files.

 

2019-04-19_04-41-21.jpg

Highlighted
Community Support
Community Support

Re: How to connect to Dropbox (or FTP) in Powerapps without specifying excel file

Hi @mstavers ,

Do you want to use the "Get files in folder" action of Dropbox connector within your app?

 

Based on the issue that you mentioned, I think you have some misunderstanding on the data source types in PowerApps.

Currently, within PowerApps, there are two types of data source -- Tabular data source (e.g. SP list, SQL Table, etc) & Action data source (e.g. Office 365, Azure, etc). The Dropbox connector is a Tabular data source within PowerApps. When you connect to a Tabular data source from an app, you would be prompted to select a specific table to connect to.

More details about the data source types in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections-list

 

If you want to use the "Get files in folder" action of Dropbox, I think the Microsoft Flow could achieve your needs. You could consider fire a flow from your app, then return proper values from your flow back to your app.

More details about returning data back to an app from a flow, please check and see if the following blogs would help in your scenario:

https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

More detials about firing a flow from an app, please check if the following video would help in your scenario:

https://www.youtube.com/watch?v=1wl9AtxWdkg

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,211)