Power Platform Community Forum Thread Details

This formula is OnChange action of the form processor and it was working fine but then it stopped returning any values in the Result Set.

ClearCollect(
    ExtractedData1,
    {
        Title: "Capacity",
        Value: Text(AIForm.Results.Capacity.Value), // Ensure correct data access
        Page: Value(AIForm.Results.Capacity.PageNumber),
        Confidence: Text(AIForm.Results.Capacity.Confidence * 100, "0.0") & "%"
    },
    {
        Title: "Speed",
        Value: Text(AIForm.Results.Speed.Value),
        Page: Value(AIForm.Results.Speed.PageNumber),
        Confidence: Text(AIForm.Results.Speed.Confidence * 100, "0.0") & "%"
    },
    {
        Title: "Type",
        Value: Text(AIForm.Results.Type.Value),
        Page: Value(AIForm.Results.Type.PageNumber),
        Confidence: Text(AIForm.Results.Type.Confidence * 100, "0.0") & "%"
    },
    {
        Title: "Quantity",
        Value: Text(AIForm.Results.Quantity.Value),
        Page: Value(AIForm.Results.Quantity.PageNumber),
        Confidence: Text(AIForm.Results.Quantity.Confidence * 100, "0.0") & "%"
    }
);

Categories:

Building Power Apps

If your formula was working fine before but suddenly stopped returning values, here are some troubleshooting steps to diagnose and fix the issue:

1. Check if AIForm Has Data

If AIForm.Results is empty or does not contain expected values, your ClearCollect will not populate ExtractedData1. Test this by adding a label and setting its text to:

If nothing appears, the issue might be with your AI model or the form processor failing to extract data.

2. Ensure Fields Exist in AIForm.Results

If the structure of AIForm.Results changed, verify that Capacity, Speed, Type, and Quantity still exist. Try using:

If it returns blank or an error, the field might be missing or renamed.

3. Use the Monitor Tool

Go to Advanced Tools → Monitor and observe what AIForm.Results contains when you submit a form. This can reveal if the AI model is returning empty results.

4. Handle Missing Data with Defaults

If some fields might be missing, update your formula to handle Blank() values:

ClearCollect(

ExtractedData1,

{

Title: "Capacity",

Value: If(!IsBlank(AIForm.Results.Capacity), Text(AIForm.Results.Capacity.Value), "N/A"),

Page: If(!IsBlank(AIForm.Results.Capacity), Value(AIForm.Results.Capacity.PageNumber), 0),

Confidence: If(!IsBlank(AIForm.Results.Capacity), Text(AIForm.Results.Capacity.Confidence * 100, "0.0") & "%", "0%")

},

{

Title: "Speed",

Value: If(!IsBlank(AIForm.Results.Speed), Text(AIForm.Results.Speed.Value), "N/A"),

Page: If(!IsBlank(AIForm.Results.Speed), Value(AIForm.Results.Speed.PageNumber), 0),

Confidence: If(!IsBlank(AIForm.Results.Speed), Text(AIForm.Results.Speed.Confidence * 100, "0.0") & "%", "0%")

},

{

Title: "Type",

Value: If(!IsBlank(AIForm.Results.Type), Text(AIForm.Results.Type.Value), "N/A"),

Page: If(!IsBlank(AIForm.Results.Type), Value(AIForm.Results.Type.PageNumber), 0),

Confidence: If(!IsBlank(AIForm.Results.Type), Text(AIForm.Results.Type.Confidence * 100, "0.0") & "%", "0%")

},

{

Title: "Quantity",

Value: If(!IsBlank(AIForm.Results.Quantity), Text(AIForm.Results.Quantity.Value), "N/A"),

Page: If(!IsBlank(AIForm.Results.Quantity), Value(AIForm.Results.Quantity.PageNumber), 0),

Confidence: If(!IsBlank(AIForm.Results.Quantity), Text(AIForm.Results.Quantity.Confidence * 100, "0.0") & "%", "0%")

}

);