Submitting form data to a DevOps project Wiki

[rixmcx59]

Hello all, it appears that adding/editing DevOps project work items is possible. Is there a way to submit PA form data to a project wiki? The only information I have found on this is in the "Power Apps Ideas".

Thanks for any help

[victorcp]

Yes, it is possible. There is a premium conector that allow you to connect to devops.

First, you will need to enable the dynamic Schema, under setting upcoming features (after change it you have to close and open the app)

To retrieve information from azure use have to create a query, here:

And then use AzureDevOps.GetQueryResultsV2, to get the all the items in the query, after write that code you have to capture the schema it will convert the data into a collection

And to update/create you can use this function: AzureDevOps.UpdateWorkItem/AzureDevOps.CreateWorkItem

For more information: https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/azure-devops

I hope it helps 🙂

[rixmcx59]

Hello and thanks for the response, this solution can post form data to the wiki? do you have an example of what it looks like? a table possibly with title and value? I will test this and let you know, I am not sure if we have premium license.

Thanks again

[victorcp · Accepted solution]

Hi,

I missunderstood you, sorry.

To update the wiki you have to use Power Automate and send a http request (premmium connector) to the DevOps API.

https://docs.microsoft.com/en-us/rest/api/azure/devops/wiki/wikis/update?view=azure-devops-rest-6.0&...

[rixmcx59]

Thank you, exactly what I was looking for. By chance do you know if custom columns from a inherited process can be used in a DevOps query. My goal is to create a PowerApps form using custom columns from the process, then post the form data to the wiki. 

Thanks again

[victorcp · Accepted solution]

yes, it also possible, you will need to add the custom columns to the query here:

and select all the columns that you want:

after you change the query you will need to capture the schema again