Thx for prompting me to think of using As in forAlls. I hope I remember the text and value trick that added 000 to the invoice, not sure why this works the way it does but thanks as always for pointing it out.
Great info! I just keep a bunch of lists in a SharePoint site for doing "proof-of-concept" type stuff in Power Apps, but your approach is much simpler (although not as accurate for testing delegation stuff).
Agreed Chad that I have some demo lists that I use also. But I find some people just do better when I replicate their data 1 for 1 so they don't have to imagine. Have a great day! 🐶
Hi Shane! Thank you very much for your videos and all your work :) You have been a great teacher. I have been watching this several times because of the shuffle function. On the min 5:49 you said you can run it again and again and again by deleting the parenthesis. Can you do that using a button? Reactivate the shuffle on the gallery ? Best regards,
Big fan Shaun! You have taught me so much, thank you. I’m trying to find out if currentuser can determine the output in one of my dropdown choice fields, though the data doesn’t have a connection. So if currentuser is me, Holly, I want the ‘Area’ dropdown to auto-fill with ‘TV Products’. Is this possible?
Dropdowns show a table of data. If you want the data to be filtered differently by different users that is possible. You will need some type of logic either and If or a Filter. One idea. PowerApps Filter Gallery by the Current User ua-cam.com/video/-VaADTTPYmg/v-deo.html
Great video, thanks once again . I have a requirement for selecting the month and year only in a date, would you use a sequence for this and do you have a tutorial for this?
When I type Sequence(10,10,10) I got the numbers 10,20,30,40,50,60,70,80,90 and the last one is again 10. Can you tell me how can I format this to be a 100? Thanks in advance.
Up to now I have been working with MS Access and know the possibilities to change data by e.g. queries. How does that work with model driven power apps? Which possibilities do I have there for mass changes ?
Hi E EE, What changes would you like to make, do you mean mass change a single column in a selection of records? You can use UpdateIf to do this. What I've been doing lately is mass changing data in a collection that matches a datasource structure and pushing it back using patch. You can put canvas apps inside model driven apps, so you could have your main data operations via the model app, and then have a page with a canvas app on it to do the mass data manipulation. You can see all powerapps formulas here: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
@@stuandrews1618 Thank you very much for the quick and helpful reply. The thought of putting a canvas app over a model driven app has not even occurred to me. Neither on UA-cam nor at the various training providers did I find any references to this, although this was one of the first questions I asked myself when switching from MS Access to Power Apps. - In Access the - "low code no code solution" of the last century - you can access the 6 query types (create tables, append data, update 4th data, create crosstabs and delete data) quickly and intiutively under the same interface.... Maybe someone will explain this with examples here on UA-cam or elsewhere. Thanks! Ed
@@EE-kw1cm The canvas app in the model app is relatively new: docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embed-canvas-app-in-form. With regards to access, I did have a 'play' with it maybe 10 year ago or so, but I would assume dataverse would be a comparable product to the role that access played in the Microsoft line-up previously: docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-intro
@@ShanesCows Thanks also to you Shane, your videos gave me the confidence to move from Excel & VBA, to consider using powerapps and the power platform for my solutions at my workplace. You've made it easy for me to understand, but more importantly, you've shown what can be achieved from the examples you give.
@Shane Young. Good day can make a simple Rating app for the employer and the employee rate will store to share point. Hopefully you can make the app. thank you and god bless
Great vid Shane - love these baby step vids on breaking down functions using practical examples
Glad you liked it!
Brilliant, Shane
Thanks.
Thank you for this awesome video. I learnt some new tricks around data manipulation
Thx for prompting me to think of using As in forAlls. I hope I remember the text and value trick that added 000 to the invoice, not sure why this works the way it does but thanks as always for pointing it out.
Glad it was helpful!
Great info! I just keep a bunch of lists in a SharePoint site for doing "proof-of-concept" type stuff in Power Apps, but your approach is much simpler (although not as accurate for testing delegation stuff).
Agreed Chad that I have some demo lists that I use also. But I find some people just do better when I replicate their data 1 for 1 so they don't have to imagine. Have a great day! 🐶
Hi Shane! Thank you very much for your videos and all your work :) You have been a great teacher.
I have been watching this several times because of the shuffle function.
On the min 5:49 you said you can run it again and again and again by deleting the parenthesis.
Can you do that using a button?
Reactivate the shuffle on the gallery ?
Best regards,
Maria you need to have the Shuffle output put to a variable and then you could have the button change the variable, which would redo the shuffle. :)
@@ShanesCows Thank you!
Big fan Shaun! You have taught me so much, thank you. I’m trying to find out if currentuser can determine the output in one of my dropdown choice fields, though the data doesn’t have a connection. So if currentuser is me, Holly, I want the ‘Area’ dropdown to auto-fill with ‘TV Products’. Is this possible?
Dropdowns show a table of data. If you want the data to be filtered differently by different users that is possible. You will need some type of logic either and If or a Filter.
One idea. PowerApps Filter Gallery by the Current User
ua-cam.com/video/-VaADTTPYmg/v-deo.html
@@ShanesCows Thank you!
Great video, thanks once again . I have a requirement for selecting the month and year only in a date, would you use a sequence for this and do you have a tutorial for this?
Thanks Shane
Happy to help Ron! Some of my favorite tricks.
Hi Shane,
Do you have any idea how we can get more than 1000 rows of data in powerapp when using powerbi as a datasource?
I don't, sorry.
When I type Sequence(10,10,10) I got the numbers 10,20,30,40,50,60,70,80,90 and the last one is again 10. Can you tell me how can I format this to be a 100? Thanks in advance.
It should be 100. Maybe your label you are displaying it in is too narrow to show the last 0?
@@ShanesCows Yep. I shortened label a two-digit number :)
Up to now I have been working with MS Access and know the possibilities to change data by e.g. queries. How does that work with model driven power apps? Which possibilities do I have there for mass changes ?
Hi E EE, What changes would you like to make, do you mean mass change a single column in a selection of records? You can use UpdateIf to do this. What I've been doing lately is mass changing data in a collection that matches a datasource structure and pushing it back using patch. You can put canvas apps inside model driven apps, so you could have your main data operations via the model app, and then have a page with a canvas app on it to do the mass data manipulation. You can see all powerapps formulas here: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
@@stuandrews1618 Thank you very much for the quick and helpful reply. The thought of putting a canvas app over a model driven app has not even occurred to me. Neither on UA-cam nor at the various training providers did I find any references to this, although this was one of the first questions I asked myself when switching from MS Access to Power Apps. - In Access the - "low code no code solution" of the last century - you can access the 6 query types (create tables, append data, update 4th data, create crosstabs and delete data) quickly and intiutively under the same interface....
Maybe someone will explain this with examples here on UA-cam or elsewhere.
Thanks!
Ed
Nice to see you guys talking this out. 🐶 Thanks to both of you.
@@EE-kw1cm The canvas app in the model app is relatively new: docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embed-canvas-app-in-form. With regards to access, I did have a 'play' with it maybe 10 year ago or so, but I would assume dataverse would be a comparable product to the role that access played in the Microsoft line-up previously: docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-intro
@@ShanesCows Thanks also to you Shane, your videos gave me the confidence to move from Excel & VBA, to consider using powerapps and the power platform for my solutions at my workplace. You've made it easy for me to understand, but more importantly, you've shown what can be achieved from the examples you give.
@Shane Young. Good day can make a simple Rating app for the employer and the employee rate will store to share point. Hopefully you can make the app. thank you and god bless