cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
plarrue
Power Apps
Power Apps

Question for everyone : How are you using Create Text GPT in AI Builder?

Hi everyone, 👋 From the AI Builder product group we want to hear from you.

 

👉Have you tried Text Generation in AI Builder already? How are you using it? For what use case? Is there anything you would like to see added or changed to make it even better?

 

👉We are interested in knowing about your AI Builder experience. Please share your story!

 

Thank you!

61 REPLIES 61
kmankash55
Advocate II
Advocate II

@Ashbhatia This new required step should really be a warning and not error. Some workflow simply will not work if a approval step is required after text generation. Please reconsider this new measure as its hindering development work.

takolota
Multi Super User
Multi Super User

I've now encountered an error many times with a specific prompt for a 4 page document. For some reason the Create text with GPT action returns a BadRequest 400 error & the error message says it timed out. It doesn't make sense considering I've had this work on 10+ page documents with many more characters. I wonder if there is something about a set of characters or something in this prompt that causes the time-out or maybe it has many more lines that GPT suspects may be relevant & so it takes it much longer?
BadRequestError.png

 

Prompt:

 

From the OCR captured packing list document text provided between [Start of text] & [End of text] markers, extract data for each of the example JSON fields between [Start example JSON] & [End example JSON].
Be aware, OCR text may contain errors like wrong characters or missing formatting.
In the JSON output, replace [data] with each field's extracted data text using only string datatypes. Use a string value of "NULL" when the field's data text is not found in the document text provided.
Convert all numbers to a standard 2-place decimal notation.
Convert all dates to international format "yyyy-mm-dd". For example, dates in the document text may start as something like 18.05.2024 or 3/21/2025, and need to be converted to 2024-05-18 & 2025-03-21 respectively.
If the document text has more than one Packing List Reference Number, then give a pipe | separated list of each number for the Packing List Reference Number field value like "12345678|98765432".
Packing List Date may also relate to the file's issued date. If there is more than one Packing List Date, then give the oldest, lowest date found for the Packing List Date.
Purchase Order (PO) Number is 2 letters & 8 digits like "PO########". Use only 2 letters, 8 digits for the PO field value.
If the document text includes text from multiple Packing List files then it may contain more than one Consignee Address & more than one Delivery Or Ship To Address. If more than one Consignee Address is found in the document text then give a space pipe space " | " separated list of each address for the Consignee Address field value. If more than one Delivery Or Ship To Address is found in the document text then give a space pipe space " | " separated list of each address for the Delivery Or Ship To Address field value. A hypothetical example of this list structure with more than one address value: "123 St. Miami, Fl 55555 USA | 456 St. Miami, Fl 44444 USA".
The Chemonics Address in the document text often starts with 1275 New Jersey. If such an address starting with 1275 New Jersey is not found, just return "NULL".
Mode Of Shipment (MOS) may also go by Mode Of Transport & the value is usually Air, Sea, or Land.
There may be any number of Product Lines. Each Product Line should include Product Name, Quantity, Unit Price, Line Amount Or Total, Manufactuer, Batch Or Lot Number, Product Manufacture Date (MFG), & Product Expiration Date.


[Start example JSON]
{
"Packing List Date": [data],
"Packing List Reference Number": [data],
"Invoice Number": [data],
"Purchase Order (PO) Number": [data],
"Consignee Address": [data],
"Delivery Or Ship To Address": [data],
"Chemonics Address": [data],
"Mode Of Shipment": [data],
"Final Destination Or Final Delivery Location": [data],
"Special Temperature Requirements": [data],
"Product Lines": [
{
"Product Name": [data],
"Product Quantity": [data],
"Product Unit Price": [data],
"Product Line Total or Amount": [data],
"Manufacturer": [data],
"Batch Or Lot Number": [data],
"Manufacture Date (MFG)": [data],
"Expiration Date": [data]
},
{
"Product Name": [data],
"Product Quantity": [data],
"Product Unit Price": [data],
"Product Line Total or Amount": [data],
"Manufacturer": [data],
"Batch Or Lot Number": [data],
"Manufacture Date (MFG)": [data],
"Expiration Date": [data]
}
]
}
[End example JSON]


[Start of text]
     ______________________________________________________________________________________________________________________________________________________________


     Job......: QPADEV003R             Packing list and certificate of weight for  197 xxxxxxxx                Date.....: 2022/10/14
     Program..: PKDE624R              Tour : EATG3   Expected Ship Date 2022/10/14                        Time.....:  9:21:39


     User.....: MORENCX3 ______________________________________________________________________________________________________________________________________________________________ Page.....: 0001

                                ListNo                     Size          Gross                    Width           Volume
                                ______       Description ___________________  _____   Qty ___    _________ Wgh  Net _________ Wgh   Length ______   ______   Height ______    ______




     Customer No: 106 0056725901  Dly-Slip3923441      CUST.REF .: PO10022355 PO10022355
        1  CASE FROM  11                                                                   60,0 cm  50,0 cm  59,5 cm 178500,00
                                                                       24,954 kg   6,512 kg                             ccm
                                2G3170       RT HIV-1 CAL       00001       10
                                2G3170       RT HIV-1 CAL       00001       4

                                2G3180       RT HIV-1 CTL       00001       8
        2  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3180       RT HIV-1 CTL       00001       22

        3  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3180       RT HIV-1 CTL       00001       22

        4  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3180       RT HIV-1 CTL       00001       22
        5  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3180       RT HIV-1 CTL       00001       22
        6  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3180       RT HIV-1 CTL       00001       22

        7  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3180       RT HIV-1 CTL       00001       22

        8  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3180       RT HIV-1 CTL       00001       22
        9  CASE FROM  11                                                                   60,0 cm  50,0 cm  59,5 cm 178500,00
                                                                       24,954 kg   6,512 kg                             ccm
                                2G3180       RT HIV-1 CTL       00001       22
       10  CASE FROM  11                                                   24,954 kg   6,512 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3180       RT HIV-1 CTL       00001       22
       11  CASE FROM  11                                                    7,452 kg   0,296 kg  30,0 cm  33,0 cm  37,5 cm  37125,00  ccm
                                2G3180       RT HIV-1 CTL       00001       1





     Customer No: 106 0056725901  Dly-Slip3923442      CUST.REF .: PO10022355 PO10022355
        1  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
        2  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

        3  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

        4  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
        5  CASE FROM  79                                                                   60,0 cm  50,0 cm  59,5 cm 178500,00
                                                                       24,805 kg   6,363 kg                             ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
        6  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
        7  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

        8  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

        9  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       10  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       11  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       12  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21





     ______________________________________________________________________________________________________________________________________________________________


     Job......: QPADEV003R             Packing list and certificate of weight for  197 TANZANIA                Date.....: 2022/10/14
     Program..: PKDE624R              Tour : EATG3   Expected Ship Date 2022/10/14                        Time.....:  9:21:39


     User.....: MORENCX3 ______________________________________________________________________________________________________________________________________________________________ Page.....: 0002

                                ListNo                     Size          Gross                    Width           Volume
                                ______       Description ___________________  _____   ___ Qty    _________ Wgh  Net _________ Wgh   ______ Length   ______   ______ Height    ______




     Customer No: 106 0056725901  Dly-Slip3923442      CUST.REF .: PO10022355 PO10022355
       13  CASE FROM  79                                                                   60,0 cm  50,0 cm  59,5 cm 178500,00
                                                                       24,805 kg   6,363 kg                             ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       14  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       15  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       16  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       17  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       18  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       19  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       20  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       21  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       22  CASE FROM  79                                                                   60,0 cm  50,0 cm  59,5 cm 178500,00
                                                                       24,805 kg   6,363 kg                             ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       23  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       24  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       25  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       26  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       27  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       28  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       18

                                2G3110       RT HIV-1 AMP KIT 96T 00096       3
       29  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       30  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       31  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       32  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       33  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       34  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       35  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       36  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       37  CASE FROM  79
                                                                       24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       38  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm





     ______________________________________________________________________________________________________________________________________________________________


     Job......: QPADEV003R             Packing list and certificate of weight for  197 TANZANIA                Date.....: 2022/10/14
     Program..: PKDE624R              Tour : EATG3   Expected Ship Date 2022/10/14                        Time.....:  9:21:39


     User.....: MORENCX3 ______________________________________________________________________________________________________________________________________________________________ Page.....: 0003

                                ListNo                     Size          Gross                    Width           Volume
                                ______       Description ___________________  _____   ___ Qty    _________ Wgh  Net _________ Wgh   ______ Length   ______   ______ Height    ______




     Customer No: 106 0056725901  Dly-Slip3923442      CUST.REF .: PO10022355 PO10022355
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       39  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       40  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       41  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       42  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       43  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       44  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       45  CASE FROM  79
                                                                       24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       46  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       47  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       48  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       49  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       50  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       51  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       52  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       53  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       54  CASE FROM  79
                                                                       24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       55  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       56  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       57  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       58  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       59  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       60  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       61  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       62  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       63  CASE FROM  79
                                                                       24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       64  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm





     ______________________________________________________________________________________________________________________________________________________________


     Job......: QPADEV003R             Packing list and certificate of weight for  197 TANZANIA                Date.....: 2022/10/14
     Program..: PKDE624R              Tour : EATG3   Expected Ship Date Expected Ship Date 2022/10/14                        Time.....:  9:21:39


     User.....: MORENCX3 ______________________________________________________________________________________________________________________________________________________________ Page.....: 0004

                                                                     Gross
                              ListNo______     Description ___________________ Size_____ Qty___   _________ Wgh  Net _________ Wgh Length______ Width______ Height______ Volume______




     Customer No: Customer No: 106 0056725901 0056725901  Dly-Slip: Dly-Slip: 3923442 3923442      CUST.REF.: CUST.REF.: PO10022355 PO10022355
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       65  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       66  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       67  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       68  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       69  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       70  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       71  CASE FROM  79
                                                                       24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       72  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       73  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       74  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       75  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       76  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       77  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm

                                2G3110       RT HIV-1 AMP KIT 96T 00096       21
       78  CASE FROM  79                                                   24,805 kg   6,363 kg  60,0 cm  50,0 cm  59,5 cm 178500,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       21

       79  CASE FROM  79                                                   22,051 kg   5,454 kg  60,0 cm  50,0 cm  53,0 cm 159000,00  ccm
                                2G3110       RT HIV-1 AMP KIT 96T 00096       18





       Registration Number: TAN 19 MDR 0584



                                                     xxxxxxxxx
                                                  Max-Planck-Ring 2
                                                    xxxxxxxxxxxxxx
                                                     xxxxxxx



[End of text]


Return only the final JSON object. Do not return any other output descriptions or explanations, only the JSON object.

 

 

 

I've created a way to error-handle this by setting a parallel branch to run the GPT action with only the 1st 5000 document text characters & that works to extract all the available data on the 1st page or so. But I'm wondering if there is anything else that can be done on Microsoft's side to improve the model performance & reduce the timeout error.

NowFlow.png

Looks like we both work with logistics, shipping. I will bookmark this prompt to test with my packing lists later 😁

takolota
Multi Super User
Multi Super User

Has Microsoft started applying AI Credits Usage per Create text with GPT prompt or tokens?

I just had a flow fail due to running out of credits. Now I have many more credits available to apply to the environment, but I wouldn't have expected this to happen with the amount of credits already assigned unless the credit cost/usage for this action was outrageously higher than the $.003 per 1000 tokens listed on Logic Apps.

We are facing the exact same issue here, but thought the problem was on our end since we just created a new Environment specific for AI Builder. I wonder what's happening now because we have a lot of credits. My Power Platform admin was going to reach out to Microsoft 

takolota
Multi Super User
Multi Super User

Yes, looks like the action is now taking credits. And oohhhh boy, it is 8.5X MORE EXPENSIVE than the same resources one could access through Azure LLMs or through even the OpenAI HTTP calls. Why does Microsoft think people will pay $.0255 per 1000 tokens for something they could directly call on their own for $.003 per 1000 tokens???

361 Credits for a 28,400 character prompt, using $500 add-on for 1 million credits pricing makes 361 credits = $.1805
Credit usage.png

 

Price comparison to Azure which is equivalent with OpenAI pricing.

AzureCost.png

 

Why does Microsoft ham-string themselves with stupid pricing every time for Power Platform stuff? They say it is because these are on "low-code" tools with lower skill requirements, but frankly it is the same level of skill as any other system. The way they try to get everyone on this is by not offering things like Power Apps actions in Logic Apps.

@ARB_wcc 

takolota
Multi Super User
Multi Super User

At these prices, if anyone is considering using GPT in their Power Automate workflows & you aren’t working with really sensitive data, then you may want to sign up for OpenAI’s direct API services prepare your flows to use the HTTP action to call OpenAI directly.

 https://openai.com/blog/openai-api

 

https://platform.openai.com/docs/guides/gpt

For my personal projects, I've been using OpenAI's API service almost since its inception. The flexibility and fewer restrictions make it feel like I can accomplish more with OpenAI. However, at my workplace, the OpenAI connector is unfortunately blocked due to DLP policies.

@ARB_wcc 

Well next I'm going to test the Azure OpenAI set-up. Because usually in situations like these we can also just do an HTTP request back to an Azure Logic app that uses the Azure version of a service, then send the results in a response back to the flow which can then return it to a Power App or whatever other service that is only available in the regular Power Automate flows. That allows us to get that lower Azure price, even in a Power App.

takolota
Multi Super User
Multi Super User

@ARB_wcc 

From what I'm looking at in a test Azure resource & this helpful guide, it looks like one can just directly call an API endpoint for one's LLM set-up & get the response back in the HTTP action. So at least that means no Logic Apps work-around as long as one has all the required licensing for premium connectors.
A practical look at using and building on Azure OpenAI, specifically the "ChatGPT-style" feature (ju...

In an ideal scenario, the process of extracting data from text should be as straightforward and user-friendly as possible, that's why the "preview" connector "Create Text with GPT" became so popular in my opinion. The need for premium connectors or alternative solutions like Logic Apps should be minimized, but as Microsoft continues to evolve its pricing and restrictions for AI Builder, it's becoming increasingly apparent that complex setups may become the standard approach, rather than an exception. This shift could potentially create barriers for users who are looking for simple, cost-effective solutions. By the way, what's insteresting is that this page AI Builder licensing and credit management | Microsoft Learn states that "AI Builder features that are in preview release status are free to use. You don't need to obtain a license to use AI Builder preview features", however, in practice, it doesn't seem like anything is truly free 🤔

Antoine2F
Power Apps
Power Apps

Hello,

 

An engineering issue in our environment monitoring pipeline has caused the “Create text with GPT” action to trigger incorrect credit consumption. Since the “Create text with GPT” action is still in preview, it should not be triggering credit consumption. A fix is in progress and will be rolling out as soon as possible.

 

We will be proactively reaching out to impacted customers to reimburse the credits that were consumed erroneously. If you believe you have been incorrectly charged for use of the GPT action, please contact: aihelpen@microsoft.com

 

Additionally, the prices discussed in this forum don’t reflect the definite rates that will be applied.  Stay tuned for details on definitive rates that will be announced next month.

 

We apologize for the inconvenience.

Antoine2F

Well, that explains a lot! 

@takolota it looks like you won't have to resort to plan B and plan C 😅

We may have spoken too soon. The original Create text with GPT action is now deprecated and the new Create text with GPT using a prompt action seems more limited because it requires choosing specific prompts & the extraction prompt is more limited.

 

 

ALSO I now do not have access to the intricate prompts I created in the original actions as they no longer open.

 

Thankfully I still have a little time to go back through past flow runs & pull the prompt text from those, but what is Microsoft doing?

ARB_wcc
Super User
Super User

@takolota 

 

They need to fix this asap, I think the post below is the best place to post our complaints now 😅

 

GPT Prompt Builder goes GA and expands to EU,UK,AU - Power Platform Community (microsoft.com)

@ARB_wcc 

I'm looking through this again this morning & it looks like something fell between the cracks with both the new AI Builder GPT action & the classic designer that my flows were still in. On the classic designer, the option to create a new custom prompt isn't clear. I'm testing to see how the custom prompt will work and if it is any extra trouble for users while importing a template flow.

takolota
Multi Super User
Multi Super User

@ARB_wcc 

Alright, now there is an issue with custom prompts & solution imports/exports...

So we can no longer export flows as zip folders, we must export flows inside Solution packages. But if your flow uses any custom prompt, then the Solution package will fail to import to any other environment because the environment does not have the custom prompt resource anywhere. 🙄

 

I could normally use the legacy flow zip import/export or put everything inside a scope to copy to clipboard & paste, but both of those options were removed with the introduction of the new flow designer interface.

It seems the rush to release software has become a race against the calendar, not bugs. It's like Microsoft's playing speed chess with updates—checkmate by New Year's Eve, ready or not.

 

Maybe they should take a leaf out of Rockstar Games' playbook: good things come to those who wait... a decade if necessary. We'll wait for the win, as long as the final level isn't glitched! 😅

takolota
Multi Super User
Multi Super User

@plarrue @Antoine2F

When will solutions support importing packages with custom prompts?

Currently Microsoft has a couple of my projects in a bad catch-22 situation where I can't edit the prompts of the previous GPT preview action because it is deprecated, but I also can't switch to the new GPT prompt action without losing the ability to export & import solutions to different Dev & Production environments.

NoCustomPromptSupportInSolutions.png

CedrickB
Power Apps
Power Apps

Hi Takola,
If you copy your prompt created with the Public Preview Create text with GPT and then create a new custom prompt using the former prompt, you should be able to add it to a solution and move it across environments.
Are you saying that this is not working?

Helpful resources

Announcements

Win free tickets to the Power Platform Conference | Summer of Solutions

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**

Celebrating the June Super User of the Month: Markus Franz

Markus Franz is a phenomenal contributor to the Power Apps Community. Super Users like Markus inspire others through their example, encouragement, and active participation.    The Why: "I do this to help others achieve what they are trying to do. As a total beginner back then without IT background I know how overwhelming things can be, so I decided to jump in and help others. I also do this to keep progressing and learning myself." Thank you, Markus Franz, for your outstanding work! Keep inspiring others and making a difference in the community! 🎉  Keep up the fantastic work! 👏👏 Markus Franz | LinkedIn  Power Apps: mmbr1606  

Copilot Cookbook Challenge | Week 1 Results | Win Tickets to the Power Platform Conference

We are excited to announce the "The Copilot Cookbook Community Challenge is a great way to showcase your creativity and connect with others. Plus, you could win tickets to the Power Platform Community Conference in Las Vegas in September 2024 as an amazing bonus.   Two ways to enter: 1. Copilot Studio Cookbook Gallery:  https://aka.ms/CS_Copilot_Cookbook_Challenge 2. Power Apps Copilot Cookbook Gallery: https://aka.ms/PA_Copilot_Cookbook_Challenge   There will be 5 chances to qualify for the final drawing: Early Bird Entries: March 1 - June 2Week 1: June 3 - June 9Week 2: June 10 - June 16Week 3: June 17 - June 23Week 4: June 24 - June 30     At the end of each week, we will draw 5 random names from every user who has posted a qualifying Copilot Studio template, sample or demo in the Copilot Studio Cookbook or a qualifying Power Apps Copilot sample or demo in the Power Apps Copilot Cookbook. Users who are not drawn in a given week will be added to the pool for the next week. Users can qualify more than once, but no more than once per week. Four winners will be drawn at random from the total qualifying entrants. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once. If they are drawn multiple times, another user will be drawn at random. Prizes:  One Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value, does not include travel, lodging, or any other expenses) Winners are also eligible to do a 10-minute presentation of their demo or solution in a community solutions showcase at the event. To qualify for the drawing, templates, samples or demos must be related to Copilot Studio or a Copilot feature of Power Apps, Power Automate, or Power Pages, and must demonstrate or solve a complete unique and useful business or technical problem. Power Automate and Power Pagers posts should be added to the Power Apps Cookbook. Final determination of qualifying entries is at the sole discretion of Microsoft. Weekly updates and the Final random winners will be posted in the News & Announcements section in the communities on July 29th, 2024. Did you submit entries early?  Early Bird Entries March 1 - June 2:  If you posted something in the "early bird" time frame complete this form: https://aka.ms/Copilot_Challenge_EarlyBirds if you would like to be entered in the challenge.   Week 1 Results:  Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1.  @Mathieu_Paris 1.   @SpongYe 2.  @Dhanush 2.   @Deenuji 3.  n/a3.   @Nived_Nambiar  4.  n/a4.   @ManishSolanki 5.  n/a5.    n/a

Your Moment to Shine: 2024 PPCC’s Got Power Awards Show

For the third year, we invite you, our talented community members, to participate in the grand 2024 Power Platform Community Conference's Got Power Awards. This event is your opportunity to showcase solutions that make a significant business impact, highlight extensive use of Power Platform products, demonstrate good governance, or tell an inspirational story. Share your success stories, inspire your peers, and show off some hidden talents.  This is your time to shine and bring your creations into the spotlight!  Make your mark, inspire others and leave a lasting impression. Sign up today for a chance to showcase your solution and win the coveted 2024 PPCC’s Got Power Award. This year we have three categories for you to participate in: Technical Solution Demo, Storytelling, and Hidden Talent.      The Technical solution demo category showcases your applications, automated workflows, copilot agentic experiences, web pages, AI capabilities, dashboards, and/or more. We want to see your most impactful Power Platform solutions!  The Storytelling category is where you can share your inspiring story, and the Hidden Talent category is where your talents (such as singing, dancing, jump roping, etc.) can shine! Submission Details:  Fill out the submission form https://aka.ms/PPCCGotPowerSignup by July 12th with details and a 2–5-minute video showcasing your Solution impact. (Please let us know you're coming to PPCC, too!)After review by a panel of Microsoft judges, the top storytellers will be invited to present a virtual demo presentation to the judges during early August. You’ll be notified soon after if you have been selected as a finalist to share your story live at PPCC’s Got Power!  The live show will feature the solution demos and storytelling talents of the top contestants, winner announcements, and the opportunity to network with your community.  It's not just a showcase for technical talent and storytelling showmanship, show it's a golden opportunity to make connections and celebrate our Community together! Let's make this a memorable event! See you there!   Mark your calendars! Date and Time: Thursday, Sept 19th Location: PPCC24 at the MGM Grand, Las Vegas, NV 

Tuesday Tip | Accepting Solutions

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   To enhance our collaborative environment, it's important to acknowledge when your question has been answered satisfactorily. Here's a quick guide on how to accept a solution to your questions: Find the Helpful Reply: Navigate to the reply that has effectively answered your question.Accept as Solution: Look for the "Accept as Solution" button or link, usually located at the bottom of the reply.Confirm Your Selection: Clicking this button may prompt you for confirmation. Go ahead and confirm that this is indeed the solution.Acknowledgment: Once accepted, the reply will be highlighted, and the original post will be marked as "Solved". This helps other community members find the same solution quickly. By marking a reply as an accepted solution, you not only thank the person who helped you but also make it easier for others with similar questions to find answers. Let's continue to support each other by recognizing helpful contributions. 

Reminder: To register for the Community Ambassador Call on June 13th

Calling all Super Users & User Group Leaders   Reminder: To register for the Community Ambassador Call on June 13th—for an exclusive event for User Group Leaders and Super Users! This month is packed with exciting updates and activities within our community.   What's Happening: Community Updates: We'll share the latest developments and what's new in our vibrant community.Special Guest Speaker: Get ready for an insightful talk and live demo of Microsoft Copilot Studio templates by our special guest.Regular Updates: Stay informed with our routine updates for User Groups and Super Users.Community Insights: We'll provide general information about ongoing and upcoming community initiatives. Don't Miss Out: Register Now: Choose the session that fits your schedule best.Check your private messages or Super User Forum for registration links. We're excited to connect with you and continue building a stronger community together.   See you at the call!  

Top Solution Authors
Users online (3,022)