@@elieawad7323 I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RU-vid channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Lovely to see someone who had a possibly humble beginning in Rizvi make such rapid strides internationally! Canvas apps would have been lot tougher without you. Keep doing great work!
Bro, you are the best out of all the content available out there. What I like the most is that (90% of times) you already have a video on something we are struggling with no matter how strange the problem is.
Click - oh the wrong door...Sorry I will come back when when i work for an org who wants/afford data verse 😊...so far we good with mama SP. Thanks Reza for the quick review of the video that you give us it helps a lot to take a glance of the outcome ....
Thanks for sharing, Reza. Really insightful. The same patch functions can be leveraged to store attachments in the list item with SharePoint as a Data Source?
Good content as always Reza, Quick question, i always use the attachments feature by enabling attachments on a Dataverse table and all files are stored as notes. What is the advantage of defining the attachments the way you have demonstrated here as opposed to the way I manage attachments?
@@RezaDorrani For the life of me I cannot resolve this error when trying to patch attachments into the supporting documents table... Invalid argument type. Expecting a Record value but of a different schema. Incompatible type. The 'Status' column in the data source you're updating expects a 'OptionSetValue' type and you're using a 'OptionSetValue' type. Not sure what I'm doing wrong.
Thank you @RezaDorrani - great resources. Question about the dataverse - how do we remove a lookup column? I cannot seem to find the way because of all the dependencies created due to the relations added. Thanks in advance!
Sorry but I am not aware of a way to resolve this. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza. This is a really useful video so thanks for posting it. I have been able to follow up until around 16:50 where you say it's important to change the settings in the Advanced tab. Those settings don't appear on my app though. I've searched and cannot seem to find where those properties are now. If I skip that step, the attachments show in the control perfectly fine, but when I try to download them it says 'Couldn't download - No file'. Do you have any suggestions? Thanks.
Most welcome! I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I got the same issue, did you figure it out by any chance? It seems it's uploading the file on dataverse, I can see it in the table, but when I click on it from the App, it says "File not available on site" So there might be some changes on PowerApps since this video was published. It's bad cause I really need the multiple files upload, and I feel I have 99% of it done.
Actually below on the comment we have this from @lemak89, which saved my life: In my case, there are no Name and Value parameters in the Advanced settings, which resulted in a 'no file' error. To solve it you need to go to the App Settings -> Upcoming features -> turn off Power Fx formula bar -> save and reopen an app. Now Name and Value parameters are visible for attachment control. After changing them, we can turn on Power Fx formula bar feature and relaunch an App again.
@@christianharrington8145 I had the same case and I confirm your solution works. My only concern is that I had to turn on "Legacy formula bar" which is retired. I would like to avoid this approach but not sure what is the alternative.
Hello Reza, great video, thanks 🤩 I see that the PDFViewer component has always been in "experimental" for many months, can we trust it to use it in a production environment? Among other things, starting today in various tenants I'm experiencing extreme slowness in viewing documents, but in this case the datasource is SharePoint and not the Dataverse.🤕
Pdfviewer have been experimental ever since its existence. There is always some risk with experimental features when using it in production. I have used it in production apps with the understanding that there could be potential updates needed in future. I have not experienced any slowness today with apps.
Hi Reza, Thank you for all the video's, they are very informative and easy to follow. My question is regarding Microsoft forms. Is it possible to fetch total score from Microsoft forms and display it in a Microsoft list? OR through any means can the score be fetched from Microsoft forms and displayed somewhere.
Thank you for this informative video, Reza! I do have one question, though: I notice that when you created the file columns, they were not read-only. When I created one in my DV table, it was read-only. How would I go about ensuring that a file column is not read-only when creating it?
Thanks for the video. I want to upload an excel file in real-time and want to import data from that excel file to our Dataverse. What is the best approach on this case?
Reza, do you have any suggestions for implementing the download? In my case, every file has some additional metadata and I would like to display the files and this additional metadata in a gallery. There are approaches that use the download function with the Dynamics link, changing only a few parameters, but they are always using the default environment. When you use this in a context of multiple environments, the 401 error problem starts.
@@RezaDorrani Yes, I know that but I want to have both download and onscreen preview of files on a single list. I have created a gallery for this purpose and thought that I could have icon next to each listed item on the gallery for click and download.
Beautiful solution 🤩. I am just having a minor issue. Not sure if I did something wrong. However, if I upload a file, patch it, and want to add another file, the "For All" will pick previously saved file and the new one and patch it. This way, I will have 2x first file, and 1x new file. Maybe some logic needs to be added here to exclude patching the previously saved files?
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Simply superb! I am trying to save my attached file to sql server table using Patch function as shown in video. what should be the datatype of my column where i am storing this attached files ? or is there any other way to achieve this.
I do not have a video reference on sql scenario and would have to try it out to provide guidance. I recommend checking or posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@shivakumaryadav8997 I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on community tab of my channel. Most voted idea gets added to my backlog.
Hello reza, Thank you for your video, and for download the file from dataverse, what's the solution ? I have a BlobNotFound error when I click on the file in the gallery ?
I do not have a video reference on this scenario and have not tried it out hence not sure. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hello Reza, Thank you very much for your great video. You explain everything in great detail. I have a question: when I upload several files from my desktop it works wonderfully. But when I do this on my phone, the data set is created in Dataverse with the correct name, but the file is missing. Do you have a solution for this? I use these commands: ForAll(attachDateien_2.Attachments;Patch(P7_Dateien;Defaults(P7_Dateien);{ReklamationDateien:frm_Upload2.LastSubmit;Datei:{FileName:ThisRecord.Name;Value:ThisRecord.Value}}));;Navigate(Scr_Reklamationen) Thank you and greetings Uwe
@@RezaDorrani Thanks for the quick reply. I've tried it on different cell phones, but only the data records are created and the files are missing. 😞 Maybe others also have this problem and there is a solution. If you think of anything about this, I would be very happy to receive another post from you. Thank you very much and have a nice weekend.
Really helpful video. I have a question regarding patching data to dataverse. When I'm using a browser all the newly patched data automatically appears on my browse gallery however when i'm using an ipad/mobile the patched data do not appear even after clicking a button with refresh table fuction.
Most welcome! I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Really appreciate your response Reza. I'm also checking the possible reason is that I ticked the "Can be taken offline" option on my dataverse tables. Will try to untick this and see how it goes.
Hi Reza, Thanks for the video. In my last project I worked with dataverse and encountered few problems and solutions I have couple of doubts 1. After uploading the documents into Dataverse Table using file upload, I cannot preview that file in the backend. To view that file I need to use Power app & download that file Is there any alternative method to view that file in dataverse table itself? 2. File Upload effects on Power Automate flows, especially with trigger conditions with flag set -> I used Dataverse rows modified trigger to run the flow. When I uploaded an empty file (0 Kb) the flow did not fire but when I uploaded a non-empty file the flow is successful. 3. If we use attachment controls and enable attach files in table, user can upload and store multiple files instead of creating lookup and adding many to one relationship. Thanks in advance! Always enjoyed your tutorials
@@RezaDorrani it means in the syntax first I need to remove all attachments related to the particular I'D and then add attachment using patch defaults to the same ID
Hallo Reza, Thanks for the video, I am interested in the part of PowerApps Patch function to upload attachment to Dataverse file column but am getting this error "Incompatible type. The 'Filename' column in the data source you're updating expects a 'Text' type and you're using a 'Error' type". Please assist and guide me.
I have not come across this issue hence not sure what the fix is. You can try replicating steps in the video again or try posting your issue with screenshots on the forums in case someone has done something similar powerusers.microsoft.com
I have not investigated with ActivityMimeAttachments Table, hence Im not sure. Il recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Hi Reza, Thank you for this video. I have a question, I have an app where the VIDEOS will be uploaded in the dataverse and it needs to be sent as an attachment to e-mail via powerapps/power automate. Is there any workaround to surpass the attachment limit since the file will be videos?
Nice one Reza.. but when we edit and try to delete ( not with different screen) with same Attachment control it always delete the first item in the control
I have not come experienced this issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks for the video. I have a doubt, I am uploading file attachment to Dataverse but I need to show it as a preview on powerapps. How can preview of the file be done if data source is Dataverse?
Im not aware of how to show preview for Dataverse file. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
The PDF viewer (experimental) does that right? If you look at the end of the video, Reza explained to show the preview on the deletion screen, but in my case I added this PDF control to the Detail Screen, and on the Document property I added this: First(attachContract.Attachments).Value where attachContract is the attachment control then the preview works perfectly Is this what you are looking for?
Instead of Using Data-verse table to store file (obvious reason expensive storage)> I used SharePoint library to store attachment > mapped Display name with File Name with extenstion and Value with Link to Item > But the problem is the attachment control does not Download the file > I am not sure what is syntax error I am doing (I've put workaround; I mapped path with Display name so that Links are clickable) > Also I am working on a logic to Remove attachment on Edit. Great video ! Microsoft have not given any doco related to this ! How do you figure these thing out ?
I have not tried a scenario with SharePoint for file storage and Dataverse for metadata hence not sure about the challenges with it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks mate, I was able to do it..for edit form i used combination of gallery with attachment control. Gallery to show library data(filtered with current record id) and attach control to upload more docs. While new form exactly the same that u shown.
Awesome Solution, however, I cannot map the advanced attachment properties of Name and Value to DisplayName, which I believe is not allowing me to download the file. The Name and Value do not appear in the properties. Can you help with this Thank you
Found somewhere in the comments that this is due to the new PowerFx bar being auto turned on. Once you turn it off in settings it shows the values in Advanced
Thanks a lot! Absolutely brilliant! However, it seems that what you explain at 16:46 has completely vanished in a newer Power Apps Portal Studio Version. There is no option to configure the Name=Displayname and Value=Value under advanced settings and I cannot find it anywhere else either. Any ideas? Thanks a lot.
I found it myself. It vanishes with the new Experimental Feature "New Power Fx Formula bar". Maybe this should be reported to Microsoft - because the download false without this setting and the setting is not available anymore. For now, I could turn the new Power Fx Formular bar off and now it works. Thank you.
Hi Reza I hope you are doing well. I need your guidance on one thing. I have one use case where I have to run a Python Code from Power Apps or Power Automate whenever user clicks the button on Power Apps. Is there any possible way by using which we can make this possible???
Hi Rezza, the multiple files upload attachment control is outside the form control. Is there a way to put attachment control be within the form? I have try put it within doesn't seem to work.
Hi Reza, This is excellent. Thank you. I am facing an issue one clicking the attachment in view mode. It says file not found on site. Everything else is working fine. I tried using the form control and viewing and downloading the files, it works, but in my canvas app I can see the filename but cannot download it. Any help suggestions would really be helpful. Regards, Srijit.
Hey Reza, wanted to suggest a how to video for a simple order app, with multiple parts to add on to a single order (one to many kind of relation). Similar to the "Power Apps working with SharePoint List Relationships" tutorial you gave, but maybe a single list containing those tasks? Essentially trying to move away from Nintex forms with allowed one entry to contain sub-entries of info. for my personal workflow..
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on community tab of my channel. Most voted topics get added to my backlog. Make sure to post your idea in the next topic suggestion.
thank you Reza, i create a workflow send me a email with attach file from dataverse table, but i can't open the file , with error message from outlook , impossible to open the file. any idea ? thx a lot
I have not come across this issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
This really great. But I am trying to figure out how I can upload actual data into the Dataverse database, like the actual row data from an Excel file. Rather than uploading a file as an attachment, I need to populate the database table with data. I have a form to enter in new records individually, but I'd like to have a button that could initiate an Automate Flow that uploads all the column data from an excel file in bulk.
Hi Raja, I followed your video and was able to implement multiple upload. Only issue I am facing is once clicking on the uploaded file it is not downloading and giving error Blob not found
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks Reza, it is very helpful. But I has an issue, when I click filename, it is failed to download. there shows 'Couldn't download - No file'. Do you know why?
@@RezaDorrani Thanks for your help, my problem is image or pdf file had been uploaded to a dataverse table as you were doing, and app have shown them in attachment control (view mode), but their values start with "appres://datasources/", so they are not a "https" URL and cannot be downloaded directly. How can I fix it to download directly?
Hi Reza, thank you for all of the great content that you create. Quick question, I have a need for an app that displays a list of students where a teacher can click on the student's name and then add a comment/delete a previously posted comment. The admin would have rights to add students to the list of students and everyone could view all of the notes posted on a student. Could you give me some direction on how to create this or is there someone willing to create it? I'm doing this for my school so I'm not going to sell it or make money off of it. Thanks!
I have not done any work on such type of an App. I am not aware of anyone who is willing to create Apps (assuming this question was for me). It would be best to post this query on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you for your reply. It's similar to what you did here. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hzLEecSpmFo.html on appending comments. The different part I need is to make the "title" a dropdown list that can be edited by the admin so teachers could select the students name and add notes as needed. Does that make better sense?
I have done many videos with various scenarios. If you can stitch up logic from those videos and get your scenario working, then great. I cannot understand your exact use case or provide guidance here on chat based on parts of your scenario. It would be best to post your query on the forums.
@@RezaDorrani Thank you for your reply! I think I can use the forum documentation and what you have posted to create the solution I need. Thanks again!
do you have any sample for uploading multiple files and viewing them, and download them 1 by 1? I tried the previous approach using datacard but it seems it doesnt work anymore
I make videos when I get multiple requests on a topic. Every quarter I ask for topic suggestions on community tab of my channel. Most votes topics get added to backlog.
I know Reza You Have so many things to do... See once while you have a time. .. Because why iam asking so many times download a data from dataverse table is common thing for every application But I don't know there is no vedios to download table data in excel template format. (Csv iam getting) because it's takes so much time it takes add a row into excel(action) in power automate. Iam looking so many options but I did nt get any option
@@khasimshaik2606 If it is a common ask, many will ask for it and vote for it. I have made videos in past not listening to everyone and no one has watched them. This video is an example of it.
This video is with Dataverse not SharePoint. A doc library has 1 file per item. Attachments control does not add any value there. I have done videos on doc lib on my channel
@@RezaDorrani Thanks Reza. I am trying to have some sort of Download file capability however, when trying to download PDF file, it only open in new tab
Hello, sir i just started implementing two basic power apps tools using Patch function where it append the data to a excel table which is in share point. Thank You🙌🏻🙌🏻
In my case, there are no Name and Value parameters in the Advanced settings, which resulted in a 'no file' error. To solve it you need to go to the App Settings -> Upcoming features -> turn off Power Fx formula bar -> save and reopen an app. Now Name and Value parameters are visible for attachment control. After changing them, we can turn on Power Fx formula bar feature and relaunch an App again.
@srijitganguly1373 Idk of you found it yet but for others (and myself when I come back to this problem in 4 months) it's now moved to retired tab and you turn on Legacy Formula Bar
Hi Reza, I would like to ask on how can I let end users use my published app with dataverse? My end user tried to access the published app with dataverse table however, they were prompted with "Error when trying to retrieve data from the network".
I have not come across this issue. As long as app is shared with them and they have a security role assigned which gives them access to the tables, there should not be a problem. Best to post your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, We are submitting form from Canvas app into Dataverse table with file field into file column. All works well, except when someone tried to upload a .txt file. This is not a blocked file type in our environment. Any ideas why this is happening? The record is submitted but no file present in the table.
@@RezaDorrani Hi Reza. I am having a weird issue with the patch function. Whenever I submit a new record, the file patch function doesn't work. When I try to add the files again in the same record I just created, the patch file function works. Is there a way to fix this bug? Would a Collect function be more reliable?
@@RezaDorrani Also, I noticed I cannot set the vales for the Name and Value fields in the advanced section of the DataCardValue. Any ideas as to why this is happening?
@@wildchangjr.8998 I have not come across both of your issue hence not sure what the reason could be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, was there a recent change where the Value Column type changed to HyperLink? I'm trying to replicate this in my app but I keep getting an error saying that the value column is expecting a Hyperlink. Thanks in advance.
I have not. PDF Viewer only works with PDF files. I did a video with SharePoint where I used native SharePoint API to transform word/excel/powerpoint files to pdf and show it on viewer. You could do so for Dataverse as well by using APIs that can perform the transformation.
Hi Reza, When I tried downloading the document by clicking on it. It says , File was not available onsite. I have seen the same in many other videos but nobody have worked on that.
Scenario: Creating a front end in powerapps with an upload/attach option File Upload on Powerapps (excel) Check and validate the file contents (columns have the correct type of data, etc, etc) If its correct pass the file to the database (either SQL, dataverse, or excel even), If not then mention the fields which need to be updated to the user on the end screen and tell them to re-upload after correcting the data. Sir, is it possible? Please help me out, if not suggest me some other ways.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I'm not sure about its feasibility. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
At 17:40, on clicking save, file name is changed from "Contract C" to "Contract A" after few milliseconds. Can you please let us know why is it happening. Also its fix. And Thanks Reza!
I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
The technique shown in video is specific to Dataverse. I have done many videos related to SharePoint list attachments. I would recommend searching for those on my channel.
When I click on it the browser says "Cannot Download: no file" although I followed the steps the list shows the names correctly and filtered correctly as well. any suggestions?
I have a requirement to upload multiple documents to dataverse for a single record. Its just unfortunate that Dataverse does not allow for multiple documents attachment except we use an extra table
Hi Reza, Great video! Hope you are doing well, don’t know better PowerApps expert than you, that’s why addressing you my issue, if you can help. I have an app with form that creates a record in SharePoint List. User is creating a record; it goes to another user for approval. Notification to Approver is sent by email, it has a link to specific record. When approver goes through the link, it opens the record, Approver approves, then it must change the status and go to the next approver. Problem 1: Status is not changed when it is approved, if the record is opened by link. but when It's opened from the app, everything works fine. Problem 2: After opening a record from the link, approver then goes to gallery to open another random record, it opens the record which was opened by link, not the one he selected. Again, if users don't use links to open a record, but use the app itself, everything is working fine. Cannot understand why this is happening, please help to resolve this If you need more details, I’ll provide.
I will have to look at your App/flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi dorrani, I need your help I have a single entry field like engine type drop-down and engine name input text , date etc are single entry fields , I have multiple entries also . Like reson, category, details etc. I want to save the data into excel , i already uploaded the excel into SharePoint. I want output like this Engtype engno date category details. reso A. 1. 20/2/23. C1. Eng fail r1 A. 1. 20/2/23. C2. Eng repair r3 A. 1. 20/2/23. C3 Startingprb r8 First three fields are single entry remaining multiple entries
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com