This is a game changer. Great tutorial! Thank you so much.

@RezaDorrani

2 ай бұрын

Most welcome

@stephenmatey927

2 ай бұрын

Question: Can you use a named formula that references a data source, eg SharePoint List, with Patch()?

@RezaDorrani

2 ай бұрын

@@stephenmatey927 It can reference data sources. But Patch would be an on-demand call that you would make on click of a button.

@stephenmatey927

2 ай бұрын

​@@RezaDorraniYep, but what I'm specifically asking is if I can keep all my references in one place: Formulas: dsMyList = MySchema_MyList; A Button's OnClick: Patch(dsMyList, Defaults(dsMyList), { field1 = "Value"}) When I attempt this, Patch() gives me an error: "The first argument should be a collection"

@RezaDorrani

2 ай бұрын

@@stephenmatey927 Yes, that should work. Best to try it out :)

It goes without saying that anyone who watches Reza's tutorial is taken from basic to advanced skills. The way he has laveraged the user defined function to complex calculation was insane. Great tutorial, Reza!1

@RezaDorrani

28 күн бұрын

Thanks so much!

Moving collections to NamedFormulas really boosts!! 🚀🚀 Having a complex app with 15 screens >30 datasources and >20 collections, where I moved majority of collections (only static) to Formulas now. Result is impressiv: App loading time went down from 3-5 sec to 1 sec. !! Thx again for sharing this !

@RezaDorrani

Ай бұрын

Awesome! So happy to hear that

@baderahm

Ай бұрын

Thanks. But it will delay the load of the galleries n their update, after refreshing the data. Isn’t it?

@RezaDorrani

Ай бұрын

@@baderahm Give it a try and check

@Bekesam

Ай бұрын

@PA_Freak or @RezaDorrani, when mentioned "collections(only Static)", what do you mean by that? Thanks

@RezaDorrani

Ай бұрын

@@Bekesam Best to try it out and check

UDF are a great enhancement, but they come with a small downside: To auto-format your code in “Formulas”, you’ll need to remove it first or comment-out /* */ . The other thing on named formulas, especially when replacing collections, they are not listed under Variables (X), so that there is a bit the overview lost… Certainly by marking it you’ll see the table/content. So good would to have another grouping to list down the NamedFormulas below Collections. Thanks Reza, for sharing this in such a great explanatory way, you are my first choice of information the Apps & Flows.

@RezaDorrani

Ай бұрын

Most welcome! And thanks for sharing the feedback

Great video reza, thanks for sharing ;) Using those formulas instead of onstart seems to be really efficient!

As always, your insights are timely and informative! Thank you so much❤

@RezaDorrani

2 ай бұрын

Most welcome and thanks for watching

I had already incorporated named formulas when it was first introduced, but at the time, collections were not yet permitted. Thank you so much sharing this and I will now update the rest!!!

@RezaDorrani

2 ай бұрын

Start using and test it

Fantastic Reza! I have an exact use case for this and you have just provided me with the solution! Thank you for another excellent video showcasing the functions. ✨🚀

@RezaDorrani

2 ай бұрын

Most welcome

very descriptive! Thanks for posting a video about named formulas

@RezaDorrani

2 ай бұрын

You're very welcome!

Truly game changer. Thank you for sharing Reza! 💯

@RezaDorrani

2 ай бұрын

It really is!

As always you rocked with your explanation capabilities ❤

@RezaDorrani

2 ай бұрын

Thank You

Ramadan mubaarak to all of you.

@RezaDorrani

2 ай бұрын

+1

This is really awesome!!! TY Reza, you're the best!

@RezaDorrani

Ай бұрын

Thanks so much

I'm learning so much with you. Appreciate how you go about teaching

@RezaDorrani

2 ай бұрын

Thank You

Fantastic Reza, I can definitely see how my apps can be improved with this. Thank you. 🙏

@RezaDorrani

2 ай бұрын

Great to hear!

Thanks for explaining the functions. I always wanted this feature.

@RezaDorrani

2 ай бұрын

Most welcome!

Thank you dear brother...we need more videos about this new feature if possible bro ❤

@RezaDorrani

2 ай бұрын

Most welcome! I try to bring something new in each video.

Thank you for the video! This will reduce the use of variables and collections significantly.

@RezaDorrani

2 ай бұрын

Named formulas first. Then collections and variables. Each have their own space.

Work to be done! Step by step...

This is a game changer for me. Thank you Reza

@RezaDorrani

Ай бұрын

Most welcome

What a great explanation and It gonna help a lot. Thank you Reza.

@RezaDorrani

2 ай бұрын

Most welcome and glad to hear it’s helpful.

Useful for me Reza... Thanks for sharing...!

@RezaDorrani

2 ай бұрын

Glad it was helpful!

Thanks for the early access Reza!

@RezaDorrani

2 ай бұрын

Most welcome

Really useful, Thanks for this video Reza 👍

@RezaDorrani

2 ай бұрын

Most welcome Ankur

OMG! This is pure gold!!! Thank you for sharing Reza.... quick question, if I use a Named Formula in a gallery, I will not be able to do the grid approach you explained in one of your videos where you can add (patch) records to the gallery and then to the datasource, will that be a limitaton of namedformulas?

@RezaDorrani

2 ай бұрын

Collections, Variables and Named formulas will all coexist.

Nice explanation! Thank you

@RezaDorrani

2 ай бұрын

You are most welcome!

Thanks for all the extremely valuable content Reza!! Is it possible to include optional parameters in this named functions?

@RezaDorrani

26 күн бұрын

I don't think optional params is currently an option

Great video Reza! Quick question, when using name formulas to filter a table do you know if it adds any delegation to it? e.g. a collection can only hold so many records but this isn’t creating a local copy so does it have that limit?

@RezaDorrani

2 ай бұрын

Thanks! It is delegation ready!

really great video - thanks!

@RezaDorrani

2 ай бұрын

Glad you liked it!

All formulas in one easy place … GAME CHANGER !! Way easier to see where you almost duplicate formula without knowing

@RezaDorrani

2 ай бұрын

Glad to hear that

Reza, AWESOME WORK as usual

@RezaDorrani

Ай бұрын

Thank you! Cheers!

Great info! Thanks!

@RezaDorrani

2 ай бұрын

Glad it was helpful!

Thanks for this video. I had considered the formulas as constants until now. I didn't know they were updated based on arguments. Do the delegation criteria apply in this case?

@RezaDorrani

2 ай бұрын

Delegation criteria does apply

very cool! I don't need refresh icon of gallery no more. I would love to use your techniques in my App. Thank you.

@RezaDorrani

2 ай бұрын

Go for it!

Very Nice Explanation Reza..

@RezaDorrani

2 ай бұрын

Thank you

Thanks, Reza. I have a need to do a block of code from multiple spots in my app, e.g., clear a block of variables. Could we do a parameter-less Custom Formula that can execute several statements at once, allowing me to just call the function wherever I need to execute the statements? Something like: nfClearSignatureVars():Boolean = Set(varSignBlob, Blank()); Set(varSignBinary, Blank()); Set(varSignPrintedName, Blank());

@RezaDorrani

2 ай бұрын

Not sure if setting variables in named formulas is even an option

Great video, thank you very much! There are some cases when I need to use a collection within a single screen (when modifying a gallery and patching the result to DB, for instance). Can such collection be "local" to save pc memory?

@RezaDorrani

2 ай бұрын

Named formulas, collections and variables each have their use cases. None of them should be used as a data source. Check savedata loaddata functions for your scenario

Thanks for the amazing video! I got below questions. It will be really helpful for me if you provide some insights on these. Thanks in advance. Are named formulas delegable? Gallery loads records in batches of 100 for performance optimization. If we use named formula in such case, will my gallery show all records? Will data row limit affect named formulas?

@RezaDorrani

2 ай бұрын

Delegable as long as query is delegable. Gallery will load data in batches of 100 with named formulas (as long as query is delegable against data source)

Thank you, Reza, for the access. Will this named formulas work in ForAll loop? if there is no sequence in named formula, that means we cannot use dependent formula?

@RezaDorrani

2 ай бұрын

It should work in forall also. Best to test and check.

Thanks for your video and so informative. I assume all these named formulas will load when the app starts run and if the value is never used, then those formula need never be calculated.

@RezaDorrani

2 ай бұрын

Formulas will run only when needed.

Great video. I am very confused with where you changed the collection colItems to a named formula nfHighPriorityTasks. The nfHighPriorityTasks table is not visible in the variables section like collections are. Is it stored locally somewhere?

@RezaDorrani

2 ай бұрын

Named formulas dont list out in variables section. You simply refer to it where you need it and the formula will run.

@RowDogSA

2 ай бұрын

@@RezaDorrani Thank you!

Does Named Formulas or User Defined Function support Patch() ?? I want to create a Custom Function to Patch some data as i use the same Patch function in several screens.

@RezaDorrani

2 ай бұрын

It does not as far as I know

Great tutorial 👍👏

@RezaDorrani

2 ай бұрын

Thank you 👍

Hi Reza, you are right. This is a game-changer. I do have one question though. If I create a collection named formula, as you mentioned, it will be executed only when needed. Then, what if I am referring to the collection multiple times and on multiple screens? Does it make it an expensive operation?

@RezaDorrani

2 ай бұрын

It will run the formula when needed on demand as you land on those screens. It does do smart caching as well. Easiest way to check if to run monitor tool and see the api calls.

Hi Reza, amazing video once again! Is there a way to use User Defined Functions in behavior like OnSelect. To make a Patch to Dataverse Generic from different places in the app for instance?

@RezaDorrani

Ай бұрын

Thanks! Currently, No

Hi Reza, Thank you for sharing this. When multiple users are simultaneously working on the same app, if User 1 updates an item, will that update automatically reflect for User 2 without requiring a manual refresh?

@RezaDorrani

2 ай бұрын

It wont update automatically. Its the same behavior for any other feature in Power App. A manual refresh or restart of app or execution of a delegable function via an action like go to screen or button click would be needed.

@user-oc1ny9ie5z

2 ай бұрын

@@RezaDorrani Thank you 🌹

Hello Reza, Is there any way i can remove the attachment from the sharepoint list through Powerapps? for other fields we can Patch Blank() values but how to delete attachments or Image fields.

@RezaDorrani

2 ай бұрын

Patch function does not support attachments. Form control or flow is your other options. Image column can be patched. To make values blank with patch - kzread.infofg-4nu_amJI?si=i9y5dZJalZZae5XE

That's really cool respect from Pakistan

@RezaDorrani

2 ай бұрын

Thanks

Great vid! :) Was wondering - In order to use User Defined Functions you need activate new analysis engine, I've seen that people have reported several errors after activating it, have you experienced any issues regarding this?

@RezaDorrani

2 ай бұрын

UDF is in preview so would not suggest using that in prod scenarios yet.

@markusj4729

2 ай бұрын

@@RezaDorrani true :) thanks

Hi Reza, I have a combobox in that onchange I have a logic to update few variables coming from database sql server which works perfectly in edit mode but not in play mode as I can't see the variable values getting updated any help/suggestion please ?

@RezaDorrani

Ай бұрын

I have not come across this 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

Raza, one question for formulas. When we use, it instantly execute it for collection. Does it will impact per day request cap or limit?

@RezaDorrani

2 ай бұрын

Not sure what instantly execute for collection means. These formulas are only calculated when referenced on a screen.

Thank you as always! Question, doesn't this way make many more calls to the database compared to collections? Example, I have a collection of employees. In many galleries with records inserted by employees I want their picture to be displayed. With a collection I made one single call OnStart, wouldn't NamedFormulas make 1 call for each record of the galleries to retrieve the pictures of employees having hundreds of separate calls each time? Also, would views from Sql Server also be automatically refreshed?

@RezaDorrani

2 ай бұрын

Calls within galleries (n+1) query should be taken into consideration. For that specific scenario, a collection makes more sense

@giorgiosurian2190

2 ай бұрын

Understood, thank you. Would views from SQL be automatically refreshed?

@RezaDorrani

2 ай бұрын

@@giorgiosurian2190 I have not tried with sql views hence not sure

Excellent bro!

@RezaDorrani

2 ай бұрын

Thanks so much

absolutely brilliant Rezza, I've been meaining to learn this to move most, if not all my App.OnStart variables to named formulas. One thing I have been trying to do is use a sharepoint list of roles, so I can control who can view different views in my Apps e.g. Security role and use this to control and filter galleries. I know you did one a couple of years ago but unable to find it. And my question is can this be done using Named Formulas?

@RezaDorrani

2 ай бұрын

Thanks so much! Absolutely, named formulas is the way to go. Here is the video you are looking out for kzread.info/dash/bejne/ln2usaObfc20Z8o.htmlsi=xKqPYLJXnUnEUqDn

@derekgray3019

2 ай бұрын

Perfect! I knew i had seen it before and struggled to get it to work, but now I am more experienced I think I can get to work. Thank you Sir 🙂

@derekgray3019

2 ай бұрын

Just one question, i have a list of 8 items in the Security list for business area, can i filter against the list in the named formula for each business area so that a logged in user can only see what he has item level permissions for?

@RezaDorrani

2 ай бұрын

@@derekgray3019 If security is already configured at item level, you simply get all items from list. Power Apps will respect security.

My annual period runs from 1st April to 31st March, what's the easiest way to set up two variables StartOfPeriod (eg 1/4/2024) and EndOfPeriod (31/3/2025) such that today is within that period? Is it using formulae, or setting global variables? Thanks

@RezaDorrani

Ай бұрын

Formula

Hi Reza sir, is UDF still a preview feature? When can we expect this function in production?

@RezaDorrani

Ай бұрын

Preview. No ETA on GA shared

@adityapadmawar8754

Ай бұрын

@@RezaDorrani thanks

Hi, I came across browser crashing issue suddenly in development environment (lower Environment) with data table control where as it's working fine in production environment (higher/live environment). I have checked both environments are having same authoring versions but why the issue in dev not in prod...?

@RezaDorrani

2 ай бұрын

I have no clue about this. Not something I have come across.

Hi @Reza. This video really helped during my first POC. I ran into an issue. not sure if its a bug. Now the Calendar view does not display the SharePoint List Data but if I edit the item in SP and save it as is, it will then display in PowerApps. I tried removing the data source and adding it again but didnt help. Request your assistance please. Thanks again

@RezaDorrani

2 ай бұрын

Calendar view?

@pritishable

2 ай бұрын

Sorry, it's this video kzread.info/dash/bejne/onVr0sV6f9nMYZM.htmlfeature=shared

@RezaDorrani

2 ай бұрын

I do not remember running into any issues with that video. I would recommend posting your issue on forums at powerusers.microsoft.com/

One more question - UDF does not support return type to be an array / items, right? many thanks

@RezaDorrani

2 ай бұрын

Currently, it does not

Hi Reza, I have some complex collections I use that I've split into two collections: 1 to collect the raw data and another to do non-delegable functions on the raw data. How does this play into Formulas? Just now when I tried transferring these collections over to formulas and added the named formula to a gallery, it almost stalled out the app. 😅 Any pointers? Should I get the raw data as a formula and a normal collection for the complex work afterwards? Or the other way around?

@RezaDorrani

19 күн бұрын

Non-delegable functions will remain non-delegable. You use collections or not, it won't matter. I encourage using delegable functions only.

@Vennex89

18 күн бұрын

@@RezaDorrani Thank you! So if I need to perform functions that are not delegable, like "AddColumns", should I use the Named Formulas to get the raw data first, such as just filtering by RecordStatus = "Active", and then create a collection off of that Named Formula? I guess I'm just trying to determine whether it is faster this way or if I should just do it all using collections instead. Appreciate the response if you have the time. Thank you again!

@RezaDorrani

18 күн бұрын

@@Vennex89 It wont be faster as query is not delegable. Continue using collections

@Vennex89

18 күн бұрын

@@RezaDorrani Thank you! Really appreciate it Reza! And thank you for responding to comments. You are only of my true and faithfuls to go to!

Hello Reza, Thanks a lot , nice tutorial. I have doubt on one scenario, when we importing power apps solution multiple times into the same environment , is there any issues will happen on flow actions? My flows are triggering based on SharePoint list updates. On my development environment flows are executing as expected , but in my testing environment same flows gives multiple action , specifically two emails receiving. Can you please give me a solution for this

@RezaDorrani

2 ай бұрын

Welcome! I have not come across this issue 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

@seenakhan3063

2 ай бұрын

@@RezaDorrani sure will do - Thank you so much 😊

Nice feature. Is there any way I can define a user define function and use in different canvas apps?

@RezaDorrani

2 ай бұрын

As of now, its for current app only

In a sense, does this not dramatically minimize the use of collections? Almost to the point that named formula's would replace collections, except for discrete use cases?

@RezaDorrani

Ай бұрын

Named formulas would and should reduce variables and collections usage

So, If we attach the named Formula to a gallery component will it automatically refresh or we have to manually refresh it.

@RezaDorrani

2 ай бұрын

It will auto refresh when user lands on the page having the gallery or a filter or reset action is initiated.

@dixitjoshi3947

2 ай бұрын

@@RezaDorranigot it. Thanks for the super fast response.

TY! ☺️

@RezaDorrani

2 ай бұрын

Welcome

Hi Reza! This is great. I can´t activate named formulas in my Power Apps tho. I can see the Formulas property in the App screen but it doesn't work and I am sure I am using the right syntax.

@RezaDorrani

2 ай бұрын

Named Formulas is Generally Available. No need to activate it. Im not sure why it would not show up in your app.

@benjaminlahsen6721

2 ай бұрын

it does show up, but when I close the formula using ';' as requested, the error message says "Missing parent close". It is wierd@@RezaDorrani

@RezaDorrani

2 ай бұрын

@@benjaminlahsen6721 I would recommend posting your issue on forums powerusers.microsoft.com

Awesome❤❤

@RezaDorrani

2 ай бұрын

Thank You

Hii reza, is it possible to Navigate different screen if user having access then navigate to screen 1 otherwise navigate to Screen 2. In start screen and on start property of app I am not able to Navigate screen automatically by reading my access management.. Pls provide any solution While loading app 1st read the access, based on that navigate to particular screen

@RezaDorrani

2 ай бұрын

Closest video link I have is kzread.info/dash/bejne/eqaXl5OMYrHNctI.html

Reza, Can named formulas already be used in a PROD environment?

@RezaDorrani

2 ай бұрын

Named Formulas is generally available and should be used for production scenarios. UDF is in preview.

Hello there, I am trying to load more than 2000 records into a table in a named formula section using forall but can't achieve that. Appreciate your help

@RezaDorrani

20 күн бұрын

ForAll is NOT a delegable function. Best to follow best practices and work with delegation - watch kzread.info/dash/bejne/ZJd_xdulo6rSgMo.htmlsi=VxmN0FnKcMdLcPfB

@fr.minabarsoum8528

20 күн бұрын

@@RezaDorrani Sure - anyother suggestion how to load the 3 iterration of 2000 records each into 1 table but not as a collection (managed to do that in the onstart function) but was really happy to move most of my funcitons to formulas after watching this video

@RezaDorrani

20 күн бұрын

Why do u need to load all data at once? If your query is delegable, as you scroll through the results it will load all the data.

@fr.minabarsoum8528

19 күн бұрын

Because the query is not delegable, hence I'm trying to load it all.

@RezaDorrani

19 күн бұрын

@@fr.minabarsoum8528 That will impact app performance in a big way and not recommended.

Thanks

@RezaDorrani

2 ай бұрын

Welcome

Hi Reza how to put row limit in editable table in powerapp. like only want 10 rows in editable table .

@RezaDorrani

2 ай бұрын

Check firstN formula documentation

Hello sir... I want to watch your power platform training videos... So. How much amount i need to pay?

@RezaDorrani

2 ай бұрын

If you click on JOIN button on my channel on a web browser, it will show you the pricing for each tier.

Can we do patch SharePoint list inside UDF?

@RezaDorrani

Ай бұрын

Have not tried it so not sure

How come I defined the named formula without error, but when I try to use it, it shows "unknown or unsupported function"? thanks!

@RezaDorrani

2 ай бұрын

No idea about that as I have not experienced this

@jevinwang3769

2 ай бұрын

@@RezaDorrani Oh I know - forgot to toggle the UDF on

Can you call power automated flows with named formulas?

@RezaDorrani

2 ай бұрын

Currently, No

@steviesimsii

2 ай бұрын

@@RezaDorrani Ok so run The call OnStart , set the return in a variable and then Collect the collection in named formulas !?

@RezaDorrani

2 ай бұрын

@@steviesimsii Better to use collection in those scenarios.

I love the idea of UDFs. Can I call a SQL Server Stored Procedure from a UDF in a Named Formula?

@RezaDorrani

2 ай бұрын

Sql stored procedure just got announced. I have not tried it. Give it a shot and see.

@GroverParkGeorge

2 ай бұрын

@@RezaDorrani LOL. That's a nicer way of telling people what I always tell people in forums. "What happened when YOU tried it?" I will let you know. 😊😊

@RezaDorrani

2 ай бұрын

@@GroverParkGeorge Always best to try it.

@GroverParkGeorge

2 ай бұрын

@@RezaDorrani It looks like SQL Server Stored Procs can't be executed in Named Formulas. 😔😔

@RezaDorrani

2 ай бұрын

@@GroverParkGeorge same with cloud flows.

Last time I used User Defined Function (a few weeks ago), my canvas app wouldn't publish - it just kept trying but was never successful. I had to roll back my changes to fix. Has anyone successfully publish to production?

@RezaDorrani

2 ай бұрын

Yes, I was able to 😊 Trick is to reference data sources separately. Check the named formulas syntax I show at end of video.

Thank you so much. I can't find the li k to download.

@RezaDorrani

2 ай бұрын

Link to download is for members only (check description for details)

@RezaDorrani "I have a question regarding PowerApps form mode. When I add an attachment to the form and then switch to view mode, clicking on the attachment opens it in a new tab. However, PDF and image files open in view mode as intended, while Word documents and Excel files open in edit mode. I want all file types and documents to open in view mode when clicked on in a new tab". Clear the doubt and make one video.

@RezaDorrani

2 ай бұрын

I have not experienced an issue with opening attachment based on modes hence not sure. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@pream7461

2 ай бұрын

@@RezaDorrani Thank you @RezaDorrani 🤝. "Why don't you try using PowerApps to achieve this?"

@RezaDorrani

2 ай бұрын

@@pream7461 "Why don't you try using PowerApps to achieve this?" ??

@pream7461

2 ай бұрын

@@RezaDorrani😂😂 I've experimented multiple times, but unfortunately, I haven't been successful in achieving the desired effect. I'm seeking your guidance and expertise for a suitable solution recommendation.

@RezaDorrani

2 ай бұрын

@@pream7461 I cannot reproduce your issue. Best place to post your issue would be the forums powerusers.microsoft.com/

Greatttt

@RezaDorrani

2 ай бұрын

👍

Record and Table type of parameter not supported?

@RezaDorrani

2 ай бұрын

Currently no for UDF

Happy Ramazan

@RezaDorrani

2 ай бұрын

Thanks