cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rixmcx59
Helper II
Helper II

Submitting form data to a DevOps project Wiki

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
victorcp
Solution Sage
Solution Sage

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&...

View solution in original post

victorcp
Solution Sage
Solution Sage

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

victorcp_0-1663075727889.png

and select all the columns that you want:

victorcp_1-1663075752771.png

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

 

View solution in original post

5 REPLIES 5
victorcp
Solution Sage
Solution Sage

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

victorcp_0-1663004693581.png

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

victorcp_2-1663005196438.png

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

victorcp_1-1663004945820.png

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

victorcp_3-1663005796997.png

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
Helper II
Helper II

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
Solution Sage
Solution Sage

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
Helper II
Helper II

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
Solution Sage
Solution Sage

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

victorcp_0-1663075727889.png

and select all the columns that you want:

victorcp_1-1663075752771.png

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

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,854)