Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

statistics on the list

(0) ShareShare
ReportReport
Posted on by 40

Hi

i have a sharepoint list content the request with a date column and a status column and another column

i would like to put the information on the page of the site

  1. request 10 / 10 2020
  2. request 2 / 15 2021

What is the best solution to get the information and put this information on the page of the site ?

is mandatory to use Power Automate for this simple request ?

Regards

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    Hi 

    i created a indicator list sharepoint and updated the list since power automate

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    i try the code but it's seems outdated

     

     

     

     

     function GetAllStatuts(){
     var myURL = "../_api/web/lists/GetByTitle('Demandes%20EDI')/Items?$top=5000&$select=Statut";
     var AllStatuts = [];
     	$.ajax({
     url: myURL,
     async: false,
     method: "GET",
    			headers: { "accept": "application/json;odata=verbose" },
     success: function (data) {
     if (data.d.results.length > 0) {
     alert("success satut");
     AllStatuts = data.d.results;
     for (var i = 0; i < Number(AllStatuts.length); i++){
     alert("in loop");
     AllUniqueStatus.push(AllStatuts[i].Statut);
     } 
     
     AllUniqueStatus = removeDuplicates(AllUniqueStatus);
     alert(AllUniqueStatus.join("-"));
     }
    		},
    		error: function (error) {
    			alert("Error: " + JSON.stringify(error));
    		}
    	});
    	return AllUniqueStatus;
     }

     

     

     

    i have this errorError: {"readyState":4,"responseText":"{\"error\":{\"code\":\"-2147024891, System.UnauthorizedAccessException\",\"message\":{\"lang\":\"fr-FR\",\"value\":\"Attempted to perform an unauthorized operation.\"}}}","responseJSON":{"error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"fr-FR","value":"Attempted to perform an unauthorized operation."}}},"status":403,"statusText":"Forbidden"}

     

    it's seems the chart.js doesn't run with sharepoint online ?!?

     

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    it's very diificult to create a simply statistics on the list, i'm trying

    -Power BI but i don't have the right in my factory

    -Power Automate

    -chartjs with REST/API

     

    for the last solution is it possible to refresh automatically the graph on a page ? 

     

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    i'm tryng to use power automate to execute a request on the list 

    any news ?

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    @RobElliott or @CFernandes is it possible to resolve the problem simply with json or sql or other ?

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    yes @RobElliott , i have a sharepoint request list of the request for example

    request.png

    i would like a statistics on the web page site as

    dashboard.png

  • RobElliott Profile Picture
    RobElliott 10,008 on at
    Re: statistics on the list

    @pierrotori simplest solution is probably to add a List web part to the page and use a JSON-formatted view of that  list. But a bit more info about your data would help.

     

    Rob
    Los Gallardos

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    it's a big solution for only to resum a list to give the  total number by years and another basic or simple statistics

    thank you for the youtube link and blog

  • CFernandes Profile Picture
    CFernandes 8,146 on at
    Re: statistics on the list

    Hey mate, 

     

    Do you want to visualize SharePoint list data? Perhaps you can use Power BI - https://www.youtube.com/watch?v=okkdghpTF9c

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

  • pierrotori Profile Picture
    pierrotori 40 on at
    Re: statistics on the list

    What  is the most simple way to realize statistics on the sharepoint List ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard