Power Platform Community Forum Thread Details

Hello everyone!

I've recently started developing a large app with many data sources, containing multiple screens and components. One screen includes a comments section built around an Azure DevOps work item that is stored in an SQL database and then loaded into the Power App. From the app you can view the item details and add comments; those comments must be posted back to the ADO work item, and a gallery in the app displays all comments.

Currently, comments are delivered to the app and posted using a Power Automate flow. This approach has proven slow and sometimes causes errors where the Power App does not update at all.

I have been experimenting with the AzureDevOps Power Apps connector, which uses the same HttpRequest method as Power Automate, and I'm trying to adapt the Add Comment API method (see: Comments - Add - REST API (Azure DevOps Work Item Tracking) | Microsoft Learn) | Microsoft Learn). However, I think I'm formatting the request incorrectly.

Below is the request I'm building:

Set(
    varPostCommentResult;
    AzureDevOps.HttpRequest(
        OrgName;
        "POST";
        ProjectName"/_apis/wit/workItems/" & ADOItemID & "/comments?api-version=7.0-preview.3";
        {
            Body: "{""text"":""" & Text(CommentInput.Value) & """}"
        }
    )
);;

If(
    !IsBlank(varPostCommentResult.statusCode);
    If(
        varPostCommentResult.statusCode = 200;
        Notify("Comment posted!"; NotificationType.Success);;
        Reset(CommentInput);
        Notify("Failed (" & Text(varPostCommentResult.statusCode) & "): " & Text(varPostCommentResult.body); NotificationType.Error)
    );
    Notify("Request failed - no response received"; NotificationType.Error)
)

When I execute this function (I'm currently testing with the Onselect of a button) I get "Request Failed - No response received" from my Notify, and no further details from the connector to explain what went wrong. As you can see, I'm not using headers because I understand the connector handles authentication for me. When I try to add headers and header key/value pairs, I get the error "key field missing" and the request won't execute.

Has anyone tried this use case with the connector’s current version? Is this even possible? I will also need to change how the gallery is populated so it fetches comments directly from Azure, but I expect to handle that quickly once this request works.

Any input on this would be appreciated. Thanks!

Categories:

Building Power Apps

Hi,

I would first try to use GET to see if it is returning something.

Set(
    testResult,
    AzureDevOps.HttpRequest(
        OrgName,
        "GET",
        ProjectName & "/_apis/wit/workItems/" & ADOItemID & "/comments?api-version=7.0-preview.3"
    )
);

Also if your project name contains spaces use

EncodeUrl(ProjectName)

And if your ADOItemID is numeric but stored as text then use

Text(Value(ADOItemID))

For POST try this and see if it will work.

Set(
    varPostCommentResult,
    AzureDevOps.HttpRequest(
        OrgName,
        "POST",
        ProjectName & "/_apis/wit/workItems/" & ADOItemID & "/comments?api-version=7.0-preview.3",
        {
            Body: "{""text"":""" & Substitute(CommentInput.Text, """", "\""") & """}"
        }
    )
);

If(
    !IsBlank(varPostCommentResult),
    If(
        varPostCommentResult.statusCode = 200 || varPostCommentResult.statusCode = 201,
        Notify("Comment posted!", NotificationType.Success);
        Reset(CommentInput);
        // optionally refresh your comments gallery here
        ,
        Notify(
            "Failed (" & Text(varPostCommentResult.statusCode) & "): " &
            Text(varPostCommentResult.body),
            NotificationType.Error
        )
    ),
    Notify("Request failed - no response received", NotificationType.Error)
);