Andrew Hess
Andrew Hess
  • 181
  • 1 260 810
Create A Simple Popup! For Unsaved Changes in Power Apps (Part 4)
Happy New Year everyone! I just want to say thank you for watching 2024 was a great year and I can't wait for 2025!
Let's learn how to create a simple custom popup in Power Apps to alert users about unsaved changes before navigating away!
✅ Build a very simple popup
✅ Darken & Lock the background
✅ Use resources online to make your UI
✅ Use a context variable
✅ If statement to check for Is Not Blank
🔔 Don't forget to leave me a question below if you have more! I have many lined up!
Thank you!
Chapters:
0:00 Introduction
0:56 The Question
2:30 Using Containers
3:47 Transparent Container
4:49 Second Container
6:45 And the Button Container
8:08 That feint gray line
9:57 Use other examples
11:50 Important to Use Development Widsom!
13:40 Using a Context Variable
16:16 If Is Not Blank
18:14 Conclusion
Переглядів: 405

Відео

Populate 1 Form Based on Another Form in Power Apps (Part 3)
Переглядів 626День тому
This is part 3 for creating our Radios Power App. In this video, I’ll show you how to dynamically populate one form based on another in Power Apps. Learn how to set default values for form fields, transfer data seamlessly between forms, and optimize your app for better user experience. 💡 What You’ll Learn: How to use data from one form to populate another in Power Apps. Setting up default value...
Converting Excel to One to Many with a SharePoint Power App (Part 2)
Переглядів 76114 днів тому
Hi everyone! 👋 Let’s wrap up 2024 with a tutorial on many to one relationships and don't forget to get your questions ready so we can end 2024 as professionals! Let's take our excel sheets to the next level with relationships in SharePoint with a Power App. This is the 2nd video of our Radios App that started out as an Excel sheet. We have convert that Excel sheet into a SharePoint list. Now le...
Let's Convert an Excel to Power Apps with SharePoint!
Переглядів 7 тис.21 день тому
Hi everyone! 👋 Let’s wrap up 2024 with a practical tutorial to answer your questions and get you ready for 2025! Let's convert an Excel to a SharePoint list powered by Power Apps! Part 2: ua-cam.com/video/wmp1HX3pj7g/v-deo.html We take a practical Power Apps Example to gather requirements. In this video, we’ll show you how to take an Excel document-like a fire department radio inventory-and tur...
5 Variable Types in Power Apps - With(), Context, Global, Environment, & Collections
Переглядів 963Місяць тому
Discover the power of variables in Power Apps! In this video, we'll explore the five types of variables-global, context, collections, With(), and environment variables-and their unique use cases. Learn how to optimize app performance and to choose which variable type is best for your application. Whether you're a beginner or looking to refine your skills, this guide will simplify complex concep...
Send files with Power Apps V2 Trigger to Power Automate and Beyond!
Переглядів 1,2 тис.Місяць тому
There were 2 previous videos before this one about the V2 Trigger: ua-cam.com/video/GQOLW7G16OI/v-deo.html ua-cam.com/video/MLVJx8ejbBQ/v-deo.html In this tutorial, we'll show you how to use Power Automate to move files from a Power Apps attachment control directly into SharePoint or add them as attachments in Outlook. This step-by-step guide will cover setting up the flow, configuring triggers...
Power Apps V2 Trigger (When Power Apps calls a flow V2)
Переглядів 1,9 тис.Місяць тому
Let's take an even deeper dive into the Power Apps V2 Trigger! Here is last weeks video: ua-cam.com/video/MLVJx8ejbBQ/v-deo.html The "When Power Apps calls a flow (V2)" trigger in Power Automate is a powerful feature that enhances the flexibility of app-building within Microsoft’s Power Platform. This trigger allows you to seamlessly initiate a Power Automate flow directly from a Power Apps app...
Power Apps V2 Trigger More than 20 Fields
Переглядів 1,4 тис.2 місяці тому
Hey everyone! 👋 Today, we’re tackling a PowerApps limitation that many of us have faced: the 20-field limit in the V2 trigger! If you've tried passing more than 20 fields to Power Automate, you know it can be a real roadblock! But there’s a simple workaround: we’re going to pass our data as JSON! By converting your collection into JSON, we can bypass that limit and send as much data as we need....
Customizing the JSON of the SharePoint Gantt Chart (Project Management)
Переглядів 1,6 тис.2 місяці тому
It's time for part three! First we added the Gantt Chart to a SharePoint list. Then we overlaid Power Apps on top of the Gantt. Now it is time to customize the Gantt's JSON. Let's get into it! In this video, we dive into customizing the JSON of a SharePoint Gantt chart to create a visually compelling and functional project view. Learn how to use JSON to style task the bars, adjust color schemes...
Power Apps Integrated with a SharePoint Gantt Chart
Переглядів 2,6 тис.2 місяці тому
Today we have a continuation of the custom JSON Gantt Chart in SharePoint. We will create a Power App that defaults Project Start and Project End. There are couple more adjustments like hiding TaskStart on a Milestone and changing progress into a progress bar. All of these customizations are just a start, I'm sure you could come up with more! Link to Part1: ua-cam.com/video/qrH3bGq0YQ4/v-deo.ht...
Turning a SharePoint List into a Gantt Chart
Переглядів 3,6 тис.2 місяці тому
Hey everyone! 👋 In today’s video, we'll be walking through how to implement a JSON provided by Geert de Kooter into a SharePoint list. Along the way, we’ll cover some key tips and changes to watch out for. This is part 1 of a 2-part series, so make sure to stay tuned for video #2, where we’ll be integrating Power Apps! I'm super excited about this one! Don't forget to subscribe and hit the noti...
Using Ungroup for Flattening your Data Source in Power Apps (Data Manipulation)
Переглядів 6502 місяці тому
Last week we made a video based on Flattening your dataset and we used ForAll, and after a realization maybe it's better to use Ungroup. Here is last weeks video: ua-cam.com/video/244WMVLuZck/v-deo.html Ungroup may be a better alternative, but in my opinion learning both is the most important! Discover a simple method to ungroup a multi-select field in SharePoint! In this tutorial, we break dow...
Flattening a Data source in Power Apps (Data Manipulation)
Переглядів 1,3 тис.3 місяці тому
From a user request we are going to flatten out a data source in Power Apps. Formulas are in the description below! Learn how to flatten a table in Power Apps by transforming multi-choice fields into separate rows for each selection. This quick tutorial will show you how to restructure your data to create a more simplified and accessible format, perfect for reporting and analysis. Whether you'r...
Creating a Responsive Gallery in the Thumb Friendly Zone
Переглядів 5873 місяці тому
Creating a Responsive Gallery in the Thumb Friendly Zone
Create Brand New Excel File Based on Gallery Selection in Power Apps
Переглядів 2,9 тис.3 місяці тому
Create Brand New Excel File Based on Gallery Selection in Power Apps
How to create a Collection from your Selection in Power Apps
Переглядів 3,3 тис.4 місяці тому
How to create a Collection from your Selection in Power Apps
Extract Data from PDFs with Azure Document Intelligence & Power Automate - No Premium Licenses
Переглядів 5 тис.4 місяці тому
Extract Data from PDFs with Azure Document Intelligence & Power Automate - No Premium Licenses
Create a Power App with 3 Screen Templates (Beginner Tutorial)
Переглядів 1,4 тис.4 місяці тому
Create a Power App with 3 Screen Templates (Beginner Tutorial)
How to Easily Create a Left Side Navigation in Power Apps
Переглядів 1,4 тис.4 місяці тому
How to Easily Create a Left Side Navigation in Power Apps
Create News Posts with Power Automate and SharePoint Automagically
Переглядів 2,3 тис.4 місяці тому
Create News Posts with Power Automate and SharePoint Automagically
Emailing Gallery Selections in Power Apps with an Email Template
Переглядів 1,8 тис.5 місяців тому
Emailing Gallery Selections in Power Apps with an Email Template
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
Переглядів 1,2 тис.5 місяців тому
Create Beautiful Email Screen for Power Apps - Responsive Beginner Tutorial
Write your Other Choice in a Combo box with Power Apps
Переглядів 2,8 тис.5 місяців тому
Write your Other Choice in a Combo box with Power Apps
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
Переглядів 3,5 тис.5 місяців тому
3 Ways to Extract Data from PDFs with Microsoft - ChatGPT, AI Builder, Syntex
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
Переглядів 5106 місяців тому
Azure AI Fundamentals Study Guide by Andrew Hess - AI 900
Simple Leave Request App for Teams | Power Apps or List Form
Переглядів 9 тис.6 місяців тому
Simple Leave Request App for Teams | Power Apps or List Form
ChatGPT Whisper with Power Automate (Voice to Text)
Переглядів 1,4 тис.6 місяців тому
ChatGPT Whisper with Power Automate (Voice to Text)
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
Переглядів 8056 місяців тому
Recreating the Calculator in Modern Power Apps - Downloadable Copy in Github
Use ChatGPT-4o Vision on Images with Power Automate
Переглядів 1,7 тис.7 місяців тому
Use ChatGPT-4o Vision on Images with Power Automate
Custom Connector Power Automate & Chat-GPT Images using Dall-E
Переглядів 8047 місяців тому
Custom Connector Power Automate & Chat-GPT Images using Dall-E

КОМЕНТАРІ

  • @johnbrennan8442
    @johnbrennan8442 2 години тому

    Hello Andrew, long time glad everything going well with the views, do you have any suggestions please regarding the other option and the combo box choices combined , I’m having issues with the comma staying in the table when the choices are edited , I’m thinking wrapping it all in a variable or record. I’m using the form and update properly prob best to take it out of the form and use patch

  • @MohammedHamdy88
    @MohammedHamdy88 4 години тому

    Hello Andrew. Thanks very much for your valuable video and happy new year. Your videos has really helped me a lot. I was wondering if you could give me a tip on how to solve an issue. The perfix after Claims always appearing in the app UI itseld and no picture appear as in the video. Thanks

  • @marzaj17
    @marzaj17 День тому

    Thanks so much! This video helped me incredibly!

  • @SinanÖzd-m9r
    @SinanÖzd-m9r День тому

    How can we use Parse JSON without a sharepointlist?

    • @andrewhess123
      @andrewhess123 4 години тому

      Hi Sinan, So SharePoint is not a requirement in JSON in any way. You would just pass your data to Power Automate the same way through the Power Apps V2 Trigger and Parse the JSON. This can be done with any data source.

  • @MrJousef85
    @MrJousef85 День тому

    Respekt! I watch your videos with pleasure, you have motivated me to start my own project with power apps. I m trying to build my own TMS. Is a lot of work but I learn a lot from you! The only issue that I have is to use an excel for backend data source.

    • @andrewhess123
      @andrewhess123 День тому

      Hey Jousef, You want to use Excel, or you don't want to use?

    • @MrJousef85
      @MrJousef85 День тому

      @ Hey Andrew, I don’t want to use Excel, but I have to, because my company that I work for can’t provide me a premium membership. For that I’m stuck with excel. Thank you for your response.

  • @ZiTechOfficial
    @ZiTechOfficial 3 дні тому

    really good video 😊 i would like to ask, if that PO submit to top management for get the approval thru Power Automate, then they can select approved or rejected one of item, its mean not all of listed on the PO approved, how to create it on Power apps ? thanks

  • @SmartHaus
    @SmartHaus 3 дні тому

    Hey, this is Kevin from Germany. I was very pleased when I read the title of your video. I thought it would solve a problem I had. You describe how to create a pop-up. You do that well, too, thanks. According to the video title, it would be even nicer to learn how to recognize changes in a Formular that have not yet been sent to the data source. So I change a value in a Formular, don't save it and leave the screen. That's exactly when I want to be reminded via a pop-up. I think that in your example it's better to work with fields that are marked as required in the data source. Perhaps you have another solution for this. There is the unsaved property in a Formular. But I haven't been able to work with it properly yet.

    • @andrewhess123
      @andrewhess123 3 дні тому

      Interesting, that is a very good point. I have to think about this one! My first simple thought is doing a simple lookup and see if the value is equal to the data source.. but! Maybe a better idea would be to make a collection of the data source's values and then compare to that to the current values in the form. This is a really good idea, I will have to think how to do this correctly. Thank you Kevin! Happy New Years from America!

    • @SmartHaus
      @SmartHaus 3 дні тому

      @@andrewhess123 Thanks for your feedback. I had thought of something like that before. It's also difficult if you still have the courser active in a field. Maybe you can take a closer look at the unsaved property. Happy New Years

  • @0135827
    @0135827 3 дні тому

    That's cool. HNY ....

  • @_samurai00
    @_samurai00 4 дні тому

    Making some use of the offline holidays, thanks brother!

  • @Northonicus
    @Northonicus 4 дні тому

    I've used this same process but it publishes a regular SPO page, not a news post. Any guidance on how to make it a news post?

  • @JacoGriesel
    @JacoGriesel 4 дні тому

    Great tutorial, Andrew. Thank you very much! Happy New Year and may 2025 bring you the 100K gift.

    • @andrewhess123
      @andrewhess123 4 дні тому

      Thank you Jaco !! Happy New Year to you and may 2025 bring you your wishes too!

  • @moechaba5322
    @moechaba5322 5 днів тому

    Hey Mr Andrew, Once again a brilliant video. For me this is great as you have shown me another way to understand and advancing in notifications pop up notice. I will adapt this idea. Thank you and happy new year.

    • @andrewhess123
      @andrewhess123 4 дні тому

      Thank you Moe, have a Happy New Year !

  • @Untethered365
    @Untethered365 5 днів тому

    Great greenscreen upgrade! Love the xmas theme was used in the beginning and in the canvas app colors.

    • @andrewhess123
      @andrewhess123 5 днів тому

      We're getting better for sure! Thank you Sean!

  • @praveeng3921
    @praveeng3921 5 днів тому

    Very nice

  • @Tango_01
    @Tango_01 5 днів тому

    Hi Andrew, thank you very much for the video. I am implementing it in Power Apps. The only thing I am struggling with is inserting the generated signature (pen input) into the Word document. The Power Automate flow receives the following string: "data:image/png;base64,iVBORw0KGgoAAAANSUh..." What should I do to make the signature visible? I get an error when passing it as a parameter to the picture content control. This is the error: "Error Action 'Populate_a_Microsoft_Word_template' failed The image is not of type PNG or JPG. Please provide an image of type PNG or JPG." I would greatly appreciate your help. Big hug!

  • @ET-zf9qs
    @ET-zf9qs 6 днів тому

    Hi Andrew, I'd just like to ask, I know it might be a dumb question, but what's the difference between creating it as a solution and just creating it as an app? Thanks in advance and happy holidays! :)

    • @andrewhess123
      @andrewhess123 6 днів тому

      Hi ET, Nope definitely not a dumb question. A solution is like a package and once you have hundreds of apps or flows it becomes very unmanageable, especially across an entire organization. It is also easier to move a solution from one environment to another and there is some functionality that is only available through solutions instead of just an app. Like environment variables. As you start using Power Apps or the Power Platform more and more the reasons to use solutions will start showing. And it's fine to not use solutions at first too! I believe everyone started there first.

    • @ET-zf9qs
      @ET-zf9qs 5 днів тому

      @andrewhess123 Thanks for that explanation, that makes perfect sense!

  • @ShiftKoncepts
    @ShiftKoncepts 6 днів тому

    Hi what would you do if you wanted to have combobox with Titles as select but want to add a text label to add the calories from what was selected?

    • @andrewhess123
      @andrewhess123 6 днів тому

      You would need another table of the combo box selections with the calories associated. Then you would sum those selections. I might prefer to do this with Power BI instead also, it kind of depends. PowerBI is way faster with math and large complex data solutions. You could even integrate Power Apps and Power BI together. I'm not sure which approach I would take exactly, depending on the requirements from the user. But you need an associated table with the items and the calories.

  • @OiLoikes2Party
    @OiLoikes2Party 7 днів тому

    Thank you for an amazing video: great examples, easy to understand and love your vibe! I found this definition of collection useful: Collections are used to store tables of data. You use the ClearCollect() function to create and populate a collection.

  • @OiLoikes2Party
    @OiLoikes2Party 7 днів тому

    Amazing! In the first 7 minutes you created a calculation app with a formula... I have done two entire courses in PowerApps on Udemy and 5 hours of courses later, they still havent managed to cover something as simple as this.

  • @emiliagidlof9825
    @emiliagidlof9825 7 днів тому

    Love this! I've done a similar solution, but when I copy the template the file meta follows, and I get the same publish date as the original template. Meaning - the news post will not show in any news-webpart, since it is "old". Anyone with similar experience? I don't ""chech out" my file, only copy - promote to news- and publish, if that matters.

  • @Gauravberg
    @Gauravberg 11 днів тому

    How to link this form to a new list which is created based on this existing sharepoint list ??

  • @gowthamrajamanickam3982
    @gowthamrajamanickam3982 11 днів тому

    Can you confirm if it is possible to add a header on each page of a table? For example, if I have content that spans 6 pages in a table format, I want the header to appear on every page. Additionally, is it possible to add a child table at the end of a row if the row contains related records from another table?

    • @andrewhess123
      @andrewhess123 11 днів тому

      It should be possible for header rows, when you select your table header, go to the Ribbon in Word, > Table Layout > There is a button called "Repeat Header Rows". Try that? I would need to try to say with 100% confidence. 😀 Now for the child table at the end of a row, I do not think that is currently possible with this method.

  • @ChrissyRamirez-x3l
    @ChrissyRamirez-x3l 12 днів тому

    I’ve used the exact formula to make the button non-clickable, and it references the correct field name. However, when I add .Value, I encounter an error. Without .Value, the formula doesn’t produce an error, but it also doesn’t function as expected.

    • @ChrissyRamirez-x3l
      @ChrissyRamirez-x3l 12 днів тому

      If(IsBlank(TitleDataCard1.value) Or IsBlank(StartDateDataCard1.value) Or IsBlank(EndDateDataCard1.value),DisplayMode.View,DisplayMode.Edit)

    • @andrewhess123
      @andrewhess123 11 днів тому

      ​@@ChrissyRamirez-x3l Instead of .Value, is there something else the intelli-sense that it's expecting... maybe it's not .Value... It's .StartDate? .EndDate? .Name? .Address? What is the value in your datacard? The intelli-sense should guide you.

    • @ChrissyRamirez-x3l
      @ChrissyRamirez-x3l 11 днів тому

      I found this issue. My Card Title and the Vaue holders did not have the same name. For example, my first field was named TitleDataCard1 but the text field was DataCardValue1

    • @andrewhess123
      @andrewhess123 11 днів тому

      @@ChrissyRamirez-x3l Makes sense, nice!

  • @andrewhess123
    @andrewhess123 12 днів тому

    When I rewatched the video, I realized I went super fast! Sorry about that had family in the house 😀. Can't wait for 2025 though, we are going to make some even better videos and maybe a little slower😂! Thanks for watching everyone!

  • @Mielkew
    @Mielkew 13 днів тому

    Nice video tutorial, have you made any use case like dynamic checklist based on a dropdown then patch the result in sharepoint

    • @andrewhess123
      @andrewhess123 11 днів тому

      Hi Mielkew! Sort of, dynamic checklist and based on a dropdown and patch a result to SharePoint? I have a video similar to the topic, not sure if exact, called "Collection Selection". ua-cam.com/video/hIDRup4LcHE/v-deo.html&t

  • @cepimu9728
    @cepimu9728 13 днів тому

    Thank you so much for this video I found my way, but in you caption no.9 wrong file. I get an error 😂😂 - change to @{body('Send_an_HTTP_request_to_SharePoint')['d']['UniqueId']}

    • @andrewhess123
      @andrewhess123 13 днів тому

      Nice! I'm glad the video helped though!

  • @0135827
    @0135827 13 днів тому

    Hi Andrew, one more Q, how can I change the button color inside the Nav gallery based on my screen selection. I tried using the "TemplateFill" didn't work for me. Thanks again !

  • @crash18242
    @crash18242 14 днів тому

    looking for a customized project dashboard to display status on multiple projects

  • @sg8127
    @sg8127 14 днів тому

    keep post

  • @Hesamiii
    @Hesamiii 14 днів тому

    Self.text also works

  • @RicaUy
    @RicaUy 15 днів тому

    Hi Andrew, this is really helpful ... could you help me customize the Json if i want to delete the task start and task due?

  • @elainebautista3490
    @elainebautista3490 15 днів тому

    Hi, where did MyFile name and MyFile Contentbyte came from

    • @andrewhess123
      @andrewhess123 15 днів тому

      Hi Elaine! @6:10 its the name of the attachment control

  • @Debs0o
    @Debs0o 16 днів тому

    Hi, Andrew! Great tutorial! Thanks a lot. Is there a way to do the same flow, but getting multiple files at once? I need to get one or more files from powerapps and send them all in a single email in outlook.

    • @andrewhess123
      @andrewhess123 15 днів тому

      Hi Debs! Does sound possible you will just need to loop through and send them all. Would probably need a video to show this though.

  • @pedrohenriquefontesleitao9750
    @pedrohenriquefontesleitao9750 17 днів тому

    Nice video! Is it possible to add a repeating table in word template?

    • @andrewhess123
      @andrewhess123 17 днів тому

      Yes with the Power Automate or App premium connector

  • @munawarhussain1400
    @munawarhussain1400 17 днів тому

    ❤amazing tutorial ❤️

  • @Brattt2010
    @Brattt2010 18 днів тому

    This works perfectly! one thing i wish i could do would add a image from the new item on the list with each news post. Any idea how this could happen? ive searched all over and keep running into a wall trying to combine a few different methods thanks!

    • @andrewhess123
      @andrewhess123 17 днів тому

      Hey Brian! I am currently running into the same exact thing.. and trying to figure it out. It's like there's some kind of security feature thats blocking me with the images.

    • @Brattt2010
      @Brattt2010 17 днів тому

      @@andrewhess123 Yes! Let me know if you find a work around. I try looking into pulling it from the API Get files route and it still keeps giving me a error!

  • @michaelthomas7444
    @michaelthomas7444 18 днів тому

    Is this a Canvas power app or a Model Driven? Or a Canvas app that interfaces with a Model Driven app? Very spiffy user interface!

    • @andrewhess123
      @andrewhess123 17 днів тому

      This is custom JSON for the view in SharePoint. No power apps needed :)

  • @charlesfoenkinos3536
    @charlesfoenkinos3536 18 днів тому

    Great job! You just saved me from creating one template by number of rows possible 🙏🙏

  • @moechaba5322
    @moechaba5322 18 днів тому

    Apologies Mr Andrew, Taking this opportunity with regard to this video, I’m using multiple screens. I would like to add a pop up or a reminder to the end user to SAVE or you might lose the current data when you move to next screen when in editing mode not in new mode. I’ve tried on so many different ways but still can’t get it right. Would you happen to know a better solution please

    • @andrewhess123
      @andrewhess123 18 днів тому

      Good one, love the idea!

    • @moechaba5322
      @moechaba5322 18 днів тому

      @ thank you

    • @andrewhess123
      @andrewhess123 6 днів тому

      @@moechaba5322 Hey Moe! My new video coming out tomorrow goes over your question. Thank you for asking this great question for a video!

    • @moechaba5322
      @moechaba5322 6 днів тому

      @ happy holidays to you and your family sir. Thank you for the headup and now can’t wait to see the video. I’m sure you got this. As I said previously I have tried unsaved.form or valid but this doesn’t work with when global variable, as the form becomes in edit mode. Thank you so much for remembering my question.

  • @moechaba5322
    @moechaba5322 18 днів тому

    Hello Mr Andrew, Thank you so much for covering and mentioning my question. It was awesome to see how you made it look so easy but for me this is a stepping stone to getting to where I want to be. Brilliant work and thanks again for sharing your thoughts and knowledge with us. Respectfully yours Moe.

  • @vazaruspaytonas7017
    @vazaruspaytonas7017 19 днів тому

    Once you put the power app on the sharepoint page you can drag the corner of the power app web part to increase the size on the webpart on the page.

  • @rebeccac6492
    @rebeccac6492 19 днів тому

    Hi Andrew, thank you for this video! If you are in the UK, do you know how you would change the date format so that it shows DD/MMM/YY (sorry the Brits are always being awkward...) Thanks!

  • @rjvillanueva8039
    @rjvillanueva8039 19 днів тому

    can someone help, I've copied the exact formula but the Submit button still appearing even if fields are blank

    • @andrewhess123
      @andrewhess123 19 днів тому

      What's your formula? I'm guessing your fields dont match up to "DataCardValue9" are you on a different DataCardValue? Use the color coding too that Power Apps gives you to double check.

  • @thomasloia8874
    @thomasloia8874 20 днів тому

    Thank you Andrew, cannot wait for the next video. I always learn something new from your videos, today was the sharepoint import from excel function and the field_n names. I always wondered where the names came from in my code.

    • @andrewhess123
      @andrewhess123 20 днів тому

      Nice thomas! Yeah that drove me crazy forever 😋 Thanks for watching hope this next video is just as good!

  • @dustinrocksvold8650
    @dustinrocksvold8650 20 днів тому

    OMG My mind is spinning! Thanks for this!

    • @andrewhess123
      @andrewhess123 20 днів тому

      Woooo! Nice! Thanks for watching Dustin!

  • @nibgrahi5651
    @nibgrahi5651 22 дні тому

    Can we embed a power-app form in a sharepoint page, so that user does remain within sharepoint environment and update data in sharepoint list?

    • @andrewhess123
      @andrewhess123 22 дні тому

      Yes, you can also embed a power app into a list and replace the form.

  • @Tango_01
    @Tango_01 22 дні тому

    And how do I make it trigger with a date-type column? For example: if the user modifies the value and changes the date to any other?

  • @jameseric1018
    @jameseric1018 22 дні тому

    Does this work without having to add project start and project due?

  • @kenpennuto2590
    @kenpennuto2590 22 дні тому

    Thanks - if you read this. I followed another example of how to do this same thing except using gallery and then putting checkbox control inside it. Everything seems to work fine, with the exception of when my users create a new entry into the SP list, using the custom form, if they hit submit, and the form remains, waiting for another entry to the list to be made, there are ghost entries in the gallery checkboxes. I am using collections to store the values of what is selected but having no luck clearing that when the user would just continue to add another list item. I have labels present also that displays the selections / or contents of the collection when selections are made. They are incidentally clear when the new form appears, even though there is a ghost check in the boxes. Have you seen this behavior before/ any thoughts recommendations? Sorry, this was long, seems like there is a lot to explain and it's a complicated setup (to me).

    • @andrewhess123
      @andrewhess123 22 дні тому

      I have a couple guesses but if when the user submits and it makes a ghost entry, and you are using collections. You will need to recollect to populate your gallery, if your gallery is attached to the collection. When you say ghost in the check boxes, does that mean you have to click it more than once for it to recheck? Try modern and classic checkboxes too, is there a difference?

    • @kenpennuto2590
      @kenpennuto2590 22 дні тому

      @@andrewhess123 so the first time through the form, works fine. It is when the user begins a new form, after a submit action. The selections from the previous form submission are still checked, which is undesired. Interesting also is the label I have to troubleshoot and display what is in the collection indicates that the collection is empty at that time. User has to select another checkbox or uncheck and recheck to activate. So my issue is what remains after the first submission. Hope that helps clarify my issue. I used a gallery to set it up which is different from your method. I am going to try and set it up the way you did in video. Seems much less complicated.

    • @kenpennuto2590
      @kenpennuto2590 22 дні тому

      @@andrewhess123 thanks for the reply BTW! 🥹

    • @andrewhess123
      @andrewhess123 21 день тому

      @@kenpennuto2590 So I have seen something similar I can't remember exactly what I did... but on the OnCheck and UnCheck Property set it to UpdateIf(colDetails,ID=ThisItem.ID,{varCheckbox:!varCheckbox}).... and on the Checked Property set to ThisItem.varCheckbox

    • @andrewhess123
      @andrewhess123 21 день тому

      @@kenpennuto2590 I remember when I did this video there was this "Ghost Checkbox" as you were calling it. ua-cam.com/video/hIDRup4LcHE/v-deo.html I think this video is very valuable and one of my better videos 😋this one were commenting on is old and outdated.

  • @CédricCHEVALIER-y1d
    @CédricCHEVALIER-y1d 23 дні тому

    Incredible tip for transferring an Excel table to a SHAREPOINT list 😍😍😍😍 - Thanks a lot

    • @andrewhess123
      @andrewhess123 23 дні тому

      Hey Thank you Cédric! Hope it helps!