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
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
Hi
i created a indicator list sharepoint and updated the list since power automate
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 ?!?
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 ?
i'm tryng to use power automate to execute a request on the list
any news ?
@RobElliott or @CFernandes is it possible to resolve the problem simply with json or sql or other ?
yes @RobElliott , i have a sharepoint request list of the request for example
i would like a statistics on the web page site as
@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
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
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.
What is the most simple way to realize statistics on the sharepoint List ?