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

Uploading collection to excel file on sharepoint

Currently have an a bar code scanner collection that sends the collection and its fields to a SharePoint List. 

 

The problem I am running into is the SharePoint list is not really searchable without scrolling to around the date range. Is it possible to have this information uploaded to an Excel File in a document library on SharePoint? 

 

My current string code:

ForAll(CollectMultiScanAmazon, Patch(PTA, Defaults(PTA), { Title: ThisItem.DisplayName, Who:User().FullName, When: Now(), TN: BarCodeInfo, Company:"Amazon"}));Reset(TextInput1_3);Clear(CollectMultiScanAmazon);Navigate(Success)

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Uploading collection to excel file on sharepoint

@JukeNuke 

It is not supported to take Sharepoint document as the data source currently. PowerApps just supports connect to Excel files on OneDrive for businesses.

The feature you want is in the plan, please check this idea: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Sharepoint-Folder-as-datasource/idi-p/24112 

Sik

 

Highlighted
Regular Visitor

Re: Uploading collection to excel file on sharepoint

You can covert your output to a JSON in Powerapps then send it to a Flow which can interpret the JSON and build a CSV from the input and save in a doc library...

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,440)