If you want to extract specific fields using ChatGPT, use compose but make sure you have a delimiter like a semicolon and grab the text in between using Split. split(split(outputs('Compose'), 'VendorName: ')[1], ';')[0]. Please let me know if anyone has a better way.
Nice love the idea, but for some reason it kept making random special characters for me. I feel like if we just wait for 1 more release of a new LLM like GPT5, we can get it perfect! Other options could be like ask it to respond in the format of JSON? But love the idea of asking it to use the delimiter.
Awesome tutorial again Andrew! Have you considered working with the assistant API and bringing forth vector stores for training or GL tracking? Would love to see how to make that work with Power automate
Also, the link to the video on creating a custom connector to ChatGPT-4o isn't in the description of the video. I don't know if it is possible to also create a custom connector to google Gemini AI using power automate. Thanks a lot. You are the man!
Hi David, Thanks added it in the description. Yeah I'm sure it should be possible to use Google Gemini AI, and if it's not available yet it will be in the future.
Awesome stuff per usual. Can you please make a video using Azure document intelligence for custom PDFs and Power automate to extract the data and an automation that sends the data to a SharePoint list. I tried doing this using the free plan for 500pages per month, but I kept hitting road blocks after i had trained the model and tried to work with the results in json format
Hi Sophie! ChatGPT API is based on consumption. I put 10$ in and dev'd for months and only spent like $2.00. I believe ChatGPT has a new model 4o-mini and the price dropped significantly. AI builder comes with credits with premium Power Apps, once again it's based on credits. So if you have a few users with Power Apps premium you can have a bunch of credits already. If you don't have Power Apps premium at all it does cost extra. There is another way not mentioned I've been testing in Azure Document Intelligence and you can currently do 500 pages for free per month.
Hi @Andrew, I really enjoyed your video! I have a question. Since Microsoft 365 Copilot offers similar functionality, such as reading attachment files and performing tasks based on a prompt, why don’t you use 365 Copilot? Does it not support APIs? I’m new to Azure and Power Automate, and I want to send a PDF file from an external source to Azure via REST, have AI read the file, generate data according to a prompt, and then send it back. Could you give me some advice on how to approach this?(Fully automated, no manual work even file upload or create promt) Thanks a lot!
Hi Le An, sadly Copilot 365 is still not available currently today in the GCC (Government Consumer Cloud). Also 365 Copilot is using Chat GPT as it's back end. The main goal is to completely automate it like you said, fully automated. Azure with REST, is probably the best way to do it. Using Azure Document Intelligence which used to be called Form Recognizer with a neural model was easy to set up with Power Automate. You would go to Azure, set up and train a model, then using Power Automate to call on that model and send you back data. I do think I should make a video on this. Would be great!
Hi Le An, I created a new video today you may want to check out on extracting data with Azure Document Intelligence: ruclips.net/video/ZPehHclHPO4/видео.html
Hi Hammad! Should work just the same from get attachment content. ChatGPT needs a base64 format where AI Builder did not need it. You could also push an attachment to SharePoint and have SharePoint Syntex run automatically on all documents.
If you want to extract specific fields using ChatGPT, use compose but make sure you have a delimiter like a semicolon and grab the text in between using Split. split(split(outputs('Compose'), 'VendorName: ')[1], ';')[0]. Please let me know if anyone has a better way.
Nice love the idea, but for some reason it kept making random special characters for me. I feel like if we just wait for 1 more release of a new LLM like GPT5, we can get it perfect! Other options could be like ask it to respond in the format of JSON? But love the idea of asking it to use the delimiter.
100% Useful! Thanks Andrew!
Thank you Saeed!
Thank you Andrew this is amazing stuff!
Thanks for your continuous support bee!
Awesome tutorial again Andrew! Have you considered working with the assistant API and bringing forth vector stores for training or GL tracking? Would love to see how to make that work with Power automate
Hi Waleed! That would be amazing stuff to do! Got some learning to do!
Also, the link to the video on creating a custom connector to ChatGPT-4o isn't in the description of the video.
I don't know if it is possible to also create a custom connector to google Gemini AI using power automate.
Thanks a lot. You are the man!
Hi David, Thanks added it in the description. Yeah I'm sure it should be possible to use Google Gemini AI, and if it's not available yet it will be in the future.
In power automate cloud the model is taking too long to train. The internet is fine. What should I do?
AI Hub with AI Builder? Depending on how many fields and how many documents its trained on, it could probably take several hours.
Awesome stuff per usual. Can you please make a video using Azure document intelligence for custom PDFs and Power automate to extract the data and an automation that sends the data to a SharePoint list.
I tried doing this using the free plan for 500pages per month, but I kept hitting road blocks after i had trained the model and tried to work with the results in json format
Yep, I actually recently did this. Totally worth a video! Writing down now.
Hi David! Your video is ready 😄 ruclips.net/video/ZPehHclHPO4/видео.html
Hi Andrew Hess, Do you have to pay a subscription to ChatGPT or AI Builder?
Hi Sophie!
ChatGPT API is based on consumption. I put 10$ in and dev'd for months and only spent like $2.00. I believe ChatGPT has a new model 4o-mini and the price dropped significantly.
AI builder comes with credits with premium Power Apps, once again it's based on credits. So if you have a few users with Power Apps premium you can have a bunch of credits already. If you don't have Power Apps premium at all it does cost extra.
There is another way not mentioned I've been testing in Azure Document Intelligence and you can currently do 500 pages for free per month.
@@andrewhess123 Thank you Andrew!
Hi @Andrew, I really enjoyed your video! I have a question. Since Microsoft 365 Copilot offers similar functionality, such as reading attachment files and performing tasks based on a prompt, why don’t you use 365 Copilot? Does it not support APIs?
I’m new to Azure and Power Automate, and I want to send a PDF file from an external source to Azure via REST, have AI read the file, generate data according to a prompt, and then send it back. Could you give me some advice on how to approach this?(Fully automated, no manual work even file upload or create promt) Thanks a lot!
Hi Le An, sadly Copilot 365 is still not available currently today in the GCC (Government Consumer Cloud). Also 365 Copilot is using Chat GPT as it's back end.
The main goal is to completely automate it like you said, fully automated.
Azure with REST, is probably the best way to do it. Using Azure Document Intelligence which used to be called Form Recognizer with a neural model was easy to set up with Power Automate. You would go to Azure, set up and train a model, then using Power Automate to call on that model and send you back data.
I do think I should make a video on this. Would be great!
Hi Le An, I created a new video today you may want to check out on extracting data with Azure Document Intelligence: ruclips.net/video/ZPehHclHPO4/видео.html
@@andrewhess123 niceeee, thank you!
Great Work Sir, Did it work for get attachment content?
Hi Hammad! Should work just the same from get attachment content. ChatGPT needs a base64 format where AI Builder did not need it. You could also push an attachment to SharePoint and have SharePoint Syntex run automatically on all documents.
@@andrewhess123 Thanks Sir. I will test it. Hopefully it works
In power automate cloud the model is taking too long to train. The internet is fine. What should I do?