Build your own Audit App using PowerApps
HTML-код
- Опубликовано: 2 авг 2024
- This is an intro video that walks you through how you can build your own Audit app where a user can add input and save it to multiple SQL tables and build a relationship between the tables.
For the entire walk-through video click on the link below.
www.valointranet.com/blog/gen...
Here is the link to download the app. You will have to re-create your own back-end tables.
powerusers.microsoft.com/t5/C...
Interested in my blogging gear? Then take a look at them on Amazon:
- Blue Yeti USB Mic for Recording & Streaming on PC and Mac - amzn.to/3d9g7bY
- Microphone Stand, Mic arm Desk Adjustable Suspension Boom with accessories - amzn.to/2N0YNLp
- Neewer 2 Packs Dimmable 5600K USB LED Video Light with Adjustable Tripod - amzn.to/3qteqdf
- Flexible Desk Mount Clamp Gooseneck Stand for Logitech Webcam - amzn.to/2Ozc4eH
- Sunpak tripod - amzn.to/3jJeov2
- Logitech C922x Po Stream Webcam - amzn.to/3aZlqrt 
Наука
Really enjoyed this magnificent presentation. Can't recommend your teaching style enough.
Aww shucks, thanks Cloud Hound!
Hi Daniel, wonderful App. Question: how do I recent a radio button control? I was able to create similar to your example but am not able to reset the radio control inside my gallery
Hi BR31,
Using Reset(RadioControlName) should work. You have to add that to an OnSubmit of a button.
Thanks Daniel. In addition I also had to use {} under Gallery Default property. Don’t know why , but it works. Also, for establishing relationships I created Views from tables in sql server and used the view as my source. This helped me reduce the complexity of the functions inside the power app.
hy. how can i do to build the audit system by extracting the data using excel? need your help. thank youuu
You can use Excel as the data source to view and save data. The spreadsheet needs to be in either OneDrive for Business or SharePoint Online document library.
If you wish to simply extract existing data then import it to any other data source and that data source instead.
Hi Daniel, what can I do for this syntax if my "PictureCol" contains not only images, but all types of files? Please help. Thanks in advance. :)
PictureColVar=1,Collect(PictureCol,{Image:UploadedImage1.Image,Question:1)
Kather - pillar refer to Daniels Azure Blob video. You will find your solution there.
Hi Daniel, this is what I really wish to do. However, I don't have SQL. Will this work with Excel too? Because sharepoint list only holds 5000 rows only correct?
Hi Kather-pillar
SharePoint lists are delegable hence it can hold over 5K items. Take a look at my video on 'Power Apps With Large Data Sets'. I have over 40K list items there. ruclips.net/video/IvTiAanB3Cs/видео.html
@@DanielChristian19 awesome! Thank you very much.
Hi Daniel, this is the perfect solution I was looking for regarding my operations. The link for the download is not available. Are you able to share?
Hey Ryan,
Thanks for bringing this to my attention. I have added a new link - powerusers.microsoft.com/t5/Community-App-Samples/Audit-App/m-p/827025
This one takes you the Power Apps community where I have shared the app. It is in a zipped file with the MSAPP and Word Doc.
@@DanielChristian19 thanks Daniel! Much appreciated! Can’t wait to start working on this. This may solve 30% of our work day to day
Hi can make a video for this but using Sharepoint as datasource? As i need something like this but using sharepoint as datasource. Appreciate your help!
Hi Christopher,
The steps should be very similar. You use a combination of a SharePoint list and a picture library. When you are building the SharePoint list, you can use single line of text for most of the columns. For attachments use the picture library and create a relationship between the two using the ID from the list.
Don't forget to like my video and subscribe to my channel!
@@DanielChristian19 ok i will try as i am stuck to almost 2 weeks already as I am only 1 month into this PowerApp.
Yup i like all the videos that i had watch and subscribed. 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?
Kather,
Send me your email via a private message on either Twitter (@dchristian19) or on LinkedIn. I can send you a copy of the this app. This way you can see all the formulas.
@@DanielChristian19 messaged you in linked in. Thank you very much for your generosity.
Hi Daniel , Thanks for the audit apps. I tried to make use of SharePoint list as a data source. However, i' m not able to patch the collection into the data source. FYI my app is without image portion only have the question. There was no error in the submit button.
Hi Wawa,
Some of the common issues I have seen are:
1) Wrong SharePoint site or list
2) SharePoint column type doesn't match the app control type
3) There is an error but either it doesn't show up for a while or you'll see the red color squiggly line right at the end.
In all these situations it's best you re-write that formula, first save it to a local collection to verify and then patch it to the SP list.
Hope this helps and don't forge to Like and Subscribe to my RUclips channel.
And One More request is it will be really good if you build One Entire App using SharePoint And MS Flow.
Thanks
Raju P
@Daniel Christian Sir can you please look into this and let me know on this will this be possible from your side..😀
You got it!
@@DanielChristian19 Let me know once you created Demo and Full App ,will go through it soon.
Can you build this with sharepoint as a data source
Yasir,
90% of this app can be built with SharePoint as the data source. The only missing piece is the ability to take multiple images and saving them.
@@DanielChristian19 thank you, I've managed to capture images in a collection and use flow to add the images as a attachment to the lists
@@yasirfayaz8709 Hi , can you share how you were able to do this? I'm stock with adding images. Keeps getting error on filtering images based on question ID
Hi Daniel, it is exactly what I am looking for, can you send me your app pls ?
Hello Sir,
Fist of all thank you so much for this Demo and Entire App build.
I have developed Same App using that your link but facing some Few issues in Last screen .
from where you copy paste those galleries as i'm not getting Output there.
Regards
Raju P
Hey Raju,
Without having seen your app I can't provide detailed information and hence here's the best advice I have is to rebuild the entire app in a new canvas and see if you have the same issue.
Here's a copy of the app I showed in the demo. You'll have to add the data connections to get it to work-
m365x299233-my.sharepoint.com/:u:/g/personal/daniel_christian_m365x299233_onmicrosoft_com/EU9rH8kW8YxNhA20ixkIEigBZDH3-d9NYe8CmKLI5DEOSQ?e=9Jl9Yb
@@DanielChristian19 ...fantastic this MSAPP file working Perfectly in Last screen too added all required connectors and App now working Fine ,thank you so much for this help.. 😃😃
@@DanielChristian19 Hi Daniel, I can't seem to download the copy of the app. Can you make it available again please? Thank you so much in advance
@@DanielChristian19 Hi Daniel, Great video and App, well done. Would you mind resharing the link to the App, as the above link is not working. Many thanks
Hy. May i ask something regarding to Auditor system using powerapps? Bcs i have some difficulties to complete the system. How do i contact with you or probably you may drop your email so i can reach you out. I really need your help 😭 thanks in advance
Hi Anis,
You can send me a PM on LinkedIn.
Hy Daniel Christian, i have already followed you but i cant PM :(
Send me an LinkedIn invite to connect.