Thanks Daniel. Been planning a similar app to collect internal audit monthly checklist responses and this is a great blueprint for that. You explained the structure of the required tables really well.
Hello Daniel your video is awesome and has allowed me to create an audit app myself. I have one problem I’m using excel to collect and create my tables. The problem that I’m having is that when i create the ‘PictureCol’ i get a fault saying that a collection must be added in order to collect to. I believe this is because I’m using excel and since there is no Picture Collection the program is giving me this error. However, i followed your steps and you did not receive a similar error. I believe also that this is because I’m using a more recent version of powerapps than the one you demonstrate with in this video. Can you or someone else please help me with this error.
I have one more question. How I can disable the submit button until all questions are answered. I tried Display mode property : If( IsBlank(radio1.selected.value), disabled ,edit).I tried various options like true, false. But it only takes one question answered and submit button turns to edit. In short what should be the syntax for selecting all radio buttons (answer) then submit button enabled. if one of the questions is not answered, the submit button should be disabled.
Hi Daniel, I am stuck on the the following formula (I keep getting the following error: The function 'If' has some invalid arguments.) OnSelect = If(PictureColvar=1,Collect(PictureCol,{Image:UploadedImage1.Image},Question:1),....... I have tried multiple things to fix it with no luck.
If you watch really carefully, you can see that what he actually uses is not what he originally types in. Try If(PictureColVar=1,Collect(PictureCol,{Image:UploadedImage1.Image,Question:1})). It's just the squirly bracket that moves but makes all the difference to the syntax!
Hi Daniel, I love this app demo! I have been building a version for my company but I have had issues with the radio button resetting when I move between the picture screen and back to the main screen. Would you be able to help with this issue?
Thanks Daniel for sharing. When we have results, how can we make one more further step to make comparison between different departments / audit time. It is best if we have something like charts to visualize that. Thank you!
Hi Daniel, thanks for the great video. I don't have access to SQL server so I used SharePoint lists. The photo saving part doesn't work for me! can you send me the app you created and give me instructions to replace SQL tables with Sharepoint lists? Thank you Marco
Very helpful video Daniel. Is there anyway to only show the submit button when all the items in the gallery are checked. also indicator to show how many has checked like a progress bar?
Glad you found the video helpful. To only show the button when all the items in the gallery are checked can be done using a combination of Count and If function. You use Count to first see how many items there are in the gallery and then another count to see how many have been checked, if the two counts match then display the button using the If condition. For the progress bar take a look a the pie chart visualization that is available and use that as a progress bar.
Hi Daniel, That was a superb video. By watching this video, As a beginner, I have got an idea of How audit apps would be and its uses. Is there any possibility to share this source or the same kind of source? Why because I have some doubts about the functionality which you have done behind the View Screen's Galleries. Thanks in advance.
Hi Daniel, I was using excel(one drive for business) to build the same app as I have no access to sql tables. I tried to use excel relationships for all these tables. Somehow I see all the data collected in AuditCol collection, but Collect( AuditAnswer, AuditCol) does not update excel table. Also, there is no syntax error. Can you assist?
Hi Hasmukh, This usually occurs when the columns in the collection do not match those in the Excel worksheet. Also to avoid complications have the Excel column names without any spaces or other things such as -, _ or &. Finally, once the column names are changed you’ll have to remove the connection and add it back again. I hope this helps and keep Power Apping!
@@ValoIntranet Hi, I read about this and my column names are same, even tried copying from table. But was not taking somehow and also if name are different, the error will show up. But nothing was happening. Finally i modified the code like' For all( AuditCol, Patch( AuditAnswer, ,{....} ....., Then i achieved the result. I don't know it's Excel or something else.
@@such1 hello! I'm going to use excel as well. Will you be so kind to share your completr modified code to resolve the issue please? Thank you so much in advance.
@@such1 Hi There! I am also stuck and using Excel as my data source - How exactly did you modify the Collect(AuditAnswerDemo,AuditCol) using the ForAll(AuditCol,Patch(AuditAnswer.....) code that you wrote? Thank you!
Hello Daniel, I keep on getting error on AddMediaWithImage. When I remove the syntax to AddMediaButton and UploadedImage, and just put on the AddMediaWithImage, it still gets an error and PictureCol collection doesn't seem set. What I am doing wrong?
![[Lern PowerApps] Livecoding - 🔧Wartung und 🔍Prüfung von ⚙️technischen Anlagen](http://i.ytimg.com/vi/eQpjx1afoKg/mqdefault.jpg)
![เป็นไปได้ไหม - WanMai [Performance Video]](http://i.ytimg.com/vi/Eh5hItD4Mr0/mqdefault.jpg)
Thanks Daniel. Been planning a similar app to collect internal audit monthly checklist responses and this is a great blueprint for that. You explained the structure of the required tables really well.
Hello Daniel. The video is great. But I have a question. How do you do the PictureCol? I went back and forward on the video but I cant find it.
Thanks Daniel ..It was a clear explanation and I was looking to build something similar to this..Good Learning !
Thanks Daniel, Great video. Maybe time for a update video 😀😀. There's been a lot of changes since then in PowerApps?
Thank you Valo Intranet - still relevant up to this day ^^
Hello Daniel your video is awesome and has allowed me to create an audit app myself. I have one problem I’m using excel to collect and create my tables. The problem that I’m having is that when i create the ‘PictureCol’ i get a fault saying that a collection must be added in order to collect to. I believe this is because I’m using excel and since there is no Picture Collection the program is giving me this error. However, i followed your steps and you did not receive a similar error. I believe also that this is because I’m using a more recent version of powerapps than the one you demonstrate with in this video. Can you or someone else please help me with this error.
Can anyone help me with this issue?
Thank you very much. This got me started on my own audit app.
I have one more question. How I can disable the submit button until all questions are answered. I tried Display mode property : If( IsBlank(radio1.selected.value), disabled ,edit).I tried various options like true, false. But it only takes one question answered and submit button turns to edit. In short what should be the syntax for selecting all radio buttons (answer) then submit button enabled. if one of the questions is not answered, the submit button should be disabled.
Hi Daniel. Wonderful App. Did you write a blog that shows these details, and a link to that would be highly appreciated. Thank you.
Truly great explanation by Daniel !! Thanks alot. Alot of useful stuff to learn.
Hi Daniel, I was wondering why the “ForAll” is updating in the collection only the selected item in the Gallery. I would appreciate if you can help.
Hi Daniel, I am stuck on the the following formula (I keep getting the following error: The function 'If' has some invalid arguments.) OnSelect = If(PictureColvar=1,Collect(PictureCol,{Image:UploadedImage1.Image},Question:1),....... I have tried multiple things to fix it with no luck.
If you watch really carefully, you can see that what he actually uses is not what he originally types in. Try If(PictureColVar=1,Collect(PictureCol,{Image:UploadedImage1.Image,Question:1})). It's just the squirly bracket that moves but makes all the difference to the syntax!
@@mtab9977 Thank you, I had this same issue and your suggestion fixed it.
Hi Daniel, how can I patch the image to sharepoint list as backend?
Hi Daniel, I love this app demo! I have been building a version for my company but I have had issues with the radio button resetting when I move between the picture screen and back to the main screen. Would you be able to help with this issue?
Thanks Daniel for sharing. When we have results, how can we make one more further step to make comparison between different departments / audit time. It is best if we have something like charts to visualize that. Thank you!
I have a question, if don't have experience of SQL server. How can I add questions. If I want build a store inspection audit app
Hi Daniel, thanks for the great video.
I don't have access to SQL server so I used SharePoint lists. The photo saving part doesn't work for me!
can you send me the app you created and give me instructions to replace SQL tables with Sharepoint lists? Thank you
Marco
Very helpful video Daniel. Is there anyway to only show the submit button when all the items in the gallery are checked. also indicator to show how many has checked like a progress bar?
Glad you found the video helpful. To only show the button when all the items in the gallery are checked can be done using a combination of Count and If function. You use Count to first see how many items there are in the gallery and then another count to see how many have been checked, if the two counts match then display the button using the If condition. For the progress bar take a look a the pie chart visualization that is available and use that as a progress bar.
Hi Daniel,
That was a superb video. By watching this video, As a beginner, I have got an idea of How audit apps would be and its uses.
Is there any possibility to share this source or the same kind of source? Why because I have some doubts about the functionality which you have done behind the View Screen's Galleries.
Thanks in advance.
Hi as I don't have acess to sql, this would work just as well in sharepoint lists
This is quiet amazing. Thank you for showing how you did it.
Hi Daniel, I was using excel(one drive for business) to build the same app as I have no access to sql tables. I tried to use excel relationships for all these tables. Somehow I see all the data collected in AuditCol collection, but Collect( AuditAnswer, AuditCol) does not update excel table. Also, there is no syntax error. Can you assist?
Hi Hasmukh,
This usually occurs when the columns in the collection do not match those in the Excel worksheet. Also to avoid complications have the Excel column names without any spaces or other things such as -, _ or &. Finally, once the column names are changed you’ll have to remove the connection and add it back again.
I hope this helps and keep Power Apping!
@@ValoIntranet Hi,
I read about this and my column names are same, even tried copying from table. But was not taking somehow and also if name are different, the error will show up. But nothing was happening. Finally i modified the code like' For all( AuditCol, Patch( AuditAnswer, ,{....} ....., Then i achieved the result. I don't know it's Excel or something else.
@@such1 hello! I'm going to use excel as well. Will you be so kind to share your completr modified code to resolve the issue please? Thank you so much in advance.
@@kittydoes7600
I have made some customization to the app. Let me know where you are stuck, so I can explain.
@@such1 Hi There! I am also stuck and using Excel as my data source - How exactly did you modify the Collect(AuditAnswerDemo,AuditCol) using the ForAll(AuditCol,Patch(AuditAnswer.....) code that you wrote? Thank you!
Can you show me how to build an app that will run on a mac?
Hi Daniel, thank you for the ongoing great efforts. I was wondering how can I have a hand on this app.
Appreciate if you can help me.
Hello Daniel, I keep on getting error on AddMediaWithImage. When I remove the syntax to AddMediaButton and UploadedImage, and just put on the AddMediaWithImage, it still gets an error and PictureCol collection doesn't seem set. What I am doing wrong?
I am having exactly the same issue. Did you ever solve it, Kather?