Answered

Lookup value from Azure Devops

(0) Share

Report

Posted on by Aadvik

Hi Team,

I have a Power Apps which is connected with SharePoint. I need to bring a Status Column from Azure Devops by Lookup using ID from SharePoint and ID From Azure Devops. Is it possible to do?

Source: SharePoint	Source: Azure Devops
Column Name ID	Column Name Status
1	New
2	Closed

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Aadvik,

You need to connect to Azure Devops and get the data using the property parameter from Azure DevOps - Connectors | Microsoft Learn

Collect the data from your Azure Devops and add a temporary column using AddColumns() for your SP list data:

AddColumns(list, "Status",LookUp(Collection_AzureDevops,ID=ID).Status)

Then you could bring your status column to your list.

Was this reply helpful? Yes No
Aadvik 12 on at

Like (0)

Report
Copy link

Link copied!
@v-qiaqi-msft I have used Azure DevOps - Connectors and created a Gallery and Added below formula under Items->

AzureDevOps.GetQueryResultsV2("ProjectName","QueryID","Org").value

Gallery1 name -> AzureOps
Gallery2 name -> Sharepointgallerylist.

when I tried to add the formula which you provided as below, I am getting error in finding the ID from AzureOps Gallery.

AddColumns(Sharepointgallerylist, "Status",LookUp(AzureOps,ID=ID).Status)

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Aadvik，

Do you want to display the corresponding status to ID within the Gallery directly.

If so, I think you could directly refer to ThisItem.ID to get the status. Just set the Text property of the Label within the Gallery as below:

LookUp(Gallery1.AllItems,IDLabel.Text=ThisItem.ID).Status

Note that the IDLabel represents the label name in your Gallery1 tthat displays the ID from AzureOps.

Or you could refer to the AzureOps directly as below:

LookUp(AzureDevOps.GetQueryResultsV2("ProjectName","QueryID","Org").value,ID=ThisItem.ID).Status

Was this reply helpful? Yes No
Aadvik 12 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-qiaqi-msft - Thanks a lot for your help. I almost got what I need.
The Query in AzureDevops returns more than 2K rows. The Gallery which I connected via AzureDevops Connector - It displays only 1000 rows. But I have provided the Max count as 20000. May I know what will be the issue here, only then I can able to validate the data.
AzureDevOps.GetQueryResultsV2("ProjectName","QueryID","Org",{workItemsCount:20000}).value

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Aadvik,

This is a delegation issue.

Even thought the AzureDevops could get 20000 work items at max, however, it's a known issue, Gallery could only display 2000 records at max.

Was this reply helpful? Yes No
tech-44 39 on at

Like (0)

Report
Copy link

Link copied!

Azure DevOps provides a robust REST API that allows you to programmatically access and retrieve data from Azure DevOps. Using various filters and parameters, you can use this API to look up values, such as work items, repositories, builds, releases, and more.

Was this reply helpful? Yes No