Azure OpenAI Service model overview (preview) - contains information to sign up for the preview. learn.microsoft.com/en-us/ai-builder/prebuilt-azure-openai
Thank you very much sir for this excellent video! So once the connector is on general availability, do you think it will be a premium or standard connector? what is your prediction on this?
Hi Reza, this is amazing, I could extract the data from work emails i receive, now i want to add this data in Excel Raw, please suggest me the way ahead. I am the one nil in IT and can only use Red and green in my mobile phone. would love to learn more from you. More power to you.
Hi Reza,Big fan of your work. wanted to understand where does these data gets stored (with company environmnet or can mircosoft can access these details which we in AI builder)since we are using confidential data will these impact our data privacy
Hi Reza...very useful as always! instead of only updating existing record, what would be the flow to create a new record from email received? also is it possible to save the email itself in SharePoint? Thanks
Always great VDO from you. But I found some e-mail contain URL but after use HTML to text function, the URL information have been disappeared then I can't use that for extract URL. If possible, could you share your solution? Thank you sir
Do you know what we're supposed to put into the Parameters section for the GPT action? I assume that's where we can pass an argument to set things such as temperature.
Hello Reza, first of all, excellent video, I subscribe to your channel, on the other hand, do you know how to apply this to emails with similar information, that is, sometimes all the requested information does not arrive, but it still has to be extracted
Your videos are always insightful and useful. I have a parent sharepoint and two child sharepoint Lists linked by Lookup column. How can I generate a pdf file from these sharepoints? I know how to generate a PDF from a single sharepoint But i am stuck when the number of sharepoint lists is more than one. How can I solve it? Thanks and your solution is appreciated .
Thanks. I do not have a video reference on parent child relationships with pdf export. This could be done in various ways and something I would have to explore to know more. Il recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi @Reza Dorrani, I am doing good for that your video's help me a lot. But I guess you missed to create some Modern Driven apps and additional usage of Components in PowerApps. So try to create a Modern Driven Apps and give us some detailed review about it. Thanks a lot for informative videos.
Hi Reza I really enjoy your videos on powerapps greatstuff. Can you please make a video or suggest me on how to add columns to an existing gallery table where Souce is Sql server. Above the table user should have a filter option where he can choose what columns to be displayed in the gallery table. Thank you!
I have not video reference on this scenario + I make videos when I receive multiple requests on a topic. Il recommend posting your query or checking on forums powerusers.microsoft.com
HTTP action and AI Builder action both are premium features. GPT OpenAI calls have a price - check openai documentation AI Builder Azure OpenAI is currently in preview and hence free. Once it goes GA, the price details would be shared.
0:33 I noticed that on some of the steps you used in your workflow here had “preview” at the end of their name. Does that mean they are only accessible to a select user base, or can anyone use them as long as they have the AI Builder? Any information would be appreciated.
Preview features means they are currently available as a preview for testing and exploring the feature. They should not be used in production scenarios until GA (general availability)
How can I use AI Builder to extract the table displayed in the body of Outlook? When converted to HTML, the AI immediately gives up, which is a problem.
This action expects text input. It wont understand table formats unless you give it really specific commands and give html as text to it. Not something I have tried. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza , I had created a Gallery by seeing you Responsive gallery Grid View view by I made it very simple just having two fields only One drop-down (category) And Combo box (Assign To ). I can add multiple category in that gallery according to Assign person. But I have to make it As approval flow. Example Category A - Assign To Manager , next Category B - Assign To HR and so on But how would I save this gallery data into my sharepoint so that I can make approval flow for that
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.
further i need to know that when i am usiing AI builder its showing error that its a non business connector and voilates office 365 defalt data policy. how can i run this flow with this error?
@@RezaDorrani Hi Raza thanks for your revert, i checked with admin and he informed that the AI GPT is blocked due to some legal and compliance approvals. May i please request you to guide further on how to fetch information from email body into excel. actually we get service request from third party software in outlook 365 and from there we manually create the tracker, which is waste of time and non-value added activity and i want to optimize on Power automate features available. Do you think you can help or refer me your relevant videos
Hi Reza finally I am able to try the Azure Open AI services. I am trying to replicate this exercise but is giving me an error. Do you if this version supports text in Spanish language to create the model?
I have not tested with spanish language hence not sure. Check the documentation for the action. May be its only limited to specific languages to begin with.
Thanks Reza. I was able to do the exercise, however I am receiving an error message: invalid Prompt input. The model’s maximum context lengths is 4097 tokens.
Are you still using this action in Power Automate? I wanted to use it, but looks like it's $500/month minimum for using 'Create text with GPT using a prompt' action. Is that true? That's what it seems according to the AI Builder calculator. Shame if true, as it's really neat, just massively overpriced, considering it's based on consumption pricing.
@@RezaDorrani Hi, using the AI Builder Calculator, if I type '1' for the minimum number of requests under 'Text generation with GPT and AI prompts' it tells me it will cost $500 monthly fee! According to Power admin portal under AI Builder Usage, its consuming about 48 credits per flow. It'll probably run 50x a day, so around 72,000 credits a month. I'm just not sure how to calculate that into cost. Is the AI Builder Add-on required and is the minimum cost $500? I'll probably ask in the MS community forum.
@@RezaDorrani ok thanks. I guess AI Builder is just aimed at enterprises then, as $500 min. is way too high for me. Shame as its a really good feature of Power Automate, I just don't understand why there has to be such as a high minimim fee if it's consumption based.
@@user-xk9yx2dl9t It has always been consumption based since day 1. There are certain user based premium licenses as well which add limited ai builder credits which you could explore.
@@RezaDorrani I'm creating a flow where I need to recognize the name of the APP in the body of the email, this action is perfect for my case, it worked perfectly, however power automate requires that after the GPT action request approval regarding whether the content is correct or not . in my case I don't want human action, I created an action to check the subject field, it's not the same thing, but the result is very close. tks Reza
@@RezaDorraniI can’t wait. This means I have the new feature and I can use it for what you did in this video? I just want to be able to extract emails content without the trouble of using expression. Thanks you
Great video Reza ... you always taking things to the next level
Thanks Vicente. Attempt is to share something new each time.
This OpenAI is bring different AI functionality for the regular business user to automate without writing any expressions. Thank you Reza
I agree ☝️
OpenAI is a game changer
thanks, this is a great explanation. Will work on it and set it up for own use.
Excellent!
Any idea when the rest of us will see this new ai builder model?….. very sweet kit…. Always is!
Azure OpenAI Service model overview (preview) - contains information to sign up for the preview.
learn.microsoft.com/en-us/ai-builder/prebuilt-azure-openai
Brilliant stuff. thanks for sharing your knowledge
My pleasure!
Excellent Reza!!
Thank You!
Very helpful, thank you.
Glad it was helpful!
Thank you reza once again great stuff..
Most welcome! Thanks for watching
Brilliantly demoed 🎉
Thanks Paul
Wonderful, Great job
Thank you! Cheers!
Thank you very much sir for this excellent video! So once the connector is on general availability, do you think it will be a premium or standard connector? what is your prediction on this?
Its AI Builder model. Every AI builder model is premium. So its easy to guess.
Thank you Reza !!!
Most welcome
Hi Reza, this is amazing, I could extract the data from work emails i receive, now i want to add this data in Excel Raw, please suggest me the way ahead. I am the one nil in IT and can only use Red and green in my mobile phone. would love to learn more from you. More power to you.
Thanks so much.
I have done videos on adding data to excel. You can check those ones and combine it with logic showcased in this video.
Hi Reza,Big fan of your work. wanted to understand where does these data gets stored (with company environmnet or can mircosoft can access these details which we in AI builder)since we are using confidential data will these impact our data privacy
learn.microsoft.com/en-us/legal/cognitive-services/openai/transparency-note?tabs=text
Hi Reza...very useful as always! instead of only updating existing record, what would be the flow to create a new record from email received? also is it possible to save the email itself in SharePoint? Thanks
Use add item or create item action instead of update + in Outlook connector - there is an action to download emails.
This is amazing
Thanks
wow this is a very good tutorial
Thanks
Nice explanation Reza, working like a charm. But when we run with large text it throws timeout error. Can you please share the limitations
I would recommend checking the documentation for the gpt action to know its limitations.
Always great VDO from you. But I found some e-mail contain URL but after use HTML to text function, the URL information have been disappeared then I can't use that for extract URL. If possible, could you share your solution? Thank you sir
Most welcome!
You will have to convert to text as the GPT action only uses text.
I'm not sure of a workaround.
Thanks sir
Welcome
Do you know what we're supposed to put into the Parameters section for the GPT action? I assume that's where we can pass an argument to set things such as temperature.
Those are the arguments. Check documentation for details.
Thank you!!!
Welcome!
Wow, Please how do i register for the preview. I can't find it in the OpenAI documentation.
It is in public preview but only for specific regions
Hello Reza, first of all, excellent video, I subscribe to your channel, on the other hand, do you know how to apply this to emails with similar information, that is, sometimes all the requested information does not arrive, but it still has to be extracted
Thanks for the sub!
If requested information is not in email, how can AI get it?
Hi Reza, quick question, will it also pick up the hyperlink given in email in the form of long http link and any text which is hyperlinked?
Have not tried that but it should pick it up
Your videos are always insightful and useful. I have a parent sharepoint and two child sharepoint Lists linked by Lookup column. How can I generate a pdf file from these sharepoints? I know how to generate a PDF from a single sharepoint But i am stuck when the number of sharepoint lists is more than one. How can I solve it? Thanks and your solution is appreciated .
Thanks.
I do not have a video reference on parent child relationships with pdf export. This could be done in various ways and something I would have to explore to know more.
Il recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi @Reza Dorrani,
I am doing good for that your video's help me a lot.
But I guess you missed to create some Modern Driven apps and additional usage of Components in PowerApps. So try to create a Modern Driven Apps and give us some detailed review about it.
Thanks a lot for informative videos.
I have a playlist on canvas components.
Pcf is not something I have done any work on
Model driven Apps is something I plan to showcase in future.
@@RezaDorrani I am waiting for Modern Driven App.🤝
@@pavithranc844 What is a Modern Driven App? Are you referring to a Model Driven App?
Any idea why I can't see this Create text with GPT on Azure OpenAI Service anywhere?
Probably because its not available for your region yet.
It’s currently available in preview for US region as far as I know
Hi Reza
I really enjoy your videos on powerapps greatstuff.
Can you please make a video or suggest me on how to add columns to an existing gallery table where Souce is Sql server. Above the table user should have a filter option where he can choose what columns to be displayed in the gallery table.
Thank you!
I have not video reference on this scenario + I make videos when I receive multiple requests on a topic. Il recommend posting your query or checking on forums powerusers.microsoft.com
have you ever tried to extract custom properties from an outlook email?
No
Hello, in power automate, I don't find the module "create text with GPT on Azure Open AI", can you help me? Thanks
It is an action available in preview. May not be available for your region.
Hi Reza, You mentioned here - Extract text (unstructured data). Can we extract tabular data using same method?
Try giving it instructions and check. I have not tried it :)
Ok … thanks. I will check
How much does this cost vs using the HTTP action to call the Gpt-3.5-turbo model from OpenAI API?
HTTP action and AI Builder action both are premium features.
GPT OpenAI calls have a price - check openai documentation
AI Builder Azure OpenAI is currently in preview and hence free. Once it goes GA, the price details would be shared.
0:33 I noticed that on some of the steps you used in your workflow here had “preview” at the end of their name. Does that mean they are only accessible to a select user base, or can anyone use them as long as they have the AI Builder? Any information would be appreciated.
Preview features means they are currently available as a preview for testing and exploring the feature. They should not be used in production scenarios until GA (general availability)
@@RezaDorrani Are you aware of when will this feature be released as generally available?
@@EJGHDR I am not aware as no announcement date has been publicly shared
How can I use AI Builder to extract the table displayed in the body of Outlook? When converted to HTML, the AI immediately gives up, which is a problem.
This action expects text input. It wont understand table formats unless you give it really specific commands and give html as text to it. Not something I have tried.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza , I had created a Gallery by seeing you Responsive gallery Grid View view by I made it very simple just having two fields only One drop-down (category) And Combo box (Assign To ). I can add multiple category in that gallery according to Assign person. But I have to make it As approval flow. Example Category A - Assign To Manager , next Category B - Assign To HR and so on But how would I save this gallery data into my sharepoint so that I can make approval flow for that
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.
When will this action be available for all tenants? I don't see it in flow actions.
Video description has the link
Hi Reza,
I am unable to see the Action: "Create text with GPT on Azure OpenAI Service" how to get this action please suggest me...?
Its now renamed to prompts as this is part of AI Prompts
How to extract text from Images in email body please provide any content or link for help.
@@shivasrk4014 I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Very nice video, but the 'HTML to Text' action is preview. do we have any other way without using that to convert HTML to text
I’m not aware of any other action
I dont see "Create text with GPT on Azure OpenAI Service. How do i enable that?
Video description has the information.
Hi Reza, currently the connector that you use is not available under AI Builder isn't it?
It is in preview and available to certify regions only. Check documentation for AI builder GPT action to see which regions it is available in
It seems that a form must be filled but when clicking on it it is not available anymore :(
@@andonii46 I do not know much about that form or know who the owners are.
It's only in US, not displaying in other countries!
Its in preview for specific regions only.
which region you are used ??
US
further i need to know that when i am usiing AI builder its showing error that its a non business connector and voilates office 365 defalt data policy. how can i run this flow with this error?
An admin applied DLP Policy for your environment is the cause. You cannot run flows which violate DLP. You would need to reach out to your admin.
@@RezaDorrani Hi Raza thanks for your revert, i checked with admin and he informed that the AI GPT is blocked due to some legal and compliance approvals. May i please request you to guide further on how to fetch information from email body into excel. actually we get service request from third party software in outlook 365 and from there we manually create the tracker, which is waste of time and non-value added activity and i want to optimize on Power automate features available. Do you think you can help or refer me your relevant videos
@@user-km4gt9iz2u I am not aware of other 3rd party software that does the same. I would recommend checking on forums at powerusers.microsoft.com/
Hello Reza, is it normal that i dont have that connector yet?
Yes, check video description
@@RezaDorrani i see but even in the AI Builder Explore tab, it doesnt exist
@@lflikkan Check video description link again :)
Its in gated preview. One has to fill a preview form.
Hy thanks for this video.. Need to get table from the email
Try giving instructions and check. I have not tried this scenario.
@@RezaDorrani sure.. I will try
Hi Reza finally I am able to try the Azure Open AI services. I am trying to replicate this exercise but is giving me an error. Do you if this version supports text in Spanish language to create the model?
I have not tested with spanish language hence not sure. Check the documentation for the action. May be its only limited to specific languages to begin with.
Thanks Reza. I was able to do the exercise, however I am receiving an error message: invalid Prompt input. The model’s maximum context lengths is 4097 tokens.
@@marienaalvarez8235 That is the limit. Max tokens allowed is 4097.
Any update on this roll out?
No as I'm not tracking it. Best to check the release planner or documentation.
I'm in America, but I am not seeing it. Is this a license thing?
Also, your videos are really helpful.
Its in gated preview. Link in video description
Thanks
@@RezaDorrani Thank you kind sir!
Are you still using this action in Power Automate? I wanted to use it, but looks like it's $500/month minimum for using 'Create text with GPT using a prompt' action. Is that true? That's what it seems according to the AI Builder calculator. Shame if true, as it's really neat, just massively overpriced, considering it's based on consumption pricing.
$500 is for 2 million or so credits. Check documentation for details. Credits are applied at an environment level.
@@RezaDorrani Hi, using the AI Builder Calculator, if I type '1' for the minimum number of requests under 'Text generation with GPT and AI prompts' it tells me it will cost $500 monthly fee!
According to Power admin portal under AI Builder Usage, its consuming about 48 credits per flow. It'll probably run 50x a day, so around 72,000 credits a month. I'm just not sure how to calculate that into cost. Is the AI Builder Add-on required and is the minimum cost $500? I'll probably ask in the MS community forum.
@@user-xk9yx2dl9t 500$ is minimum to get started. Dont think of 1 flow scenarios.
@@RezaDorrani ok thanks. I guess AI Builder is just aimed at enterprises then, as $500 min. is way too high for me. Shame as its a really good feature of Power Automate, I just don't understand why there has to be such as a high minimim fee if it's consumption based.
@@user-xk9yx2dl9t It has always been consumption based since day 1.
There are certain user based premium licenses as well which add limited ai builder credits which you could explore.
This action is currently in preview and requires an approval action, this is no longer the case
What is no longer the case?
@@RezaDorrani I'm creating a flow where I need to recognize the name of the APP in the body of the email, this action is perfect for my case, it worked perfectly, however power automate requires that after the GPT action request approval regarding whether the content is correct or not .
in my case I don't want human action, I created an action to check the subject field, it's not the same thing, but the result is very close.
tks Reza
@@crwebers human intervention is an option. As far as I know, its only a warning. You can ignore that
This is impossible without Azure OpenAI service subscription
This requires AI Builder in Power Platform
@@RezaDorrani the only action I see is “Create text with GPT using a Prompt”
@@alexotoous That is a new feature. Wait for my next video coming on Monday. The feature shown in this video is upgrading to AI prompts
@@RezaDorraniI can’t wait. This means I have the new feature and I can use it for what you did in this video?
I just want to be able to extract emails content without the trouble of using expression.
Thanks you
@@alexotoous Yes you can! The new video will show how to do it with excel but you can use the same logic as shown in this video
nice!
Thanks!