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.
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?
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.
@@ShanesCows I'm developing my project using dataverse and the expense side isn't the main concern. I'm shooting for something that is a document management solution for our AP / AR system so parties with buy in to the documents can view documents on the fly for approvals or general information. So i wasn't sure which solution would be more responsive and allow for dynamic uses down the road. Think attaching proof of receipt to invoices when we invoice customers.
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.
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?
Yes, it is the very similiar. Go to flow, add the multi-person field to the action and manually configure it. Then look at the Code view. It will show you what it needs. Then you need to send the info over in that format so you can plug it in. :)
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! :)
Oh I figured out a workaround by creating 2 flows and using value of toggle to set visibility of flows! :) I have another question...if I want to share the folder link instead of the file link? How can that be achieved? Thank you!
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?
@@ShanesCows sorry shane for my bad English, "I have a predefined email directly in PA that sometimes needs to include a PDF file 'Doc1'. I want to have a toggle next to it that attaches the file when pressed, so the end user doesn't have to upload the file each time."
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!
Yes. The best I can offer to help is this video where I built a document library explorer. You will see how I dealt with folders. th-cam.com/video/u-b8w9ea1kk/w-d-xo.html
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
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.
Yes, I show it in this video th-cam.com/video/cjcDH7_v6cE/w-d-xo.html The key is you put the code you ahve in the Save button in the OnFileAdd property of the attachment control
@@radhikaseetharaman1772 if I under stand what your asking yes. This is the code I have in my on select button that I would like for it to activate on. I’m and getting errors on Last(FILE).Value & Last(FILE).Name & Reset(Self) ForAll(Attachmen_1_DatacardValue_4.Attachments As FILE, CARAttachmentFlow.Run( inpFN.Text, InpPN.Text, { file:{ contentBytes:Last(FILE).Value, name: Last(FILE).Name } } )); Reset(Self);
@@radhikaseetharaman1772 Remove the word "Last" and the brackets around "FILE", so that part of your formula will read like this: contentBytes:FILE.Value, name:FILE.Name
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.
@@ShanesCows That's useful info but I'm not sure how it applies to my question. Are you thinking that the image is being stored in the excel file?? Thanks for the quick reply!!!!
@@ShanesCows Theres no specific file system function for "Create Folder" when writing to an on-prem network via the gateway. Kinda annoying. I did some digging around and cannot see a work around at all. The path is the final destination so you cant even tag a folder into the path. C:\My Folder\FolderName\FolderPath
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.
@MachineMirth - FYI: You don’t need to use a flow to upload to SharePoint docs library. You may have known that already. This is just another way of doing it, which looks pretty nice. Thanks Shane!
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.
I don't hate that Jeff. 🤩 The fun of Power Apps, there is usually 10 ways to do everything.
Nice one. Saved/Bookmarked for reference in the future. As always, thanks for sharing Shane. 💥💥
You bet!
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?
Great video. I really enjoyed that and picked up a number of tips. Thanks
Glad it was helpful!
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.
I think it is easier and cheaper to store them in SharePoint. :) Of course depends on exactly what you are building but that is where I start from.
@@ShanesCows I'm developing my project using dataverse and the expense side isn't the main concern. I'm shooting for something that is a document management solution for our AP / AR system so parties with buy in to the documents can view documents on the fly for approvals or general information. So i wasn't sure which solution would be more responsive and allow for dynamic uses down the road. Think attaching proof of receipt to invoices when we invoice customers.
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.
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?
Yes, it is the very similiar. Go to flow, add the multi-person field to the action and manually configure it. Then look at the Code view. It will show you what it needs. Then you need to send the info over in that format so you can plug it in. :)
@@ShanesCows Thanks for the speedy response, I will give it a try. As you say - It keeps getting angry at me!! :)
Great Shane. Nice touch on Buddy Pics😂
Thanks! Always like to sneak in the dog 🐶
Thank you Shane
Happy to help. Have a great week!
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! :)
Oh I figured out a workaround by creating 2 flows and using value of toggle to set visibility of flows! :) I have another question...if I want to share the folder link instead of the file link? How can that be achieved? Thank you!
Love it. Good job
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?
Sorry, I am not following. Can you try explaining again?
@@ShanesCows sorry shane for my bad English, "I have a predefined email directly in PA that sometimes needs to include a PDF file 'Doc1'. I want to have a toggle next to it that attaches the file when pressed, so the end user doesn't have to upload the file each time."
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!
Yes. The best I can offer to help is this video where I built a document library explorer. You will see how I dealt with folders. th-cam.com/video/u-b8w9ea1kk/w-d-xo.html
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
Maybe, but I have never done it or tried, so I don't know.
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?
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.
Hopefully this gets you everything you need. 😎
@ShanesCows It does. I am very happy. Thanks, Shane!
Hello! At 18:14 we can see a new green icon "+" (not Paper clip). How did you change the icon?
It is an Icon on top of an invisible paper clip. I show doing that in this video I am pretty sure. th-cam.com/video/cjcDH7_v6cE/w-d-xo.html
Helpful 🎉
Glad it was helpful!
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?
Yes, I show it in this video th-cam.com/video/cjcDH7_v6cE/w-d-xo.html
The key is you put the code you ahve in the Save button in the OnFileAdd property of the attachment control
Will this also work with multiple -file uploads? Excellent video.
Yes it will. I am pretty sure I cover multi in this video th-cam.com/video/cjcDH7_v6cE/w-d-xo.html
@@ShanesCows Yes, I have watched that video as well. I am just having trouble translating that code to a button control like the other video.
Hi @LaurenBolin do you have solution for multiple file uploads??
@@radhikaseetharaman1772 if I under stand what your asking yes. This is the code I have in my on select button that I would like for it to activate on. I’m and getting errors on Last(FILE).Value & Last(FILE).Name & Reset(Self)
ForAll(Attachmen_1_DatacardValue_4.Attachments As FILE,
CARAttachmentFlow.Run(
inpFN.Text,
InpPN.Text,
{
file:{
contentBytes:Last(FILE).Value,
name: Last(FILE).Name
}
}
));
Reset(Self);
@@radhikaseetharaman1772 Remove the word "Last" and the brackets around "FILE", so that part of your formula will read like this: contentBytes:FILE.Value, name:FILE.Name
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.
Excel has an image column type. If you set that up in your Excel then Power Apps understands it.
@@ShanesCows That's useful info but I'm not sure how it applies to my question. Are you thinking that the image is being stored in the excel file?? Thanks for the quick reply!!!!
@@ShanesCows I just dug through a download of the app and found that they are using api calls to do the onedriveforbuisness calls. Cheaters!!!
:( I so wanted this to include some clever stuff for creating folders in an on premise environment :(
aka file system "create folder"
Does creating folders on-prem not work the same way as online? I have never had to work with on-prem SP and flow.
@@ShanesCows Theres no specific file system function for "Create Folder" when writing to an on-prem network via the gateway. Kinda annoying. I did some digging around and cannot see a work around at all. The path is the final destination so you cant even tag a folder into the path. C:\My Folder\FolderName\FolderPath
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.
Making uploads easier, I think we would allow vote for that feature. 🙂
@MachineMirth - FYI: You don’t need to use a flow to upload to SharePoint docs library. You may have known that already. This is just another way of doing it, which looks pretty nice. Thanks Shane!