My use case is, extracting text from an email and putting in a CSV format. Your steps are quite relevant. My question is, since I have defined a compose, and used "split" expression over the "html to text". So, now, if I have to define the connection with chatgpt to extract the only required data from the output of the compose that I see in the split compose action, what would I define in the "body" of HTTP action?
So under the HTTP action step you need to describe what you want to extract as a description. Then for the split() action it will return as an array. You could pass the array to the body. Describe saying something like this. This is an array of data then map the output of the split expression. If you want to use some specific rows from the array then you need to use the index along with your split() expression. split('your text','separator')[0], something like this. Thanks
I can't find "List Records", I see only "List Rows" when i try to create a row. After I use "List Rows" it allows me to select the table but there are no columns available in Dynamic Content... any idea how to fix this issue?
Hi It is List Rows present in a table (Excel). Check your Excel sheet have more than one worksheet. I might have pointed to a different worksheet for the same file. Thanks
Hi @kayne3619 Thanks for watching the video. No you need to buy some credit from OPEN API. I bought a 10$ credit and I have used a lot and so far I spend less than 2 dollars only. Its all about how much data you want to process (aka tokens). OPEN AI billed against how much tokens are used for each chat completion. Power Automate has AI builder action steps. Have a look into it. Believe that's another license too. Thanks
thanks for this and for breaking down the JSON too, incredibly helpful!
Very welcome!
My use case is, extracting text from an email and putting in a CSV format. Your steps are quite relevant. My question is, since I have defined a compose, and used "split" expression over the "html to text". So, now, if I have to define the connection with chatgpt to extract the only required data from the output of the compose that I see in the split compose action, what would I define in the "body" of HTTP action?
So under the HTTP action step you need to describe what you want to extract as a description. Then for the split() action it will return as an array. You could pass the array to the body. Describe saying something like this.
This is an array of data then map the output of the split expression.
If you want to use some specific rows from the array then you need to use the index along with your split() expression.
split('your text','separator')[0], something like this.
Thanks
I can't find "List Records", I see only "List Rows" when i try to create a row. After I use "List Rows" it allows me to select the table but there are no columns available in Dynamic Content... any idea how to fix this issue?
Hi
It is List Rows present in a table (Excel). Check your Excel sheet have more than one worksheet. I might have pointed to a different worksheet for the same file.
Thanks
Is it possible to execute any SQL query directly on an API that we define in "http" action? or is it even possible?
You mean via Open AI. Yes it is possible by asking via natural language and then AI will convert it using SQL query.
🎉🎉
Thanks a lot
This possible with free Power Automate version?
Hi @kayne3619
Thanks for watching the video.
No you need to buy some credit from OPEN API. I bought a 10$ credit and I have used a lot and so far I spend less than 2 dollars only. Its all about how much data you want to process (aka tokens). OPEN AI billed against how much tokens are used for each chat completion.
Power Automate has AI builder action steps. Have a look into it. Believe that's another license too.
Thanks