Unanswered

Submitting form data to a DevOps project Wiki

(0) Share

Report

Posted on by rixmcx59

158

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

victorcp 2,350 Moderator on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report

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&tabs=HTTP

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No