Azure OpenAI Service model overview (preview) - contains information to sign up for the preview. learn.microsoft.com/en-us/ai-builder/prebuilt-azure-openai
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.
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
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
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?
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
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.
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
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.
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.
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)
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.
@@OrcaT-j1y 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
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