Show Azure DevOps Task / Sprint Statistics on SharePoint (PowerApps)

%3CLINGO-SUB%20id%3D%22lingo-sub-2143195%22%20slang%3D%22en-US%22%3EShow%20Azure%20DevOps%20Task%20%2F%20Sprint%20Statistics%20on%20SharePoint%20(PowerApps)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143195%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20show%20KPIs%20(Key%20Performance%20Indicator)%20on%20my%20SharePoint.%20My%20Datasource%20will%20be%20my%20TFS%20(Azure%20DevOps).%20For%20example%20showing%20the%20planned%20and%20finished%20Tasks%20for%20a%20Sprint%20on%20SharePoint%20and%20generate%20a%20graph%20out%20of%20it.%3C%2FP%3E%3CP%3EI%20saw%20that%20in%20Microsoft%20PowerApps%20-%20which%20are%20integrateable%20in%20my%20SharePoint-View%20-%20there%20are%20DevOps-Connectors%2C%20but%20i%20didnt%20rly%20saw%20a%20possibility%20to%20aggregate%20my%20task-statistics%20(planned%20%2F%20finished%20in%20a%20sprint)%20and%20show%20them.%3C%2FP%3E%3CP%3ESolution%3C%2FP%3E%3CP%3EWriting%20a%20C%23-Backend%20that%20has%20a%20TFS-Client%20running.%3C%2FP%3E%3CP%3ECan%20I%20use%20this%20for%20a%20Power-App-CustomConnector%3F%3CBR%20%2F%3EIs%20there%20another%20way%20to%20acess%20data%20in%20a%20PowerApp%20from%20a%20REST-API%3F%3CBR%20%2F%3EWorst%20Case%20the%20Backend%20will%20have%20shedule%20to%20create%20and%20update%20SharePoint-Tables%20with%20my%20TFS-Stats%3CBR%20%2F%3EWhat%20is%20the%20best%20way%20to%20aggregate%20and%20show%20my%20tfs%20(azure%20devOps)%20statistics%20on%20my%20sharepoint%20page%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2143195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I want to show KPIs (Key Performance Indicator) on my SharePoint. My Datasource will be my TFS (Azure DevOps). For example showing the planned and finished Tasks for a Sprint on SharePoint and generate a graph out of it.

I saw that in Microsoft PowerApps - which are integrateable in my SharePoint-View - there are DevOps-Connectors, but i didnt rly saw a possibility to aggregate my task-statistics (planned / finished in a sprint) and show them.

Solution

Writing a C#-Backend that has a TFS-Client running.

Can I use this for a Power-App-CustomConnector?
Is there another way to acess data in a PowerApp from a REST-API?
Worst Case the Backend will have shedule to create and update SharePoint-Tables with my TFS-Stats
What is the best way to aggregate and show my tfs (azure devOps) statistics on my page?

0 Replies