Submission of Large Data

(2) Share

Report

Posted on by MS.Ragavendar

5,017 Super User 2025 Season 2

@Michael E. Gernaey / @mmbr1606 / @WarrenBelz / @w.p,

I would like to upload the data to the datasource as of consider sharepoint (azure blob storage are greyed out).

The challenge is the volume of data will varies from kb to gb (max 15 gb), I also know there is a limit in the file storage options and time out.

Solution which i thought

Create a folder from powerapps and navigate to the screen (using iframe control) the respective sharepoint page will open.
They can upload the file directly to the respective folder.
Once uploaded, update some of the parameters as per requirement.

SharePoint users shouldn't navigate to the respective page and modify something might messup.

I am looking for expert suggestions how effective this can be achieved.

Thanks

Raghav

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Jon Unzueta 1,827 Super User 2025 Season 2 on at

Like (1)

Report
@MS.Ragavendar

Thanks for the detailed explanation, Raghav! You're tackling a common challenge in Power Platform scenarios involving large file uploads and controlled data ingestion. Here's a breakdown of your proposed solution and some expert suggestions to make it more robust and scalable:

✅ Your Proposed Solution (Reviewed)
✔️ Steps

Create a folder in SharePoint from PowerApps.

Navigate to the folder using an iframe to allow users to upload files.

Update metadata or parameters after upload.

⚠️ Concerns

User navigation risk: Users might modify or delete files unintentionally.

Scalability: SharePoint has file size limits (typically 250 MB per file via PowerApps, up to 15 GB via browser).

Timeouts: PowerApps and Power Automate have execution time limits that may affect large file processing.

🧠 Expert Suggestions
🔹 1. Use SharePoint Document Library with Metadata

Create a dedicated document library with custom metadata columns (e.g., status, uploader, type).

Use PowerApps to:

Upload files via the Attach file control.

Set metadata using Patch or Power Automate.

Use permissions to restrict access to folders or metadata editing.

🔹 2. Use Power Automate for Post-Upload Processing

Trigger a flow when a file is created or modified in the SharePoint folder.

Actions:

Validate file type/size.

Extract metadata or content.

Move to another folder or archive.

Update Dataverse or send notifications.

🔹 3. Use Azure Logic Apps for Large Files

If file size exceeds Power Automate limits, consider Azure Logic Apps with SharePoint connectors.

Logic Apps handle larger payloads and offer better control over retries and timeouts.

🔹 4. Use OneDrive for Business as an Intermediate

Users upload to OneDrive → Power Automate moves file to SharePoint → triggers processing.

This can reduce risk of direct SharePoint manipulation.

🔐 Security & Governance Tips

Use SharePoint permissions to restrict folder access.

Enable versioning to prevent accidental overwrites.

Use audit logs to track uploads and changes.

🧩 Optional Enhancements

Add a status dashboard in PowerApps to show upload progress or errors.

Use Dataverse to store metadata and link to SharePoint files.

Implement file validation logic (e.g., file type, naming convention) before processing.

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MS.Ragavendar

For the love of Vanilla Cake, do NOT try to use the Attachment control for 15 gig files. That is... nuts.

Can you please tell us where are the files starting out? In your Local Drive? In OneDrive Business? Just seeing what options we can do that do not require doing something completely silly.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

Hi @MS.Ragavendar,

Responding as you tagged me.

Also a thought on ChatGPT generated posts as below, at least put them in your words and only include the bits relevant to the question - it continually confuses everyone sorting out what (if any) bits to read.

I will only add further the @Michael E. Gernaey statement is highly relevent - you are not going to store files over 250mb in SharePoint or over 100mb using Power Apps as the medium.

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,017 Super User 2025 Season 2 on at

Like (0)

Report

@Michael E. Gernaey,

Can you please tell us where are the files starting out? In your Local Drive? In OneDrive Business? Just seeing what options we can do that do not require doing something completely silly.

The files will be available in the local drive of the users (98%) and Executives (2%) will be using the one drive.

Was this reply helpful? Yes No