@Reza Dorrani is the kind of man that I wanted to meet in person and hold! His videos help me an awful lot and if i know Power apps, i owe him. I am really thankful 😍
@RezaDorrani
Жыл бұрын
Virtual 🤗
@anniebhutto6012
Ай бұрын
me too
@ganeshhon8345
Жыл бұрын
A few months ago, i started a career in SP and Power apps, i enjoyed your video, it completely guides me. Thank you so much.
@RezaDorrani
Жыл бұрын
You’re most welcome
@SarahHurd-y1b
Ай бұрын
Thanks a ton for this video! I generally prefer written tutorials, but I was unable to find this solution anywhere else. This was a huge help as I revamp our current SP forms using PowerApps!
@RezaDorrani
Ай бұрын
Most welcome! Videos are better 😉
@MrAll2001
11 ай бұрын
Thank you, Reza. Your videos are a starting point when I need some Power Apps functionality
@RezaDorrani
11 ай бұрын
Glad to hear that!
@shrutisingh3682
Жыл бұрын
Awesome! It worked perfectly for me. Now I have more clarity on the checkbox part. Thanks, Reza 👌👌
@RezaDorrani
Жыл бұрын
Happy to hear that! Thanks so much for watching
@debravidrine404
Жыл бұрын
This video is what I have been looking for. Keep sharing. You are awesome!
@RezaDorrani
Жыл бұрын
Thank You
@TheFunkBros
Жыл бұрын
Very good, I used this logic to update a single line text field with multiple items from a separate list and it works like a charm
@RezaDorrani
Жыл бұрын
Thanks for watching
@davidl3346
Жыл бұрын
Did you use the values from another list with the "look up" column type? I am trying to do that now
@vincephillips5358
Жыл бұрын
Great work 👏 👍 Lovely logic around Multiple Checkbox.3 I have now added this into my "Useful UI" component 😁😁😁
@RezaDorrani
Жыл бұрын
Glad it was helpful!
@jaimekins
9 ай бұрын
this is great!!!! so appreciate all your videos.
@RezaDorrani
9 ай бұрын
Thanks Jaime
@hasminnavoa7864
Жыл бұрын
glad I came across this video! trying it now!
@RezaDorrani
Жыл бұрын
👍
@Andrico77
Жыл бұрын
Perfect timing!!! Thanks you the best man.
@RezaDorrani
Жыл бұрын
Thanks Andy
@hobbymanlp
Жыл бұрын
Awesome content! You have helped me so much with my own Power App tasks.
@RezaDorrani
Жыл бұрын
Great to hear!
@WaliSayed
Жыл бұрын
Thank you for your contributions, these videos are very helpful!
@RezaDorrani
Жыл бұрын
You're very welcome!
@yaosetariasky279
2 ай бұрын
reaaaallllyyyyy useful!!!!
@RezaDorrani
2 ай бұрын
Glad to hear that!
@jdanderson0261
Жыл бұрын
Great stuff, Reza! Thanks again.
@RezaDorrani
Жыл бұрын
Glad you enjoyed it!
@hljones1885
Жыл бұрын
This is outstanding! Thanks for creating.
@RezaDorrani
Жыл бұрын
You’re most welcome
@DataisKing
Жыл бұрын
Another great video. Thanks Reza!!!
@RezaDorrani
Жыл бұрын
Glad you enjoyed it!
@oluwatobipaul6171
Жыл бұрын
Thank you so much Reza for another awesome content
@RezaDorrani
Жыл бұрын
Most welcome
@DroneEyes
Жыл бұрын
Very cool video AGAIN Reza !!!
@RezaDorrani
Жыл бұрын
Thanks Vincente
@sahrar
11 ай бұрын
Great instructions. Thank you so much 🙏
@RezaDorrani
11 ай бұрын
You are so welcome!
@bzflowerbee
Жыл бұрын
Excellent! I'm currently working on something like this. This helps me big time. Thank you.🙏
@RezaDorrani
Жыл бұрын
Glad it was helpful!
@meskiy1967
Жыл бұрын
Always love your video Thank you so much
@RezaDorrani
Жыл бұрын
Thank You 😊
@richardrogers2110
Жыл бұрын
So helpful! Thank you.
@RezaDorrani
Жыл бұрын
You are so welcome!
@killbgizhou
6 ай бұрын
Thank you VERY much for this tutorial. It helped me a lot :)
@paolovr1970
Жыл бұрын
Thanks Reza 🙏🙏🙏
@RezaDorrani
Жыл бұрын
Welcome
@craig7520
Жыл бұрын
Very elegant - cheers Reza! 👌
@RezaDorrani
Жыл бұрын
Thanks Craig
@jackemanalo7741
Жыл бұрын
Awesome and informative
@RezaDorrani
Жыл бұрын
Thanks
@ImGumby49
5 ай бұрын
Thanks for all your information and method of presentation. I have reached out to the Power Forum Community but haven't received any feedback. Do you have any videos on how to use radio buttons and specifically how to clear when users accidently select a choice?
@RezaDorrani
5 ай бұрын
Most welcome! I'm not sure if I have a video on that.
@desipher
5 ай бұрын
Great Video as always Reza! I have run into one issue with the multi select checkbox gallery control that I may need assistance with. When I submit a form and/or reset the form, the choice column check boxes are all selected. I want this to be blank when a user is submitting a new form. I have all my resets in the correct spots I believe, but I can't seem to figure this one out! Thanks
@RezaDorrani
5 ай бұрын
I have not come across this issue 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
@RinatTarzumanov
Жыл бұрын
Reza you a best! Ty
@RezaDorrani
Жыл бұрын
Thanks Rinat!
@user-th6zf8dz3j
5 ай бұрын
Genius!
@RezaDorrani
5 ай бұрын
Thanks
@davidnelson579
11 ай бұрын
Excellent explanation and demonstration, thank you!! I'm running into one issue after submitting the form to the SharePoint List - which works perfectly, however after submitting I want to ResetForm - the checkboxes don't clear. The related drop-down (which is hidden) clears, but the ResetForm doesn't appeara to clear the checkboxes. What am I doing wrong?
@RezaDorrani
11 ай бұрын
Thanks. I have not come across this issue hence not sure what you may be doing wrong. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@pauls9170
Жыл бұрын
This is a great video but I have a question about using the data after a users selects one or more checkboxes. I want to have other data cards that are visible only if the user checks a certain checkbox. I feel like this is easy in other scenarios but here it seems a little difficult to me.
@RezaDorrani
Жыл бұрын
Sine data is in collection, you could simply check if item exists in collection and accordingly show or hide. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@shaikhfirdos2723
Жыл бұрын
Great video..🙏👍
@RezaDorrani
Жыл бұрын
Thank you! Cheers!
@ImGumby49
9 ай бұрын
Thank you Reza. Can this also work in a filter pane where there is no DataCard?
@RezaDorrani
9 ай бұрын
Should work
@tejaspatel5247
8 ай бұрын
Hi Reza, thank you for all the informative videos. I had a quick question, in the video above is it possible to make the check boxes responsive? I tried using your method to convert a combo box into checkboxes but when I play the app in Phone view half of the checkbox contents are cut off. For reference, the screen has a vertical container -> form -> DataCard -> Gallery -> CheckBox
@RezaDorrani
8 ай бұрын
Welcome! Possible is my guess but not something I have tried.
@tejaspatel5247
8 ай бұрын
Ahh, thank you for the prompt response. I will dig in a little bit and see what I can find.@@RezaDorrani
@mattkidd8428
Жыл бұрын
Hi Reza, You create great instructional videos, very detailed and easy to follow. I used this to create checkboxes on a form and it worked brilliantly, but I was running a flow which was to extract the check box choices (for an email) but the 'for each' loop for the choice field does not loop though all checkbox items. In other words if there are 3 checkboxes selected the for each only loops twice. I selected 3 checkboxes without using the form (gridview) and it, then works and loops through all 3. The only thing I have managed to work out is that the checkboxes go in a different order using the form or in gridview.
@RezaDorrani
Жыл бұрын
Firstly check to see when you save the form, does it show the updates in the data source. If no, then something is not done correctly in the checkbox. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@mattkidd8428
Жыл бұрын
@@RezaDorrani Hi Reza, Yes it does show the form checkbox updates on the sharepoint list immediately after save. Just doesn't loop all checked values with the 'for each' loop for the choice field. I will post the issue on the forum.
@aleshiajefferson2261
Жыл бұрын
@@mattkidd8428 did you find a solution to your looping issue? If yes, will you please share the link to your post?
@IndiaZindabadh
Жыл бұрын
@@mattkidd8428 Hi Matt, have u tried using counter for the same?, is it resolved?
@Jas-p3i
4 күн бұрын
Hi Reza! Thank you so much for this, it was extremely helpful!! I did have one question- I have a reset form button that I cannot get to reset the gallery we created or the checkboxes. I understand that you did this by setting the variable to blank within the forms onSuccess. I am using a standalone Power App so I attempted to put this into my Forms OnReset but I am still having no luck :( Thank you again.. you have saved me so many headaches!
@RezaDorrani
4 күн бұрын
Most welcome! I have not experienced the mentioned issue, hence not sure of what options to take. I will recommend checking or posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@Jas-p3i
3 күн бұрын
@@RezaDorrani Thank you! I found a few articles there but none of them followed the exact setup we have here. I did work out a solution though for anyone else wondering: 1. Set the OnVisible of the screen to: Set(varCheckboxReset, false) 2. Then on the Reset property of the checkbox add: varCheckboxReset 3. Then on the onSelect of your reset button, add: Set(varCheckboxReset, true); Set(varCheckboxReset, false); Thank you again Reza! You are my Power Apps hero!🦸♀
@RezaDorrani
3 күн бұрын
@@Jas-p3i Thank You so much for sharing. It would surely help others.
@superlaffin39
Жыл бұрын
Great Vid! I wonder if you can also create a tutorial , where if the check box (check all) from outside the gallery grid is checked only the filtered items in the grid will be selected, because at the moment from your bulk update video, it only select all items in the grid, what if you have filters and you make filters in the grid before you select all items?
@RezaDorrani
Жыл бұрын
That would be a bit more complex. I have no plans for a tutorial on that. Might be a good idea to give it a try and/or check or post your query on forums at powerusers.microsoft.com
@joannezhu101
Жыл бұрын
Very helpful video, much appreciated for your great work. I found I always learnt so much from your video. Another question - if a gallery is reading data from a different sp list (not the same source where the form gets data from), is there a way to implement this gallery?my gallery shows null when I cut-paste it into a form custom card.
@RezaDorrani
Жыл бұрын
Thanks so much for watching and learning from the videos. I would say it is possible. Not sure why your gallery shows null. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@penumurumohith247
5 ай бұрын
Hi Reza, I've implemented the combo box to multi select checkbox in normal forms and data source as Sharepoint list I've done as it is you've shown I'm able to update the values from the form buy while viewing and editing the form from gallery control in my main screen I'm not able to see default selected items from the sharepoint list it's showing blank boxes instead. Could you please help me with that. Thank you.
@RezaDorrani
5 ай бұрын
I have not come across this 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
@sumaiyamahmud7748
11 ай бұрын
Fantastic video Reza! I have a question though. I created a form using a blank vertical gallery and connected it to my sharepoint list. However, when I click on Preview, it shows me a blank screen. There is also no option for "New" in Display mode. What am I doing wrong?
@RezaDorrani
11 ай бұрын
I have not come across this issue 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
@kalaiherko5034
Жыл бұрын
Hi Reza! Love, LOVE, L-O-V-E you! I'm still a beginner but watch your videos often enough that I can rely on them to get me out of a pickle! Was wondering if you made a tutorial, using this method of checkboxes, and sending the checkboxes selected by a user to another user via email (from the app or using Power Automate). I'm using this app to communicate which compliancy documents are missing/which ones have been recieved/which ones have been rejected, and why . any insight would be super helpful! Thank you!
@RezaDorrani
Жыл бұрын
Thanks so much Kalai! I do not have a video reference on sending the checkboxes information selected by the user. You have the checkbox selection information in the collection, simply use the Concat function to get data from collection as a string and then send it in email.
@klr097
5 ай бұрын
Hi Reza, your videos have been a life saver! I'm trying to create a form with 50+ different checkbox questions (i.e., you'd be repeating your "Category" here 50+ more times with different values for each question). Do you have a tutorial somewhere on dealing with checkboxes for large data sets like that? It would take forever to do it one by one like the way shown here and I'm having trouble finding anything online that shows how to do this. Thanks!
@RezaDorrani
5 ай бұрын
I dont have a video for a scenario with large schema (not large data sets)
@spen2431
Жыл бұрын
Boom ! 💥💥
@RezaDorrani
Жыл бұрын
Thanks Spen! I wish the video had boomed as well :)
@vishaljain2842
Жыл бұрын
Thank you for the video Reza. I have a sharepoint list with multiselect options. In my powerapp, I have a drop down for these options. I want to filter items in a gallery in powerapp based on the selection made in drop down. Can you please guide how to do that?
@RezaDorrani
Жыл бұрын
I have done many videos on gallery filtering. I would recommend checking those.
@ItsMeProday83
Жыл бұрын
Thanks Reza!
@RezaDorrani
Жыл бұрын
Most welcome!
@susheil76
9 ай бұрын
@Reza Dorrani Thanks for the article. I am a newbie to Powerapps and It was really helpful. I do have a question though. In my case, the dropdown control was a required field, so now I am getting the "Required field" error. How do I overcome it ? Thanks
@RezaDorrani
9 ай бұрын
Even if you are setting a value and you are getting error, it means your value is not saving to list and something is not configured correctly at your end. I recommend posting your issue on forums at powerusers.microsoft.com
@susheil76
9 ай бұрын
@RezaDorrani Thanks. I was able to get that working now. There was a typo. I now have a different question. I want to provide a "Select All" checkbox which selects/unselects all the checkboxes in the gallery control. How can we achieve this ?
@RezaDorrani
9 ай бұрын
@@susheil76 I would have to try it out to give the steps :)
@user-vv8jp5vq9f
9 ай бұрын
Hello, Thank you for the video. Question: When we have 2 checkbox columns, Are we supposed to set 2 different variables and blank them both on the SharePointIntegration properties ?
@RezaDorrani
9 ай бұрын
As per technique shown in video, Yes
@tihralahn
Жыл бұрын
Wow fabulous! Thank you so much :) I had a whole string of stuff I was trying to do OnVisible on the form and nothing was clearing it.
@RezaDorrani
Жыл бұрын
You are most welcome! Glad to hear the technique demonstrated is simple and helps solve a problem.
@michellekelly1704
Жыл бұрын
Hi Reza, i am new to power apps and love your videos. I used this video to create multiple checkboxes under a gallery. Since there are 25 checkboxes and most times 20 of them will always be selected. I want to set the default that they are always "checked" and then user just unselects those that are not applicable. I am able to set the default to true, but within the sharepoint list, when user sees all items checked and has no changes and saves, it is not retaining all the values in the sharepoint list...it shows blank. How do I resolve this?
@RezaDorrani
Жыл бұрын
I will have to see your app in action to know the reason for your issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@michellekelly1704
Жыл бұрын
@@RezaDorrani thank you. I will do that now
@michael498176
8 ай бұрын
Awesome Video, Reza! How to add a new choice that is not in the existing choice list in Power Apps?
@RezaDorrani
8 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@michael498176
8 ай бұрын
Thank you, Reza!@@RezaDorrani
@IMChrisThom
Жыл бұрын
Once again and fantastic video though I have a question. Using the checkbox, how could you change a data card's visibility when certain checkboxes are selected. In other words, when someone choose A for example, a follow up question related to A would appear. The same for B and so on if needed. Thank you for any insight you can offer.
@RezaDorrani
Жыл бұрын
Idea would be to set visibility of data card based on the value existing in collection which drives the checkbox. I would have to try it out to give exact code, hence sharing the idea.
@IMChrisThom
Жыл бұрын
@@RezaDorrani That's what I was thinking. The sticking point for me was how to change the visibility based on a certain checkbox being selected. Thank you for any help you can offer.
@tttrw4784
Жыл бұрын
Hi Reza, Thank you for this tutorial. I followd your istructions in your last segmant (multi select) but now the default for my datacard has an error "Expected Record value". also, when i publish to the SP list, if i edit an existin item or if i create a new line and select any checkbox or more than 1 checkbox, if i save the choices, the choices that i selected in the checkbox are not displaying. any thoughts?
@RezaDorrani
Жыл бұрын
My guess is your column is not of type choice MULTI SELECT. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@tttrw4784
Жыл бұрын
@@RezaDorrani thank you
@user-kl6ks1tm9p
Жыл бұрын
Reza, This is SO helpful. Wondering if you can help me understand a specific use of checkboxes. I put a gallery in my datacard to create a list from a multiline column in SP. Next to that checkbox list, I added a text box to capture the user who checks the box. I would like to have that user saved back to my SP list. When I check the box, the name is populated, and then when I save the info, it is not retained anywhere in the SP list. I thought I might need to add a column to the SP list to hold this user info, but since that user text box is technically part of the subgallery it is already associated with the original SP column. I am at a loss of how to capture this user info in my SP list. Do you have any ideas?? Thank you in advance for any insight you can provide.
@RezaDorrani
Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@robertnguyen7519
29 күн бұрын
Hi @Reza, thank you for your help. I got it working but one issue shows up when I uncheck one of the checkbox all the checkboxes are unchecked but the data variable for that hold the checkbox's value is not empty. Do you know why?
@RezaDorrani
29 күн бұрын
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
@GorgyJan
Жыл бұрын
This is exactly what I was looking for with a clear and step-by-step instructions. Superp job again Reza. However, I have two requirements with multi-select. 1) is to add a free text box for each corresponding choice for users to insert specific folder locations for example for data storage location I have local vs network drives and then what folder are data stores Drive Letter Specific Folder (Free Text) C: \Project1\data D: \Project1\data L: \Project1\data The second requirement is to add the "Others - Please Specify" option to multi-select and when this option is selected, then users are presented with a free text box to input what they desire. Last, how to capture the free text in both scenarios in the SharePoint list that corresponds to the choices? Thank you
@RezaDorrani
Жыл бұрын
I would have to try both your requirements to know how it can be done. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@GorgyJan
Жыл бұрын
@@RezaDorrani Thank you. I have already checked both the Forums and KZitem and couldn't find the exact match. Maybe the wording of my search didn't produce results. The other option that I am going to try now is to ask ChatGPT. In fact, ChatGPT gave me the right clue on how to do Nested Tabbed Form where my post on Forums still has no response. Thank you again.
@RezaDorrani
Жыл бұрын
@@GorgyJan Keep trying with forums and chatgpt.
@ericvanderknaap835
Жыл бұрын
Hi Reza, thank you very much for all your amazing videos. I have learned so much.. I have a question. I followed along with this video and tried to implement the choice column the same way you demonstrated in my own application. The difference is that my application connected to a sharepoint library in stead of a list. When I implement the choice column on the first or second form, everything works just fine. However, when I implement the field on my third form it won't submit. Only after repeatedly changing the value it will eventually show. Do you know what might be the problem here ?
@RezaDorrani
Жыл бұрын
This should work both with lists and libraries. I have not come across an issue with needing multiple tries to submit hence not sure what the reason for your issue may be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@ericvanderknaap835
Жыл бұрын
@@RezaDorranithank you for your answer. You are right it should work both on lists and libraries. I discovered the issue is submitting the third form of my application. When I implement the field in the third form, I get the issues I mentioned earlier. When I place the same choice field in the second form it works like it should. So right now I am trying to find a way to solve that. All the settings are the same because I duplicated the screen. So I have a brand new challenge. If you have any ideas you're more then welcome. I will also try the platform. Thank you!
@RezaDorrani
Жыл бұрын
@@ericvanderknaap835 I do not have any ideas as I would have to reproduce the issue to know the reason behind it.
@lakshminarasimhulu8710
Жыл бұрын
Hi Reza, it’s very nice video thanks for it. Have question on it how can we make some selections default or based on some conditions how can we select on edit form. Thanks
@RezaDorrani
Жыл бұрын
Idea would be to load data in that collection that the checkbox uses. I do not have a specific video reference on this - hence providing the idea.
@lakshminarasimhulu8710
Жыл бұрын
@@RezaDorrani Thanks for the idea, i am new to the power apps. if possible can you share any reference link it will be grateful.
@RezaDorrani
Жыл бұрын
@@lakshminarasimhulu8710 I do not have any reference links for this. Try checking or posting your query on forums at powerusers.microsoft.com/
@lakshminarasimhulu8710
Жыл бұрын
Thanks @@RezaDorrani
@daisyjoieviray328
4 ай бұрын
Hi Reza, I am currently working on a form and encountering some issues with the look-up. I have a column for Country (which is a look-up type in SharePoint- I have a separate list for Country), and I used a combo box for it in Power Apps. The reason is that for every selection of Continent, the options for Country will be filtered based on Continent. My issue is that every time I select multiple values for Country field, it only stores the last selected value. Hoping that you could help me with this. Thank you for the informative videos, as always! :)
@RezaDorrani
4 ай бұрын
I have not come across 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
@randomperson2538
Жыл бұрын
Amazing video Reza, showing me things i did not think possible! Edit: it just started working now haha, not sure what I did Only one question: I've got a form with 5 different multiselect box sections. Ive attempted to copy your method for each additional one, but each section beyond the first does not save the selections to the multiselect column. I think its got something to do with the SharePointIntegration object. Ive simply added the code in separated via semicolon i.e. Set(varCategoryData,Blank()); Set(varCategory2Data,Blank()) ; NewForm(SharepointForm1) Am i doing this wrong? What would be your method for multiple, multiple selections?
@RezaDorrani
Жыл бұрын
You are most welcome! I have not come across the mentioned 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
@flaviosouza3860
3 ай бұрын
Good morning my friend. I'm from Brazil and follow your teachings and tips. I would like to know how to record these checkbox options in SharePoint in the card order, not in the user selection order. Can you guide me?
@RezaDorrani
3 ай бұрын
I’m not sure how to do that. Not something I have tried or have a video reference for.
@StephanJoseph
2 ай бұрын
You are a timesaver for me ⏱ THX 🙏
@RezaDorrani
2 ай бұрын
Glad to help
@ChrissyWhitby
Жыл бұрын
This was an awesome video! I do have a question though - when I save, my checkboxes act like the demo, but my field isn't populated. Now, my field (list column) is a lookup to another list to make it flexible. Could that be why?
@RezaDorrani
Жыл бұрын
Important is to set the value based on what your field type is. Lookup columns have a specific format. I have done some videos on Patch function and shown behavior of lookup column type. Give those a try.
@ChrissyWhitby
Жыл бұрын
@@RezaDorrani Do you have a link to said videos? This is how my form is acting - if I leave the lookup field for multi select visible and use it to select, the checkbox table is updated, but not the other way around.
@RezaDorrani
Жыл бұрын
@@ChrissyWhitby Search for videos on Patch function in power apps
@user-jq3ul4qy6j
10 ай бұрын
@Reza Dorrani Hi, I am using this in a canvas app connected to a sharepoint list. I followed every detail, except for adding the "Saveform" formula to the submit button on the canvas. Unfortunately, this is only erasing the existing data in the column that I want to update with the check box. The variable correctly contains the checked items, but this is not being passed to sharepoint. Any idea of what may be going on? The result column is also a lookup column with multi select enabled, not sure if that is the problem
@RezaDorrani
10 ай бұрын
I have not come across this issue 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
@peterbennett7983
Жыл бұрын
I admit that Power Apps is not my strong suite. Your tutorial was perfect, and it worked perfectly. Question for you, I have a 3 item choice, how can I check if the second checkbox is checked in a formula on another field to control its visibility. I want to basically put in logic that says IsMatch(Gallery1.Selected.Value,"Cut Shop") and if the item called Cut Shop is selected, then it will show this field, otherwise it will hide the field. The above syntax works only if the "Cut Shop" is the last thing checked. It should be something simple, but I can't figure it out. I tried Search(varCategoryData, "Cut Shop", "Value") but got a syntax error.
@RezaDorrani
Жыл бұрын
If using same collection technique in video. You can check if “Cut Shop” in collection. I will have to try it out to provide exact steps. Give it a try and in case of issues try posting or checking on forums at powerusers.microsoft.com
@peterbennett7983
Жыл бұрын
@@RezaDorrani I created a text field, and used this syntax, and it sort of worked: LookUp(varCategoryData,Value="Cut Shop", true). It returns True if the value is found, and false if not. But the only problem is that it when I edit the item, I guess the varCategoryData field is blank from the OnEdit action. How do I pre-load the varCategoryData table, or am I doing this all wrong?
@RezaDorrani
Жыл бұрын
@@peterbennett7983 Its difficult to direct here on chat. I will have to reproduce your scenario to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@peterbennett7983
Жыл бұрын
@@RezaDorrani OK, I will do that. Thank you very much for your guidance!
@user-sm5pv5pg7v
Жыл бұрын
For a single card it works just fine, but I've tried to do the same thing for multiple cards however when I submit the form the columns that are multi select are blank on a sharepoint list. Not sure what to do here as for each one I've changed the names of the values e.g. the first the checkbox was called Checkbox2, so for the next card its Checkbox2_1 and each name is used correctly in the their respective formulas e.g. Set(varCategoryData1, ShowColumns( Filter(Gallery1_1.AllItems,Checkbox2_1.Value), "Value")) . Any help appreciated :)
@RezaDorrani
Жыл бұрын
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@alkaprakash2301
Жыл бұрын
Another gr8 video Reza!! But I have one question, I have 6 checkboxes. 5 has normal selection but if 6th checkbox will select then one input box will be disable or enable based on the selection. Suppose we click on 6th one ( named, other reason plz specify) then one input box will be enable and user will mention the reason and it will also save in SP list. How we can do this, please suggest me!! Thanks
@RezaDorrani
Жыл бұрын
I do not have a video reference on this scenario and will have to try it out to provide guidance. I recommend posting your query on forums at powerusers.microsoft.com
@TravellerStories91
28 күн бұрын
@Reza Dorrani, I am able to setup this but when editing from sharepoint ,after saving it is not getting updated on sharepoint list. Any help here pls
@RezaDorrani
28 күн бұрын
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
@poojadhingra89
Жыл бұрын
Trying to implement the Multiselect check box in gallery functionality. And its not saving the data when selecting options from checkboxes.
@RezaDorrani
Жыл бұрын
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@nodirjonsattarov6296
3 ай бұрын
Is it possible to return the time/date that the progress list was updated to the specific value? For example, it defaults to "not started", however when it get updated to progress is there a way to return that date/time? then again when it is switched to 'completed'? Thanks!
@RezaDorrani
3 ай бұрын
Should be possible but not something I have tried so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@shakeelss786
24 күн бұрын
How do I integrate an existing application with a SharePoint list to use the multiple check boxes selection option?
@RezaDorrani
24 күн бұрын
This technique works with new and existing apps. You simply need the form control.
@TravellerStories91
Ай бұрын
@Reza Dorrani, Video was very informative but after updating all I am getting the error on datacastvalue1.update property when i am writing this formula.Coalesce(varRecurr,ThisItem.recurringexclusions). It is giving me error as "this formula uses scope which is not currently supported for evaluation ( datatype as table). Also when i am updating value from sharepoint list this column is not getting updated. Request you help on urgent
@RezaDorrani
Ай бұрын
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
@golfnutt8
Жыл бұрын
This is Awesome Reza. Is it possible to add an item dynamically to a category so that the checkboxes change or is this more static choices?
@RezaDorrani
Жыл бұрын
The choices are being loaded from choices function. Choices picks choice values from Choice column in SP. If you think of it, it is dynamic.
@golfnutt8
Жыл бұрын
@@RezaDorrani maybe I didn’t ask my question correctly? How do i update the vertical gallery if I want to add a new choice value. Maybe a checkbox solution isn’t what I need. Thanks
@RezaDorrani
Жыл бұрын
@@golfnutt8 I still did not understand the question. The choices (be it vertical or horizontal gallery) is coming from choices function. You can drive this with your own collection as well but this is not something I have tried.
@golfnutt8
Жыл бұрын
@@RezaDorrani I sorry I am not clear. If there are three choices / check boxes and my customer needs a fourth choice / check box, how can he add the new choice / checkbox? I can do this with a single select combo box. More clear now? 😆
@RezaDorrani
Жыл бұрын
@@golfnutt8 Still not. I recommend posting your query on forums.
@gyanibaba5189
4 ай бұрын
@reza Dorrani, Thanks for the useful content, But I just want to select only one check box at a time, means Single select check for list option, Could you please assist
@RezaDorrani
4 ай бұрын
Better use a radio control
@gyanibaba5189
4 ай бұрын
@@RezaDorrani Okay, Thank you for your suggestion 🙂
@brianhiggins9986
Жыл бұрын
Reza, is is possible to set a default on the Radio control (Yes/No)? I noticed that after the change i.e., defaulting the Radio control to No, when I opened an existing item it changed to No while it was previously Yes.
@RezaDorrani
Жыл бұрын
Should be possible! not sure why it changes back. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@daisyjoieviray328
12 күн бұрын
I followed the steps on this video and tried creating multi select checkboxes using gallery in Power Apps but I am always having an error with the data card's default and update. It says, expecting record value. Do you have any idea how to fix this? Thank you. :)
@RezaDorrani
12 күн бұрын
I have not experienced the mentioned issue and hence not sure of the fix.
@sharepoint1231
Жыл бұрын
Hi Reza - thank you for the video. I have the checkboxes as a lookup instead of choice column for Dataverse table. I tried to fit the checkboxes in a gallery and inside a DataCard, but not able to make the check box visible if the data source is Dataverse, but if the data source is SharePoint. the checkboxes gallery inside the data card is visible. Is there a way we can put the gallery inside a DataCard if the data source is Dataverse and the field is a lookup field? which means form and gallery inside a DataCard comes from different data source. I frequently got request for adding gallery (data source comes from a different table as the main form) inside the middle of the form, like to know if this is possible. Thank you!
@RezaDorrani
Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@rkirk2k
Жыл бұрын
For the most part, this works well. I'm using it in a Canvas App (tied to a SharePoint list), not in the SharePoint custom form like in the video. However, on my "New Form", after I create an item - then leave and come back to create the next item - the form is maintaining the values checked from the last item created. Any idea why this would be.
@RezaDorrani
Жыл бұрын
I have not come across this issue 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
@rkirk2k
Жыл бұрын
@@RezaDorrani Thanks Reza. I found an article on there where the issue was resolved. Here's what I did (in case anyone needs the solution handy)... In App.OnStart, set a variable... Set(varCheckReset, false) OnVisible of the screen where the form/gallery/checkboxes reside... Set(varCheckReset, true); Set(varCheckReset, false); Checkbox.Reset property... varCheckReset Tested it out, and it works perfectly.
@dandrem.4074
Жыл бұрын
@@rkirk2k OMG BLESS YOU!
@kalaiherko5034
Жыл бұрын
Hi! Thank you so much for sahring this! I ran into the same issue while replacing my dropdowns with these gallery-check boxes. The only thought i have is that when you start with a blank canvas app, you don't get the same property options as you do when you create a form using SP. Either way, Im folling your instruciton but i don't see the OnVisible property on the screen where my checkboxes are placed. i see a 'Visible', but I think they're 2 different things...can you provide a bit more detail on where the OnVisible property will be? Thank you! @@rkirk2k
@gmshelley
10 ай бұрын
Awesome!!
@jeanjacquesgarnaud6138
Жыл бұрын
Thank you so much shareing that. But, I cannot reset checkbox. When I submit, all is perfect, but if I create a new item, all checkboxes previously check are still checked. I set my variable blank, but seems to do not have effect. When I validate my variable, table is empty... but checkboxes no :( What I did wrong ? thank-you
@RezaDorrani
Жыл бұрын
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@anumathew8169
Жыл бұрын
Excellent video. I have tried to implement this solution. It works fine. But the only problem is with Caching of the checkbox selections. I have tried to reset the variables as mentioned in the video. Unfortunately, none of them works. If I try to create a second item soon after creating an item, the previous selections are retained. Does any one know how to resolve this Greatly appreciate this.
@RezaDorrani
Жыл бұрын
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@dtodounpocomx_nl
Жыл бұрын
The gallery border doesn’t turns red when the field is required, I added same formula from the Dropbox If(isblank(parent.error), parent.bordercolor, color.red) but gallery border color doesn’t change to red, any idea?
@RezaDorrani
Жыл бұрын
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@yisungy
Жыл бұрын
Thank you for the video. It is very helpful. But, one thing I wonder, at my Sharepoint page, when I click "New" and then existing value selected item keep showing but if I refreash page(F5 button) and then it works properly. Would you advise?
@RezaDorrani
Жыл бұрын
I have not come across this issue hence not sure.
@tonyacosta1827
Жыл бұрын
@@RezaDorrani I have the exact same issue. I followed the video and even deleted and setup again. When edit and click "New" in sharepoint i see the selections made in edit. but if refresh page then the checkboxes are clear
@RezaDorrani
Жыл бұрын
@@tonyacosta1827 I cannot guess the fix without reproducing the issue. Il recommend posting issue with screenshots on the forums at powerusers.microsoft.com
@patoingnc
Жыл бұрын
When trying to assign the function to the checkbox I get the following :( set(variable,value) = this formula has side effects and cannot be evaluated, why is that?
@RezaDorrani
Жыл бұрын
Not sure as I have not come across this issue. Il recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@TheQuotists
10 ай бұрын
its working fine mutli select checboxes.but its not resetting the form after submitting the form.any suggestions
@RezaDorrani
10 ай бұрын
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@nitishvarma1464
Жыл бұрын
While adding new item to choice box in list it's reflects the given value but after refreshing the given value is not comming in choice box
@RezaDorrani
Жыл бұрын
I have not faced this issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@ashtoshsingh8310
10 ай бұрын
Hello Reza, Do you have any videos where we can create multiselect cascading dropdown options for ex if I select Manufacturer Model should filter out based on manufacturer but we should be able to select multiple Manufacturer and Models
@RezaDorrani
10 ай бұрын
I do not
@ashtoshsingh8310
10 ай бұрын
@@RezaDorrani any plan of making video on this topic?
@RezaDorrani
10 ай бұрын
@@ashtoshsingh8310 No
@muzammil4589
Жыл бұрын
Hi Reza, I have one additional condition, if a user check a checkbox a dropdown should visible, user will select a value from dropdown and then submit the form, the selected value should also submitted to the data source that is sharepoint list. pls help
@RezaDorrani
Жыл бұрын
I do not have any video references on this. Best to check or post query on forums in case someone has done something similar powerusers.microsoft.com
@muzammil4589
Жыл бұрын
Thanks
@affialho1
Жыл бұрын
Hi Reza - thanks for another great video! Question - is there a way to make a gallery with multi-choice checkboxes a required (mandatory) field? I have a DataCard in my form where I used a Gallery to create the multi-checkbox experience an that works great. However, I now need to make sure that at least one of the checkbox items is checked before the form is submitted. Can you guide me on the right direction? Many thanks!
@RezaDorrani
Жыл бұрын
Most welcome. In thi video, the multi select checkbox values are synced with the combo box (which is hidden). If you simply set required property for data card to true, it should work.
@affialho1
Жыл бұрын
@@RezaDorrani Thanks for the response. I just double checked and the Required property for the Data card is selected - it seems that there is a disconnect somewhere between the data card and the gallery with the checkboxes, which is inside the data card. On the gallery I have Items set to Choices, OnSelect to false and Selectable to true. On the checkbox control, I have a collection in OnCheck/OnUncheck, OnSelect I have Select(Parent). I tried to do a CountRows for the gallery and it only shows 0 whether I have boxes checked or not. Any other ideas of how I could get this right? Appreciate your time.
@RezaDorrani
Жыл бұрын
@@affialho1 I would have to try this out to see what the issue is related to. One simple option would be to disable submit button until a selection is made in checkbox gallery.
@affialho1
Жыл бұрын
@@RezaDorrani The submit button has other conditions in it referring to text from other cards in the form (Used !IfBlank, Edit, Disabled) - the only condition that doesn't work is the one for the checkboxes. I did include the data card that contains the gallery into the DisplayMode for my submit button.
@RezaDorrani
Жыл бұрын
@@affialho1 I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@ciprianiremodeling
Жыл бұрын
Reza - thank you, very well done and informative! Is there any way for a work item to be an Excel file rather than just a name? I would love a way to track the progress of a file being completed and who is currently working on it. Thank you!!!
@RezaDorrani
Жыл бұрын
Power Apps can connect to a document library as well which contain your excel files
@zubairakhtar6850
10 ай бұрын
@Raza Dorrani, How i can set the Default values for a ListBox to be equal to a Choice of Dynamics 365 CRM field which allow multiple selection. plesae
@RezaDorrani
10 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@eliotkwon6632
Жыл бұрын
Thank you Reza! It is really helpful. For the multi-select checkbox, my issue is the checkbox selections are still pre-selected on the new form, which looks like a cache. I added "Set(varScheDays,Blank());" statement on OnSuccess property, but it doesn't work. My app doesn't have "SharePointIntergration" menu on the left, so I couldn't add the statement there. Is it because of it??
@RezaDorrani
Жыл бұрын
This video is specific to SharePoint customized list forms. For standalone apps, check kzitem.info/news/bejne/2Yub1mirrpZidXo and plz check video description of this video.
@eliotkwon6632
Жыл бұрын
@@RezaDorrani Yeah I followed that video first, but for some reason, it didn't work out and I had the same cache issue (i.e. the collection was cleared but the multiselect checkbox still showed the previous selection. This video works except the cache issue. any idea? I put "Set(varScheDays,Blank())" on OnVisible property too but the same.
@jonathanfernandezferrer3470
10 ай бұрын
Hi, thans for the video. A question, I am trying to replicate the category field but this is a text field. I have inserted a combobox and a checkbox into this field to be able to do it. I only have one error when editing the record, the checkbox only returns the first element by default when this record contains more than one. Do you think you can help me solve it?
@RezaDorrani
10 ай бұрын
I would have to try your scenario or reproduce your issue to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@jonathanfernandezferrer3470
10 ай бұрын
@@RezaDorrani How could I give you access to the scenario so that you can visualize the problem?
@RezaDorrani
10 ай бұрын
@@jonathanfernandezferrer3470 If I have a video reference for it, I would have pointed you to it. I am working on multiple new videos. I would recommend posting your query on forums.
@alisonwitchell9380
Жыл бұрын
Hi Reza, thanks for this and all of your other recordings but I was wondering if you had a recorded solution to manage the Likert response from Microsoft Form(excel) to be updated into the Sharepoint List, using Power Automate. With my novice knowledge, I believe the method would be to use 'parse json' but I am happy to be corrected but the result is to use the Form to update a Sharepoint List that will then use to update an onboarding app and I would be grateful if you could provide me with some advice.
@RezaDorrani
Жыл бұрын
See if this video helps kzitem.info/news/bejne/zJinvqeBiYaejaA
@GeekUpdates
Жыл бұрын
How can we add All in Combo box and Select will all other items if we deselect, deselect all items.
@RezaDorrani
Жыл бұрын
You would probably need to add a button or some control for user to select which would trigger selection of all. On click of button, collect all items in collection. (I guess collection would be same as items property). And when user selects button to remove all selections, use clear function to clear the collection.
@dodasoares
Жыл бұрын
Hi Reza! I've been trying to create a flow that would update the SLA priority automatically based on the date the Item was created but without sucess, any ideas for that?
@RezaDorrani
Жыл бұрын
Depends on what your backend data source is, what type of column is storing sla, etc. etc. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@rebeccathorn-pena9108
Жыл бұрын
I need help with a formula: I have radio buttons, "Yes" and "No" and a somewhat dependent coinciding date field. I'm needing instructions on if the "yes" radio button is chosen, the date in the date field must be "before today", if "No" radio button is chosen, the date in the date field must be "after today".
@RezaDorrani
Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@rebeccathorn-pena9108
Жыл бұрын
Thank you
@rebeccathorn-pena9108
Жыл бұрын
I also have a date field on my power apps form that is showing the date & time. I've tried to update to only the date in the mm/dd/yyyy format, but the format doesn't change and I can't get rid of the time stamp.
@RezaDorrani
Жыл бұрын
@@rebeccathorn-pena9108 My answer would be the same. Please post it on the forums.
@farahim732
5 ай бұрын
Hi sir, why the sharepoint not showing all the edited interface in powerapps
@RezaDorrani
5 ай бұрын
Publish app, Clear browser cache, Wait a few mins, Try new browser window
@Cielu1
Жыл бұрын
Hello Reza, Usefull as always! Will you provide some comprehensive course on PowerApps soon? I'm afraid the tool changes so quickly and so fast that any course is being outdated within few months
@RezaDorrani
Жыл бұрын
I have plans. More on lines of live training. And considering tool keeps changing, it would more or less be a quarterly training program.
@Cielu1
Жыл бұрын
@@RezaDorrani thank you I would be intrested, waiting!
@RezaDorrani
Жыл бұрын
Check channel memberships. I have gone live with a training tier that you can sign up for now. kzitem.infojoin
@XoraNedd
Жыл бұрын
how can you add a new record with a multi selected combo box and patch to a share point list?
@RezaDorrani
Жыл бұрын
This video uses form control. I do not have a video reference on the Patch scenario for combo box and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Пікірлер: 290