Advanced Power Apps File Uploads - Create folders and set metadata

Are you ready to take your Power Apps file uploads to the next level? In this comprehensive tutorial, we dive deep into advanced techniques for handling file uploads in Power Apps. Learn how to:

✅ Handle dynamic folder names
✅ Check if a folder exists
✅ Set metadata (e.g., project numbers)
✅ Restrict uploads to specific file types
✅ Manipulate file names

Overview of advanced file upload features in Power Apps.
Explanation of the problems and support questions this video addresses.
Demo: Building the Solution

Step-by-step demonstration of creating a dynamic folder name.
Setting project numbers and choosing file types.
Real-time validation and error handling for unsupported file types.
Power Automate Integration

Creating and configuring a flow in Power Automate to handle file uploads.
Setting up dynamic folder paths and handling file creation in SharePoint.
Updating file properties with metadata.
Practical Tips and Tricks

Manipulating file names to remove spaces and special characters.
Ensuring folders are created only when necessary.
Returning links to uploaded files and resetting the upload control.
Advanced Logic

Using conditional logic to allow only specific file types.
Handling empty input fields to prevent errors.
Combining multiple conditions for robust error handling.
Real-World Applications

Examples of how these techniques can be used in real-world projects.
Tips for optimizing your Power Apps and Power Automate workflows.

Up your Power Apps Skills Today!

0:00 Advanced Uploads with Power Apps and Automate
0:31 Demo of the abilities
1:45 Create the app
2:50 Create the flow to upload files and images
6:54 Understanding Create New Folder action
7:24 Updating OnAddFile
9:59 Returning a link to the file with Respond to a Power App or flow
12:50 Making a clickable link from the Label using Launch
13:59 Getting the file extension with Match
14:44 Substitute to fix up file names
17:19 Other considerations

Do you need some help with something that you are working on, contact us!

PowerApps911

Let's connect on social!

Join this channel to get access to perks:

#powerapps #PowerPlatform #CanvasApps #powerautomate #sharepoint

[jefflund]

Nice video. The only thing I question is the extended "If" logic with the blank "Project Number". Why not set the DisplayMode of the File Upload control to "Display" when either condition is blank, and "Edit" when both are not? That way, they could not select a file until the required information is already entered, and it simplifies the logic in the addfile routine.

[alexandermcmurrin]

Hey Shane - I have a question on storage solutions for uploads. Which is better using Dataverse to store documents (PDF's, TIF's, etc) as an attachment or using Sharepoint? I love your videos they have meant the world to me in my quest to become a better powerapps developer. You are always at the top of my feed to watch. Thank you for all that you do and share with the community.

[douglasnoble]

Thanks, your videos have really helped my understanding of Power Apps. Is there any way of sending multiple person records to a Person or Group field as meta data fields when uploading a file in sharepoint using flow? I've previously done it with patch?

[facun_OK]

Thanks for this amazing video! I have a question... Has anyone tested the attachment control related to how many files and size can be uploaded to a library at once?

[josecarlosbenitezmeyer]

Amazing Video,
Is it possible to check how many items are in a folder and if the quantity of items its the same doesnt let the user save a form? And is it possible to check a folder inside a folder for the same reasons?

Thanks Shane you have help me severous times!

[janicemendoza]

Great content as always! I have a question. I have a toggle button before attaching the files. When toggle is on, create the folder / file on this SP folder. If toggle is off then create it on this other SP folder. Sounds simple but not sure how to incorporate in the flow. Appreciate your help Shane! :)

[spen]

Nice one. Saved/Bookmarked for reference in the future. As always, thanks for sharing Shane. 💥💥

[dougydoe]

Great video. I really enjoyed that and picked up a number of tips. Thanks

[LaurenBolin]

Will this also work with multiple -file uploads? Excellent video.

[devisettychandu]

Hi Raza Dorrani, I want the document library app that you showed in the last video ending. Is there any way to get that app, or do you have a link to share with me? It would be helpful to me.

[temidayolonge]

Great Shane. Nice touch on Buddy Pics😂

[TeslaZx]

Shane thank you for this video, May I ask, I want to use a toggle button in Power Apps to upload an attachment to an Attachments element before sending an email, so I don't have to upload it every time. How can I do this?

[NKBobcat]

I developed an app that needs access to upload files to a SharePoint document library, in a folder with the ID of the form as the folder name. I created the record and then navigate to a popup like screen with a button that kicks off a flow to create the folder. I used to create the folder on the creation of the form record, but the customer didn't want to have to reopen the form to upload files. I will watch this and hopefully just navigate them to an upload screen post form creation. Until now, I had a hard time uploading to a folder using the form ID as the name.

[usamapowerplatform]

Is there any way we can get excel sheet in power automate for comparing the headers value for two different sheets without being formatted as table?

[YurNmsis]

Is there a way to get internal file metadata of uploaded files? The use case I’m looking for is for PDF files to get internal file metadata to understand if the file was modified after creation

[maksimdmitrenko]

Hello! At 18:14 we can see a new green icon "+" (not Paper clip). How did you change the icon?

[pabeader]

Could you do a video showing how to do this using OneDrive for Business storage? I'm trying to duplicate the same thing that the Site Inspection template app does. I've been trying to understand this for about 2 weeks and I just can't figure out how it's doing it. The app uses a folder in OneDrive to hold the pictures and an Excel file to store the path to the pictures. This is my white whale. As far as I can tell, it does not use Power Automate or a Flow.

[AMindGame]

Is there a way to make the file automatically save to my split when a user add a file as file attachement, where they won't have to click Save/Submit?

[THEDTSMAN]

:( I so wanted this to include some clever stuff for creating folders in an on premise environment :(


aka file system "create folder"

[MachineMirth]

Interacting with files desperately needs a revamp. Using power automate to upload files is not ideal. Once a file is uploaded, we should have a way to rename them within the power app. We have a solution where users need to change the date embedded in the file name, but we want to keep the file uploaded date to stay the same. There are so many features lacking. Licensing also really needs to be a lot easier. As much as this is all good, we would be satiated by having more robust features when it comes to files. Thanks for sharing this info, it’s great but I can’t wait to see Microsoft make some really useful changes.