Randy Hayes
Randy Hayes
  • Видео 7
  • Просмотров 134 100
PowerApps - Add an "All" to your Dropdown Lists - Dynamically!
In this Quick Tip video we review how to add an "All" or "Choose" or any other indicator to a list that you can use on a Dropdown or Combobox or anything else. We will do it all WITHOUT collections and it will be Dynamic based on how the datasource changes.
Don't forget to Subscribe and Like the video and Follow Randy Hayes on Twitter at @RandyHayes.
Просмотров: 28 977

Видео

PowerApps Alternating Row Colors in a Gallery
Просмотров 15 тыс.3 года назад
This video is a Quick Tip on how to make your Galleries have alternating colors in each row to help highlight the rows of the gallery. Don't forget to Like and Subscribe and follow on Twitter @RandyHayes And a special shout out to Aroh Shukla who has provided some of his notes with direct jumps to places in the video: 1. Gallery1, set the Item properties of data source 1:44 2. We need sequentia...
PowerApps - Splitting Forms
Просмотров 20 тыс.3 года назад
Quick Tip - Ever wanted to make your EditForm span multiple screens or tabs? In this video I will show you how to split them up while keeping the functionality and features of the EditForm active and usable. (NOTE: This is specific to multiple screens or tabs where you truly are splitting the form. If the form is on the same screen and not split, there are other solutions to that which are quit...
PowerApps Forms Plus
Просмотров 14 тыс.3 года назад
Learning Series - PowerApps EditForms - pretty much everything you wanted to know and a whole lot more you never knew was possible. Style your EditForms like you've NEVER styled them before and change the whole user experience to joy! Don't forget to subscribe and like so you get notices for new videos as they are published. And, follow on Twitter @RandyHayes Table of Contents: 00:00 - Introduc...
PowerApps - Easy Screen Reset
Просмотров 15 тыс.3 года назад
Learning Series - Easy Screen Resets. How to create a centralized way to reset your screens to any state you want. Table of Contents: 00:00 - Introduction 00:11 - Intro 01:04 - Part 1 - Adding The Toggle 11:11 - Part 2 - An EditForm 16:59 - Ending And a special thanks to Aroh Shukla who has provided an alternate table of contents with much better markers based on notes he took: 1. Reset Screen ...
PowerApps Time Tracker
Просмотров 36 тыс.3 года назад
Solution Series - Time Tracker Table of Contents: 00:00 - Start 00:18 - Introduction 01:51 - Prerequisites 02:17 - The Final App Preview 04:21 - The SharePoint List 05:45 - Building The App 1:08:18 - Ending
PowerApps - Input Form Validation
Просмотров 4,9 тыс.3 года назад
Learning Series - Working with Built-In Forms (EditForms) and custom input forms (build your own). AND A BIG THANKS to Aroh Shukla who has made an awesome Table of Contents for this video (as I neglected to do so in the video). 1. Part 1: EditForms; Part 2: Custom forms 0:34 2. SPO Expense list Data types 2:38 3. Gallery and EditForm Sample 3:54 4. EditForm.Valid ; EditForm.Unsaved properties 5...

Комментарии

  • @Drenson1609
    @Drenson1609 13 дней назад

    I've just gone through this step by step and I receive a 'Network error when using Patch function: The requested operation is invalid'. Any idea if the process has changed since this video was made?

  • @andredoestech
    @andredoestech Месяц назад

    I wish he would show his whole screen and stop zooming in

  • @Wessex_broadcast
    @Wessex_broadcast 4 месяца назад

    OH THIS IS SO MUCH BETTER THAN COLLECTIONS! THANK YOU

  • @doja3527
    @doja3527 5 месяцев назад

    Too fast and not well explained. Nothing for beginners. 😢

  • @ahmadfallah9528
    @ahmadfallah9528 5 месяцев назад

    Thank you. That was very helpful. I learned very much. I would appreciate it if you could help me with reporting each person every day in/lunch/out times in one row or export it to an Excel file!

  • @marcelsjardijn9257
    @marcelsjardijn9257 5 месяцев назад

    Thank you very much! Very helpful

  • @Saratoga55
    @Saratoga55 5 месяцев назад

    XLENT!

  • @H.Olluri
    @H.Olluri 5 месяцев назад

    Excellent Videos, it will be nice to see how to intergrate location list as home office, office, ..

  • @user-zc5hs3hr2m
    @user-zc5hs3hr2m 5 месяцев назад

    TY Randy! Great videos and very informative and entertaining. Nice work Sir!

  • @nonoobott8602
    @nonoobott8602 6 месяцев назад

    Very insightful video. Thanks for sharing

  • @RichardJones73
    @RichardJones73 6 месяцев назад

    This is a very good tutorial Randy. Good explanation of what is happening. However, I am unable to get the Fill to work. I am able to add a label with rowNumber just fine, but when i type ThisItem.rowNumber, intellisense isn't picking it up (not sure if this is the problem of the formula though, but the if statement is erroring with some invalid arguments If(Mod(thisitem.rownumber,2)=0, Color.LightGreen, Color.LightGreen) is my formula

    • @RichardJones73
      @RichardJones73 6 месяцев назад

      Ignore me. I was putting the formula into Fill property not TemplateFill. D'oh. I'm not sure what each one of those does but never mind, its working now

  • @HealthFitness-hn8sz
    @HealthFitness-hn8sz 6 месяцев назад

    Randy, i'm using Microsoft Lists and created custom form using your teqnique but instead of creating the gallery, I had the data go to the Microsoft list, but now when I click on an item on the list, it doesn't pull the data to edit. Is there a way to fix that?

  • @gregfenwick4906
    @gregfenwick4906 6 месяцев назад

    Great work, very clever use of the master form and I like the fact this is very simple. Learned a lot from watching this and have replicated for some projects. Keep up the good work. 👍

  • @imran002ali
    @imran002ali 7 месяцев назад

    Hi Randy, this is my first time watching your video, it's awesome!! Also, you have solved one of my issue, I have created a booking app which prevent double booking (it works fine) but I want to recreate the app but avoid using "Edit Form", or use individual component, my issue was, I couldn't find the "Update Data Card", you have solved that issue, thank you! 👍👍

  • @girlontheswing3942
    @girlontheswing3942 7 месяцев назад

    Thank you very much for this great video on creating powerapp

  • @user-cq7vd9qr5d
    @user-cq7vd9qr5d 7 месяцев назад

    This is fabulous and very close to what I need. I have a list that is completed by one person when a NEW item is received but a second person needs to add one field only that would then trigger some planner tasks. Can this be done? I haven't been able to find answers to this and I'm so green with power apps.

  • @captainmeadows6307
    @captainmeadows6307 7 месяцев назад

    Good stuff! Thanks for this

  • @gauravguliani358
    @gauravguliani358 7 месяцев назад

    Randy is the most skillful Power Apps person I ever came across Add to it the fact he loves helping and is so calm I truly miss working on Power Apps because it allowed me to be in touch with him Miss you Sir, wishing you good Luck

  • @federicovalencia8615
    @federicovalencia8615 8 месяцев назад

    Randy, how the script should be re-write if all the records were associated with, let’s say, a different “customer” ? In other words, in my gallery, when filter , it brings records associated with another customer. Hopefully I have explained correctly so you can guide me. Thank you

  • @zerocool200380
    @zerocool200380 10 месяцев назад

    Hi Randy, this is great. a quick question : what changes we need to do if the choice column allow multiselect?

  • @Kaybelo_
    @Kaybelo_ 10 месяцев назад

    Hi Randy, if i decide to do a lookup separate for each button which property should I use to achieve the exact same output??

  • @jt9228
    @jt9228 10 месяцев назад

    Love, love this video! This solves what I am trying to do (break long records into multiple cleaner looking forms). Thank you for sharing! 💚❤💛🧡

  • @tylergreenwood3636
    @tylergreenwood3636 10 месяцев назад

    Extremely helpful! Thank you.

  • @gcooper642
    @gcooper642 10 месяцев назад

    It's difficult to work out what is being edited at certain point because the tree view is off screen.

  • @shalom9234
    @shalom9234 10 месяцев назад

    What if we have 5000 items in the data source?

  • @noorkalboneh178
    @noorkalboneh178 10 месяцев назад

    Network error when using Patch function: Field 'cr273_name is required. why error and how solve

  • @user-mp5vs4vq5l
    @user-mp5vs4vq5l 11 месяцев назад

    Hello! first of all, this video is fantastic and very well explained! I am beginning working with Power Apps and it helped me a lot do exactly what I needed. So big thanks! I have one question though: I am working with a Sharepoint list and, when I want to remove a register, it's not working. I can see the item disappear in the gallery but not in the actual list. I wonder if it has anything to do with the way the form is split but it shouldn't, right? Thanks a lot in advanced!

  • @towfiquekabir3952
    @towfiquekabir3952 11 месяцев назад

    Hi, can anyone assist me here, I am trying to get the "ShortTime" function to work here but it won't update on the buttons when its clicked. In the video it is from 28:30 Any help would be appreciated.

  • @johnpereira3433
    @johnpereira3433 11 месяцев назад

    Hello randy I want to track the break timming at work but I don't have the activity type I want to capture 5 different types of break all in one column for on individual which had individual log in and log out time with their headers on the table please can you help me with this

  • @antonioskokiantonis7051
    @antonioskokiantonis7051 11 месяцев назад

    Awesome stuff!

  • @ASHISHKUMAR-fi2kn
    @ASHISHKUMAR-fi2kn 11 месяцев назад

    Thanks for the video Sir. I'm stuck in one scenario, I have a combobox which is connect to a data source and based on the item selected in that combo box items are filtered in gallery. I want to select all the items in that combo box automatically when the page load where the combobox is placed. How I can achieve that?

  • @rachelpatterson4384
    @rachelpatterson4384 11 месяцев назад

    It took me a couple of hours, but as a complete PowerApps beginner, I could follow along because your explanations were so clear. Thank you!

  • @victornassiff7578
    @victornassiff7578 Год назад

    What about the attachment field, how can we make it work?

    • @victornassiff7578
      @victornassiff7578 Год назад

      if anyone need this is the solution: if the data card from the attachment field is named datacard1 you need to place it in the main form attachment field in the item property of the data card like DataCardValue1.Attachments and it will work, hope it helps anyone.

  • @sharepoint1231
    @sharepoint1231 Год назад

    Thanks for the video Randy. May I have one question? I need to add a grid gallery (excel like grid) at the middle of the form, we got few of those requests, seems quite common cases. The gallery needs to point to a different Dataverse table as the main form datasource, in this case, how I can fit the gallery inside the middle of the form? I tried to add the gallery inside a datacard, for SharePoint DataSource it works, but for Dataverse DataSource, the gallery is not able to visible. not sure if I did anything wrong for datacard does not support Dataverse gallery when it has different DataSource as the form. Can you please give some suggestions for how to fit a gallery inside a form? Thanks!

  • @kamranpatel2998
    @kamranpatel2998 Год назад

    Hi how can we make it auto selected if its a check box control in which 'Select All' option is selected all options should get select in power apps

  • @kwilliams1130
    @kwilliams1130 Год назад

    Great Video! Thank you for explaining it so thoroughly and taking the time to create it.

  • @gserrano1088
    @gserrano1088 Год назад

    Thank you so much! I was struggling greatly with my app and this just solved my 2 week headache! Greatly appreciated

  • @user-qy4ps3lj8i
    @user-qy4ps3lj8i Год назад

    this is an underated tutorial. absolutely genius. it was the answer to my problem. i had one form split between two screens. every tutorial, to return the last submit to make a "Review" screen said i had to .lastsubmit. but that only works with one screen. shear genius. i like the use of one variable. i did disable and hide my gallery though

  • @jae13204
    @jae13204 Год назад

    Too fast.

  • @tricacole
    @tricacole Год назад

    Does it work in dataverse?

  • @StefanvonHusen
    @StefanvonHusen Год назад

    That's a tutorial. It doesn't get any better than this and the potential has been fully exploited. Can I have some more, please!

  • @user-nv4wv1pb8o
    @user-nv4wv1pb8o Год назад

    Spend hours to find this solution on internet. Finally found this video. Thank you.!!

    • @tricacole
      @tricacole Год назад

      Does it work in dataverse?

  • @moyura2
    @moyura2 Год назад

    Thank you for sharing this useful information even in 2023.

  • @robertposton2505
    @robertposton2505 Год назад

    Hey Randy. This is fantastic. Thank you. I'm trying adapt this to track temp employee's times utilizing a dropdown with the temps names to log the check in/out times. rather that the glbuser id. Any suggestions on where to begin with that.? I've created a separate list with temp names to populate the dropdown, however unsure how to adapt the response from that to act as your glbuser did on the Time Tracker list. Any advice would be greatly appreciated! ~Robert

  • @davidseverino3489
    @davidseverino3489 Год назад

    Normally forms do not have a collective on the final screen as you demonstrate. In the case, how can you submit all the collected data using the SubmitForm command if the fields are not present on your final screen? To get around this, I added all the fields used in the previous screens but turned off their visibility. Curious to know if you have a recommendation.

  • @davidpowell2332
    @davidpowell2332 Год назад

    Randy, Great App....I 'm trying to switch to a sql server table ? But now the times will not switch on the button when logging in etc? Should that make any difference. ?

  • @user-mk1tb4eh8m
    @user-mk1tb4eh8m Год назад

    Thank you so much for posting this, when I created the app though my clock in times for my buttons all defaulted to 12:00 am and I cant seem to get them to update correctly to the actual time. Also when I added the time change option it all works but it doesn't update the time on the main screen. From what I can tell all of my codes matches yours.

  • @turisabela
    @turisabela Год назад

    Hey, Great Video! Thank's a bunch!

  • @nguyenthach8103
    @nguyenthach8103 Год назад

    Can you add more: Employeer Name and email?

  • @markherman9561
    @markherman9561 Год назад

    Thank you Randy. Here's a formula based on a people field in a SharePoint List. All is at the top, otherwise sorted by the DisplayName (Last,First) of the people field With ({lclChoices: Sort(ForAll('MySharePointList',ThisRecord.MySharePointPeopleField),DisplayName)}, ForAll( Sequence(CountRows(lclChoices)+1), {Value: If(Value=1 ,"All" ,(Last(FirstN(lclChoices, Value-1)).DisplayName) )} ) )