Simply A-M-A-Z-I-N-G! I'm feeling finally up to date with all of the new features on Power Apps! With so much changing it's good to have a content video like this!
Hi Reza, Excellent video, Thanks for this. I have one question, If my environment is created without Dataverse then how the Default solutions will work? If I am creating app based on SharePoint only.
Great video! Thanks! Especially Named Functions & ParseJSON will be gamechangers IMO. IMO the 'Default Solution' could have been better implemented by creating a new Solution for every App created, but hey, we're not in control 🙂
Works with flows as well. Advantage is apps and flows will also be created/added in solution context. KI have done a separate video on solutions. Check that on benefits of solutions.
hi Reza, thank you for these videos. Excellent source for reference. Im currently trying to save a particular table to a record in dataverse table. Do you have any tutorial on this?
Hi Reza, great video. About point 2 on Formulas: is this a more efficient way to handle variables? Since I'm thinking, to have variables updated at every time, they must be querying at every time as well, right? So maybe, not the best performance there. Maybe you know more about how they handle this, thanks.
Check documentation on named formulas. There are reasons why you would use both variables and named formulas. Named formulas only recalculate when a change occurs.
Another great content from Reza. Really appreciate your efforts!! Could you please share the video link of leave request app which you were using here for demo?
Another gem of a video Reza, thank you so much. Is the new named formula addition basically the same as declaring a variable? Really like the look of your leave app as well, I don’t suppose you have a video of building if it’s not a customer related app?
Named variable is not same as Set. I have explained it briefly in video. Video description has blog link to named variables. Leave request app videos are on my channel.
As always, great video, Reza! With regards on creating a Title with sequential number, is it advisable to put the last number on the Formulas property to get the latest number? We just want to avoid the same title/request number for each request. Thank you, Reza!
thank you for your continued work, I continue learning from your videos. you are the best power plateform youtube video maker, i am waiting your video about driven apps and portal
hi Raza hope are doing amazing...well is there any method which will patch the attachments in the sharepoint list without SubmitForm() function in PowerApps.
Great video summary on all the latest feature releases. Saw the new Ribbon UI earlier this week and I thought it was pretty cool. The NAME Function being immutable is really really great; initialise once and forget about it. With the Default solutions, is it possible to move all your components from the default into your own custom solution later on? Definitely bookmarking this video as it will come in handy. Thank you.
@@RezaDorrani I really hope there will be an option to just create a new Solution using the initial name of the Canvas App. The "Common Data Services Default Solution" will soon get cluttered. Thanks for the Video, very insightful 👍
Reza, excellent 👌 👏 Could you please make a detailed video on error handling and monitoring, speed check, duration of each action taking to execute in powerapps
I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Named formulas are very good! Reza, I'm sorry to use this comment to talk about other subject but I was hoping you could give me a tip. Is there a way to get proof of approval from Flow? I`m thinking of a document with the approval process or something like that. For auditory purposes. Thanks for the content!
Hi Reza ! Insightful video as always! I came across a business requirement where we need to use Salesforce as a connector. Although there are many videos about it, I'm not able to find the actual costing we have to pay for premium connectors. Is it already included in the PowerApps premium license or do we need to pay extra for each new premium connector separately ? And do every user needs to have premium license or only the developer? It will be really helpful if you can make a video on premium connector pricing and usage. There is no precise information available. Thanks !!!
It is included in power apps premium license. (premium license covers all premium connectors). Every user running app will need the premium license. Licensing overview: ruclips.net/video/E7T9xipjXfE/видео.html
Wow, thanks Sir Reza for updated Power apps feature tutorial! Specially to Formula property. With regards to Global, local variables what then is the variable created in Formula property? Also does the Power App have this thing called Application variable or is it the same as Global variable? Meaning if there are many users accessing the application, that variable is the same for all users, if one of them updated it, then the update can be seen by all users, it different from Instance variable where the variable valuable is different for each instance object, I know you know what I mean in object oriented environment, thank you.
@@RezaDorrani Thanks Sir for prompt reply, so if you don't mind, how do you deal with ... if I need a variable that should be seen by all who use the apps, and if one user update the variable then it should be seen by other users as well dynamically? I just asked because updating backend data (sharepoint list) is slow to be seen or reflect the changes in screen. Thanks again, appreciate it. Good morning from the Philippines :)
Thank you Reza for such an amazing video, I am trying to have this in formula section FormItem_var=LookUp(ITServiceDate_Table,ID=Value(Param("ItemID"))); is that possible to use lookup and if function here!
Possible! 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
All great information...especially the "named formulas" (will save me many Set variable formulas). If you don't already have one, a video along the lines of "Dataverse for SharePoint people" would be helpful. I've tried (really tried) to leverage Dataverse (for Teams) on a few projects, but as a long-time SharePoint person, kept getting hung up on the little differences. For example, I wasn't quite sure how to deal with the lack of "Person" columns or a built-in "ID" column since I use/reference those in many of the apps and flows I build.
In Dataverse you will use a Lookup and tie it to AADUsers. When you create a New Column in your Dataverse Table simply select Lookup and select AAD Users in the Related Table. You can use Users as well, it just depends on what data you need. Once you do that in you app you would just reference the fields from AADUsers tied to the name of your Lookup field name in Dataverse. Ex: You create a Lookup to AADUsers in your Dataverse Table and call it Manager. Since it is tied to AADUsers as a lookup you will be able to reference it as such in code: FieldName.'AAD User Reference Field Name' In a gallery: ThisItem.Manager.'Display Name' = This would display the Display Name from the AADUsers Table Display Name for the user added. In a Patch Statement (assuming you used a dropdown and that dropdown has a list of Names) - The use of a Lookup here is because my DropDown was assigned from a O365Groups Connector connection and we need to grab the related user via lookup for the Patch to properly work. Also note that in these examples I use Display Name. You should use email or ID as they are unique. Display Name is not 100% guaranteed to be unique Manager: LookUp('AAD Users', 'Display Name'=DataCardValue5.Selected.displayName) Assigning it to a DropDown: (I like to assign Dropdowns to a collection to make life easier) In your App onStart: Collect(colManagers,Office365Groups.ListGroupMembers('Some Group ID').value) Then in your combobox set Items to colManagers By ID I am not sure if you mean Employee ID or the Azure Unique ID. Regardless, they are in the AAD User table structure as: FieldName.'AAD user id' There is also a GUID ID unique to the AAD Users table: FieldName.'id' AAD Users will not contain detailed AAD/AD custom field properties or things like Company Employee ID, etc. You will want to use the Dataverse Users in these examples if you want the full list of AAD fields available (well almost the full list). Just tie youe Lookup Related Table to Users instead of AAD User. Hope this helps!
@@StephenSchusterE Thank you for that extremely detailed response...I'll give it a go on my next attempt. We don't have a Dataverse license, so stuck with "Dataverse in teams" and I'm still a bit confused over how/where/when to use the built-in tables (like Users, Team, etc.).
@@cvkealey As a rule of thumb the real answer it just depends. You could, just as easily, use a regular text field in dataverse that stores the users Email Address and then do a Lookup when brining the collection into your app against the V2Profile as needed. That will alleviate the confusion of using the Dataverse Lookup column. Just be aware the Profiles is somewhat limited as well. Getting Managers and such can be accomplished but if you need to deep dive user properties you may have to utilize the premium AAD Connector (at least I think it is premium, hard to keep track) To be honest I have alot of gripes with Lookup in Dataverse. For example: If you leverage Power Automate and need to do a Dataverse Update to a Lookup it is a "process" to say the least. As a rule of thumb, keep it clean and keep it simple. There is no need to use the bells and whistles unless there is a direct business need for it. I can't count the number of overly convoluted solutions I have dealt with that just didn't need to happen.
Good video showcasing these new features. Not sure why you would want a Canvas App to go in common data services default solution by default. Typically, I would want Canvas Apps and flows to go in a dedicated solution with a nice publisher prefix. Would the common data services default solution, avoid having to recreate an instant flow when importing a solution from another environment?
Thanks Reza, as always amazing video, clean and rich. Question, how do you change a value of a collection using the current value, example: Collection with 10 fields with user name text. Turn into user name + "-" + email. This using the less amount of code or another collection
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hey Reza, I used the expression to formata data based on an example and it worked very well, however, I got errors when the dynamic content is null. Any idea if what should I do to continue using the format data based on an example? Thank you, great video indeed!
@@RezaDorrani sorry, I watched the video a few days ago, I thought was this one. I will check your video talking about expressions to see if I can find a solution. Thank you very much and keep up with your video, they are of great value for us. I really appreciate it.
Hi Reza, Nice Informative video. I have a question related to the Formula column based on PowerFx, I am not able to see that option when creating a new column, Is it due to I am using a developer account for the same ? or missing something here?
Really awesome video Reza! Quick question, when is going to be available the Power FX formulas in Dataverse? I currently cannot see this awesome feature. Thanks for the great videos Reza!
Hello Reza, thanks for the helpful information as always. I was wondering if you could make a tutorial video on how to automate refresh Power BI report and publish it based on Sharepoint List data using Power Automate? Thanks!
I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
thanks Reza for another great content and being on top of the new features! The ParseJSON, Named functions, and search and replace would certainly bring tears of joy to all devs. But would like to know your thoughts as they are still Experimental features.
Search and Replace is GA! ParseJSON and Named are experimental. My thoughts on experimental are same as documentation learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-experimental-preview
Hi Reza, should you be able create a Flow in a PowerApp form with SharePoint integration i.e. where you customise the SharePoint list form in PowerApps? Or do these have to be triggered within SharePoint always (and not the customised form) ?
@@RezaDorrani No you can't, try from a MicroSoft List, you get the Sorry there's been a disconnect error all the time, in my dev environment and in my Clients.. Unless something is not configured right?
@@mkavo I know one can do it. It might have something to do with your dev environment. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
Thanks for the video when I enabled named formulas the try to play the app in the Dev Env studio I get the error ‘The app didn’t start correctly. Check that you are on-line and try refreshing your browser’ Does something need to be switched on in the admin centre for this to work please
Its an experimental feature and still rolling out to all regions. I did not face this issue though so not sure. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza. I was just wondering if there is any way to find where we have created a collection in PowerApps and because the app is very big its pretty hard to find and that this was previously developed by a former person.
@@RezaDorrani Thank you but is there also a way to find where the collection is initially used or created in the code section or under which property it is being coded ?
It is an experimental feature at the moment. Not meant to be used in production scenarios. There may be some missing features which would be fixed prior to preview.
@@RezaDorrani I hope it will come soon, it is a great new feature. Thanks for your video´s Reza, I hope they will never be removed, I review them frequently.
Once you enable the feature as shown in video, save and close your app. Edit app again, then make sure the authoring version is latest & then you would see the option.
GREAT video as always. I'm wondering if you have the experience of getting a delegation warning when using named formulas instead of variables when the variables do not get the warning. For example, No delegation warning using variable: LookUp(SPTable, ID = varNewRecord.ID). Delegation warning using named formula: LookUp(SPTable, ID = LastNewRecord.ID)
@@RezaDorrani Odd. I get a ton of them when I change my variables to Named Formulas. I posted something on Community and MS person ShantanuP said it was a bug but I haven't seen anything else about this.
Regarding the named formulas, keep in mind that you would not want to run User() multiple times when the typical use-case won't have values changing. Cache this value in a global variable.
Content approval status column type might be the issue related to your case. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Can you please help me with possible solution for the below problem. Purchase Schedule Qty Exp. Goods Receipt Date 50 31-Mar 50 30-Apr 50 31-May 25 30-Jun Sales Schedule Qty Exp. Ship Date 125 01-Jun 50 15-Jul Input- Purchase schedule and sales Schedule Output- Table reflecting how Purchased Qty and from which Goods Receipt Date can be consumed from purchase schedule to meet the sale schedule. ie. To meet sale schedule of Qty 125 for of 1st Jun, we need to consume whole qty of 31st March and 30Th Apr and 25 qty from 31st May. And left out 25 qty of 31st May will used for 15th Jul sale schedule. Qty Exp. Goods Receipt Date Exp. Ship Date 50 31-Mar 01-Jun 50 30-Apr 01-Jun 25 31-May 01-Jun 25 31-May 15-Jul 25 30-Jun 15-Jul
One big problem with the new "Modern" UI is that it no longer permits you to "Save As" to an existing application. This feature made it easy for developers to transfer changes say from test to production. In my opinion, this is a bug. Now, you can go back to the older UI within Settings and click on the Upcoming Features and click then on Enable Legacy Ribbon. However, why did MS disable existing functionality and create a headache for developers? And, how long will people have the option to go back to the Legacy UI? Plus, if we can't do it the old way then how are we to easily move changes from one PowerApps application to another?
@@RezaDorrani - I appreciate your quick reply and I see that the Save As option is available. Thank you so much. It's too bad that there isn't something out there to help users figure out how to do things in the new UI. Thank you again!
@@RezaDorrani - You have been a lifesaver several times for things I've been doing in PowerApps. Is there any way we can financially support your work?
@@davidgraf8012 Goal of my channel is to share my learnings. Financially the channel is self-sufficient thanks to so many folks sharing the videos in their communities, organizations etc. I have opened channel memberships where I offer additional content, insights into upcoming videos, tips, tricks and more. There is a small monthly fee associated with it. Goal is to expand memberships to offer live trainings and more in future. You will find that option with "Join" button on my RUclips channel.
That is odd! 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
Make sure your app authoring version is latest. Then, enable the feature as shown in video, save and close your app. Edit app again, make sure the authoring version is latest & then you would see the property Formulas on App object. It could also be that the feature is not yet released for your region.
This is brilliant, so much improvements are being made to mitigate the life of the Power Platform developers 👏👏👏
Awesome! Thanks for watching.
I legit gasped when you talked about find and replace haha. Thanks Reza, I appreciate you and your knowledge sharing immensely
haha :)
Thanks for watching.
Oh my goodness, Named Formulas is a GAME CHANGER! Thank you as always, Reza!
It really is!
Here is the link to the detailed video for named formulas - ruclips.net/video/aIMhiLH9bLg/видео.htmlsi=v65BUpSKfxzbM0M1
Another masterpiece to watch! Thank you for sharing your knowledge.
Thanks for watching
Thank you so much @Reza for sharing this and putting all in a single video. Specifically the "Search and Replace" will be the best feature for me!!
Glad it was helpful!
Finally, many of these improvements were necessary. Thanks, Reza
Awesome! Thanks for watching.
Simply A-M-A-Z-I-N-G! I'm feeling finally up to date with all of the new features on Power Apps! With so much changing it's good to have a content video like this!
Thank You so much! So happy to hear the feedback.
Thanks a lot again Reza. So this modern command bar automatically adds the power automate too with out adding the power automate pane seperately ?
It does not auto add power automate pane.
The knowledge you share it helps all of us to understand the concept , perform better, and become stronger as professionals.
Jazakallah
Thank You so much
Amazing! 🎉
Many of these features will be so so useful!
Great video as always Reza!
Thank You
This is absolutely brilliant from none other THE Reza Dorrani!! Just loved it!
Thank You Aroh!
Hi Reza,
Excellent video, Thanks for this.
I have one question, If my environment is created without Dataverse then how the Default solutions will work? If I am creating app based on SharePoint only.
Will not work without Dataverse. Solutions is a Dataverse concept.
This is absolutely super. Thank you so much Reza for giving the insights into the new Features. Are these feature are GA now ?
Check video description :)
Great video! Thanks!
Especially Named Functions & ParseJSON will be gamechangers IMO.
IMO the 'Default Solution' could have been better implemented by creating a new Solution for every App created, but hey, we're not in control 🙂
I agree on the Default solutions feature. This is the starting point. Much more to come on it.
Love your content! You’ve helped me tremendously in my career. Thank you!
You’re most welcome and thanks for watching the videos
Great video Reza, always beautifully explained!
Thank You
Wahoo! That’s a vid! Thank you so much for it, I would have missed these updates. I will check if it’s also available on custome page.
Most welcome
Many Thanks Reza for the fantastic tutorial as always.!!
You are most welcome
What's the advantage of using the default solution in power apps?
Does this setting also works in power automate?
Thanks for your helpful videos 😊
Works with flows as well. Advantage is apps and flows will also be created/added in solution context. KI have done a separate video on solutions. Check that on benefits of solutions.
hi Reza, thank you for these videos. Excellent source for reference. Im currently trying to save a particular table to a record in dataverse table. Do you have any tutorial on this?
I do not have a video reference on that scenario.
Thanks Reza! Formulas will be huge help!!
Glad to hear!
So excited, I have been looking forward to the formula columns for a year now! I don't see them in my tenant, am I missing something?
Experimental feature, currently rolling out to all regions.
Wow.. It's indeed helpful information. Thanks very much Reza.
My pleasure!
Lovely stuff Reza 💎- Thanks for sharing 🙏
Thanks for listening
Hi Reza, great video. About point 2 on Formulas: is this a more efficient way to handle variables? Since I'm thinking, to have variables updated at every time, they must be querying at every time as well, right? So maybe, not the best performance there. Maybe you know more about how they handle this, thanks.
Check documentation on named formulas. There are reasons why you would use both variables and named formulas. Named formulas only recalculate when a change occurs.
Really good content from you Reza.Thanks.
Much appreciated
Hi Reza, great video, there is any way to use the named formulas passing some kind of parameters
Currently, named formulas does not support parameters.
Another great content from Reza. Really appreciate your efforts!! Could you please share the video link of leave request app which you were using here for demo?
There are 2 videos on leave request on my channel. Please check in my Power Apps playlist.
Thanks for the response 😊
Another gem of a video Reza, thank you so much. Is the new named formula addition basically the same as declaring a variable? Really like the look of your leave app as well, I don’t suppose you have a video of building if it’s not a customer related app?
Named variable is not same as Set. I have explained it briefly in video. Video description has blog link to named variables.
Leave request app videos are on my channel.
As always, great video, Reza! With regards on creating a Title with sequential number, is it advisable to put the last number on the Formulas property to get the latest number? We just want to avoid the same title/request number for each request. Thank you, Reza!
If using SharePoint you already have ID column which is autogenerated.
Awesome video Reza! Keep doing good job 👌
Thank You
thank you for your continued work, I continue learning from your videos. you are the best power plateform youtube video maker, i am waiting your video about driven apps and portal
Portal (Power Pages) video link ruclips.net/video/UFmL4svm8yM/видео.html
hi Raza hope are doing amazing...well is there any method which will patch the attachments in the sharepoint list without SubmitForm() function in PowerApps.
You cannot patch attachments without SubmitForm. Currently, Patch function does not support attachments.
Great video summary on all the latest feature releases. Saw the new Ribbon UI earlier this week and I thought it was pretty cool. The NAME Function being immutable is really really great; initialise once and forget about it. With the Default solutions, is it possible to move all your components from the default into your own custom solution later on? Definitely bookmarking this video as it will come in handy. Thank you.
Default solutions is an experimental feature. There is a lot more coming on it. Let's wait for more features to come in.
@@RezaDorrani Thanks Reza.
@@RezaDorrani I really hope there will be an option to just create a new Solution using the initial name of the Canvas App. The "Common Data Services Default Solution" will soon get cluttered. Thanks for the Video, very insightful 👍
Reza, excellent 👌 👏
Could you please make a detailed video on error handling and monitoring, speed check, duration of each action taking to execute in powerapps
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Named formulas are very good!
Reza, I'm sorry to use this comment to talk about other subject but I was hoping you could give me a tip.
Is there a way to get proof of approval from Flow? I`m thinking of a document with the approval process or something like that. For auditory purposes.
Thanks for the content!
I have done several videos on storing flow approval history ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hi Reza ! Insightful video as always!
I came across a business requirement where we need to use Salesforce as a connector. Although there are many videos about it, I'm not able to find the actual costing we have to pay for premium connectors.
Is it already included in the PowerApps premium license or do we need to pay extra for each new premium connector separately ?
And do every user needs to have premium license or only the developer?
It will be really helpful if you can make a video on premium connector pricing and usage.
There is no precise information available.
Thanks !!!
It is included in power apps premium license. (premium license covers all premium connectors).
Every user running app will need the premium license.
Licensing overview: ruclips.net/video/E7T9xipjXfE/видео.html
@@RezaDorrani Thanks for the help Reza ! Would be nice to have your videos on premium connectors !🌸
@@truptinalnikar I make videos when I get a lot of requests on a topic. I will need a lot of more folks requesting this topic.
Another great content Reza!
Thank You!
Wow, thanks Sir Reza for updated Power apps feature tutorial! Specially to Formula property. With regards to Global, local variables what then is the variable created in Formula property? Also does the Power App have this thing called Application variable or is it the same as Global variable? Meaning if there are many users accessing the application, that variable is the same for all users, if one of them updated it, then the update can be seen by all users, it different from Instance variable where the variable valuable is different for each instance object, I know you know what I mean in object oriented environment, thank you.
Variables are declarative, Named formulas are imperative. Named formulas are excel like.
There is no application variable in power apps.
@@RezaDorrani Thanks Sir for prompt reply, so if you don't mind, how do you deal with ... if I need a variable that should be seen by all who use the apps, and if one user update the variable then it should be seen by other users as well dynamically? I just asked because updating backend data (sharepoint list) is slow to be seen or reflect the changes in screen. Thanks again, appreciate it. Good morning from the Philippines :)
@@NelsonONadal You would need to store information in a data source of your choice and retrieve it for users to view or update
awesome!, I was missing common functions like ParseJson, rename variables
I have done an independent video on parsejson if that helps.
@@RezaDorrani really appreciate , thanks
Fantastic content. Thank you!
Most welcome
Thank you Reza for such an amazing video, I am trying to have this in formula section
FormItem_var=LookUp(ITServiceDate_Table,ID=Value(Param("ItemID")));
is that possible to use lookup and if function here!
Possible! 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
All great information...especially the "named formulas" (will save me many Set variable formulas). If you don't already have one, a video along the lines of "Dataverse for SharePoint people" would be helpful. I've tried (really tried) to leverage Dataverse (for Teams) on a few projects, but as a long-time SharePoint person, kept getting hung up on the little differences. For example, I wasn't quite sure how to deal with the lack of "Person" columns or a built-in "ID" column since I use/reference those in many of the apps and flows I build.
Dataverse for SharePoint people has been on my mind since a long time. I have it in my backlog.
In Dataverse you will use a Lookup and tie it to AADUsers. When you create a New Column in your Dataverse Table simply select Lookup and select AAD Users in the Related Table. You can use Users as well, it just depends on what data you need. Once you do that in you app you would just reference the fields from AADUsers tied to the name of your Lookup field name in Dataverse.
Ex: You create a Lookup to AADUsers in your Dataverse Table and call it Manager. Since it is tied to AADUsers as a lookup you will be able to reference it as such in code:
FieldName.'AAD User Reference Field Name'
In a gallery:
ThisItem.Manager.'Display Name' = This would display the Display Name from the AADUsers Table Display Name for the user added.
In a Patch Statement (assuming you used a dropdown and that dropdown has a list of Names) - The use of a Lookup here is because my DropDown was assigned from a O365Groups Connector connection and we need to grab the related user via lookup for the Patch to properly work. Also note that in these examples I use Display Name. You should use email or ID as they are unique. Display Name is not 100% guaranteed to be unique
Manager: LookUp('AAD Users', 'Display Name'=DataCardValue5.Selected.displayName)
Assigning it to a DropDown: (I like to assign Dropdowns to a collection to make life easier)
In your App onStart: Collect(colManagers,Office365Groups.ListGroupMembers('Some Group ID').value)
Then in your combobox set Items to colManagers
By ID I am not sure if you mean Employee ID or the Azure Unique ID. Regardless, they are in the AAD User table structure as:
FieldName.'AAD user id'
There is also a GUID ID unique to the AAD Users table:
FieldName.'id'
AAD Users will not contain detailed AAD/AD custom field properties or things like Company Employee ID, etc. You will want to use the Dataverse Users in these examples if you want the full list of AAD fields available (well almost the full list). Just tie youe Lookup Related Table to Users instead of AAD User.
Hope this helps!
@@StephenSchusterE Thank you for that extremely detailed response...I'll give it a go on my next attempt. We don't have a Dataverse license, so stuck with "Dataverse in teams" and I'm still a bit confused over how/where/when to use the built-in tables (like Users, Team, etc.).
@@cvkealey As a rule of thumb the real answer it just depends.
You could, just as easily, use a regular text field in dataverse that stores the users Email Address and then do a Lookup when brining the collection into your app against the V2Profile as needed. That will alleviate the confusion of using the Dataverse Lookup column.
Just be aware the Profiles is somewhat limited as well. Getting Managers and such can be accomplished but if you need to deep dive user properties you may have to utilize the premium AAD Connector (at least I think it is premium, hard to keep track)
To be honest I have alot of gripes with Lookup in Dataverse. For example: If you leverage Power Automate and need to do a Dataverse Update to a Lookup it is a "process" to say the least.
As a rule of thumb, keep it clean and keep it simple. There is no need to use the bells and whistles unless there is a direct business need for it. I can't count the number of overly convoluted solutions I have dealt with that just didn't need to happen.
Good video showcasing these new features. Not sure why you would want a Canvas App to go in common data services default solution by default. Typically, I would want Canvas Apps and flows to go in a dedicated solution with a nice publisher prefix. Would the common data services default solution, avoid having to recreate an instant flow when importing a solution from another environment?
I will make sure this feedback is provided to the team. Thank You.
Thanks Reza, as always amazing video, clean and rich. Question, how do you change a value of a collection using the current value, example: Collection with 10 fields with user name text. Turn into user name + "-" + email. This using the less amount of code or another collection
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks a lot Reza! great explanation as always.
Glad you liked it!
Excellent Video, as always.
Thanks again!
You are spoiling everyone!!! with the cheat sheets.
:)
Hey Reza, I used the expression to formata data based on an example and it worked very well, however, I got errors when the dynamic content is null. Any idea if what should I do to continue using the format data based on an example? Thank you, great video indeed!
I think you are talking about a different video.
You can make null checks by writing ? Operator. Check my video on flow expressions.
@@RezaDorrani sorry, I watched the video a few days ago, I thought was this one. I will check your video talking about expressions to see if I can find a solution. Thank you very much and keep up with your video, they are of great value for us. I really appreciate it.
Three useful enhancements... Named functions, error handling, Parse JSON
Those would be my top 3 as well
Excellent.. Thank you so much
You are most welcome
Hi Reza, Nice Informative video. I have a question related to the Formula column based on PowerFx, I am not able to see that option when creating a new column, Is it due to I am using a developer account for the same ? or missing something here?
Its an experimental feature and currently rolling out to all regions.
@@RezaDorrani thanks for the quick reply.
Thank You Reza for this video🙂
My pleasure
Really awesome video Reza! Quick question, when is going to be available the Power FX formulas in Dataverse? I currently cannot see this awesome feature.
Thanks for the great videos Reza!
Not sure of the exact date but it is available in preview environments.
Try URL make.preview.powerapps.com and check.
@@RezaDorrani Oh I can see them now! Thanks for the Tip Reza!
Hey Reza, I just send you a Linkedin friend request, please let me know if you received it; I would really love to connect with you.
@@yeraldo05 Il be happy to connect but I have stopped responding to linkedin messages because I get over 100 messages a day.
@@yeraldo05 Il be happy to connect but I have stopped responding to linkedin messages because I get over 100 messages a day.
Thanks for another awesome video.
Thanks for watching
Yis thanks Reza love the new formulas function
Most welcome
Thank you for this great video 🙏
My pleasure!
Thank you for this video Named Formulas instead of Variables, what about reducing the number of API calls?
api calls usage will not change if you use named formulas or variables. It depends on what you are trying to do with them.
Hello Reza, thanks for the helpful information as always. I was wondering if you could make a tutorial video on how to automate refresh Power BI report and publish it based on Sharepoint List data using Power Automate? Thanks!
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
thanks Reza for another great content and being on top of the new features! The ParseJSON, Named functions, and search and replace would certainly bring tears of joy to all devs. But would like to know your thoughts as they are still Experimental features.
Search and Replace is GA!
ParseJSON and Named are experimental.
My thoughts on experimental are same as documentation learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-experimental-preview
There are so many possibilities with the Named Formulas.
Agreed
Thank you very much, Reza for this!
My pleasure!
Hi Reza, should you be able create a Flow in a PowerApp form with SharePoint integration i.e. where you customise the SharePoint list form in PowerApps? Or do these have to be triggered within SharePoint always (and not the customised form) ?
You should be able to do both.
@@RezaDorrani No you can't, try from a MicroSoft List, you get the Sorry there's been a disconnect error all the time, in my dev environment and in my Clients.. Unless something is not configured right?
@@mkavo I know one can do it. It might have something to do with your dev environment. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
Amazing really appreciate
Thanks
Thanks 🙏🙏🙏
Again a Great work
Can you please revisit - "Error Handling" in Depth with the latest Best Practice
I would like to. If I get a lot of folks asking for it. I will plan something on it.
Very few have asked for it so far.
Thanks for the video when I enabled named formulas the try to play the app in the Dev Env studio I get the error ‘The app didn’t start correctly. Check that you are on-line and try refreshing your browser’ Does something need to be switched on in the admin centre for this to work please
Its an experimental feature and still rolling out to all regions. I did not face this issue though so not sure.
I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, is it possible to create an password protected Excel using power automate?
Never tried it, so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza. I was just wondering if there is any way to find where we have created a collection in PowerApps and because the app is very big its pretty hard to find and that this was previously developed by a former person.
There is a search option in left navigation.
@@RezaDorrani Thank you but is there also a way to find where the collection is initially used or created in the code section or under which property it is being coded ?
@@deepadevi682 No
Thanks Reza!!
Welcome
this is Brilliant
Thanks Sibi
May I know how to set the header n footer for the multi- pages PDF?
That is not an option with this feature
can we use clearcollect on Named Formula?
Collections are not allowed.
The new Formula property is great, the only problem is that it does not work on the published version. It works fine when Run from design.
It is an experimental feature at the moment. Not meant to be used in production scenarios. There may be some missing features which would be fixed prior to preview.
@@RezaDorrani I hope it will come soon, it is a great new feature. Thanks for your video´s Reza, I hope they will never be removed, I review them frequently.
I dont see the Named Formula property in the APP object. Is there something I need to enable to see the Formula property ?
Once you enable the feature as shown in video, save and close your app. Edit app again, then make sure the authoring version is latest & then you would see the option.
Great, but I do not understand why you cannot adjust the environment colour. You easily step into a mistake.
Hopefully that would be a feature in future.
GREAT video as always. I'm wondering if you have the experience of getting a delegation warning when using named formulas instead of variables when the variables do not get the warning. For example, No delegation warning using variable: LookUp(SPTable, ID = varNewRecord.ID). Delegation warning using named formula: LookUp(SPTable, ID = LastNewRecord.ID)
Not that I know of
@@RezaDorrani Odd. I get a ton of them when I change my variables to Named Formulas. I posted something on Community and MS person ShantanuP said it was a bug but I haven't seen anything else about this.
@@rapsfnc Named formulas is a preview feature
🙏🙏🙏 thanks Reza 🙏🙏🙏
Most welcome
And there it is ❤❤❤❤
❤️
Regarding the named formulas, keep in mind that you would not want to run User() multiple times when the typical use-case won't have values changing. Cache this value in a global variable.
It only re-evaluates it when changes are made. User() object would not change during user session.
@@RezaDorrani Good to know, thanks!
Filter('
Content approval status column type might be the issue related to your case. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Can you please help me with possible solution for the below problem.
Purchase Schedule
Qty Exp. Goods Receipt Date
50 31-Mar
50 30-Apr
50 31-May
25 30-Jun
Sales Schedule
Qty Exp. Ship Date
125 01-Jun
50 15-Jul
Input- Purchase schedule and sales Schedule
Output- Table reflecting how Purchased Qty and from which Goods Receipt Date can be consumed from purchase schedule to meet the sale schedule.
ie. To meet sale schedule of Qty 125 for of 1st Jun, we need to consume whole qty of 31st March and 30Th Apr and 25 qty from 31st May. And left out 25 qty of 31st May will used for 15th Jul sale schedule.
Qty Exp. Goods Receipt Date Exp. Ship Date
50 31-Mar 01-Jun
50 30-Apr 01-Jun
25 31-May 01-Jun
25 31-May 15-Jul
25 30-Jun 15-Jul
I do not have video reference on this scenario. I will recommend posting your issue/query with screenshots on forums at powerusers.microsoft.com
One big problem with the new "Modern" UI is that it no longer permits you to "Save As" to an existing application. This feature made it easy for developers to transfer changes say from test to production. In my opinion, this is a bug. Now, you can go back to the older UI within Settings and click on the Upcoming Features and click then on Enable Legacy Ribbon. However, why did MS disable existing functionality and create a headache for developers? And, how long will people have the option to go back to the Legacy UI? Plus, if we can't do it the old way then how are we to easily move changes from one PowerApps application to another?
It is available in modern ribbon. Next to settings, 3 ellipses, option called "Open".
@@RezaDorrani - I appreciate your quick reply and I see that the Save As option is available. Thank you so much. It's too bad that there isn't something out there to help users figure out how to do things in the new UI. Thank you again!
@@davidgraf8012 Check ribbon on left once you go to open option
@@RezaDorrani - You have been a lifesaver several times for things I've been doing in PowerApps. Is there any way we can financially support your work?
@@davidgraf8012 Goal of my channel is to share my learnings. Financially the channel is self-sufficient thanks to so many folks sharing the videos in their communities, organizations etc.
I have opened channel memberships where I offer additional content, insights into upcoming videos, tips, tricks and more. There is a small monthly fee associated with it. Goal is to expand memberships to offer live trainings and more in future.
You will find that option with "Join" button on my RUclips channel.
Oddly, when I use User().Email in Formulas, an error is generated “Invalid use of ‘.’ ”
That is odd!
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
❣Amazing video...! Thanks, Reza for such great content.
My pleasure!
in my powerapps I didn't find the formula. what do I have to do?
Make sure your app authoring version is latest. Then, enable the feature as shown in video, save and close your app. Edit app again, make sure the authoring version is latest & then you would see the property Formulas on App object.
It could also be that the feature is not yet released for your region.
solved. maybe my region not starting this Features in week. I have to wait for this feature to be in my region
@@RezaDorrani my powerapps version 3.22091.11. I hope there will be an update in my region
@@alifpurnama3298 I don’t control the updates :)
You can track the releases here learn.microsoft.com/en-us/power-platform/released-versions/powerapps
Español please
I would love to but I do not speak Spanish