Тёмный
No video :(

Power Apps Data Functions - Manipulate and create sample data quickly 

Shane Young
Подписаться 164 тыс.
Просмотров 11 тыс.
50% 1

Опубликовано:

 

5 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 31   
@TheKermit2110
@TheKermit2110 2 года назад
Great vid Shane - love these baby step vids on breaking down functions using practical examples
@ShanesCows
@ShanesCows 2 года назад
Glad you liked it!
@CarlosSolisNow
@CarlosSolisNow Год назад
Brilliant, Shane
@ShanesCows
@ShanesCows Год назад
Thanks.
@geralddahl9159
@geralddahl9159 2 года назад
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.
@ShanesCows
@ShanesCows 2 года назад
Glad it was helpful!
@oluwatobiyusuf
@oluwatobiyusuf 2 года назад
Thank you for this awesome video. I learnt some new tricks around data manipulation
@cvkealey
@cvkealey 2 года назад
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).
@ShanesCows
@ShanesCows 2 года назад
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! 🐶
@maripower-nh6tz
@maripower-nh6tz Год назад
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,
@ShanesCows
@ShanesCows Год назад
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. :)
@maripower-nh6tz
@maripower-nh6tz Год назад
​@@ShanesCows Thank you!
@wendymason3263
@wendymason3263 2 года назад
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?
@HollyIsBest
@HollyIsBest 2 года назад
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?
@ShanesCows
@ShanesCows 2 года назад
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--VaADTTPYmg.html
@HollyIsBest
@HollyIsBest 2 года назад
@@ShanesCows Thank you!
@ronbakker1300
@ronbakker1300 2 года назад
Thanks Shane
@ShanesCows
@ShanesCows 2 года назад
Happy to help Ron! Some of my favorite tricks.
@poojashetty2195
@poojashetty2195 2 года назад
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?
@ShanesCows
@ShanesCows 2 года назад
I don't, sorry.
@BokyJ
@BokyJ 2 года назад
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.
@ShanesCows
@ShanesCows 2 года назад
It should be 100. Maybe your label you are displaying it in is too narrow to show the last 0?
@BokyJ
@BokyJ 2 года назад
@@ShanesCows Yep. I shortened label a two-digit number :)
@EE-kw1cm
@EE-kw1cm 2 года назад
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 ?
@stuandrews1618
@stuandrews1618 2 года назад
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
@EE-kw1cm
@EE-kw1cm 2 года назад
​@@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 RU-vid 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 RU-vid or elsewhere. Thanks! Ed
@ShanesCows
@ShanesCows 2 года назад
Nice to see you guys talking this out. 🐶 Thanks to both of you.
@stuandrews1618
@stuandrews1618 2 года назад
@@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
@stuandrews1618
@stuandrews1618 2 года назад
@@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.
@alljomar432
@alljomar432 2 года назад
@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
Далее
Power Apps formula Reference + 5 uncommon functions
21:37
5 Power Apps Best Practices for Early Makers
13:24
Просмотров 18 тыс.
PowerApps GroupBy function and Nested Galleries
12:30
Power Apps - Canvas Apps Interview Question
19:16
Просмотров 1 тыс.
Working with SharePoint Choice columns in Power Apps
26:26