Create a button to extract sharepoint list and run python script

[exploringG]

Dear PowerAppers, 

Here I am again looking for your wise ideas. 

Previously, I created an APP to collect user data and save the data to a SharePoint list. With everyone's help, it was a successful product. The initial idea is creating an APP to collect data and save in excel file. Then, use the data to analyse and create bar chart and pie chart. At last, the generated plots will be send to a supervisor by Email. Now the first step is done. However, I'm looking for a way to do all these steps by clicking a few buttons in the APP. 

Now I'm trying to use Python to create a Pivot Table using the collected data. From my research, I could generate certain plots in python as well. 

My question is, is it possible to create a Button in my APP  to somehow trigger the process in Python? Or we do not need to use Python at all and there are some other genius methods to analyse the collected data and create plots directly from SharePoint list.

It's a complex idea to be realized. I'd appreciate you opinion or advice on it. 

Thank you very much in advance.

Sincerely,

exploringG

[LuizVicente · Accepted solution]

I really love Python, but it wouldn't be my first choice here unless it involved Power BI. Regarding Python, I believe you could use it but through a custom connector.
Other than that, take a look at this idea:
- Quickchart: You can generate multiple charts by sending data via a URL and display the chart in an image or html control.

See:

To generate this graph I used this code in an html control:

"<img src=https://quickchart.io/chart?c="&EncodeUrl("{
   'type': 'horizontalBar',
   'data': {
     'labels': [
       'GWT',
       'CTI',
       'NFV0',
       'UL94V0'
     ],
     'datasets': [
       {
         'label': 'RED',
         'backgroundColor': 'rgba(255, 99, 132, 0.5)',
         'borderColor': 'rgb(255, 99, 132)',
         'borderWidth': 1,
         'data': [
           4,
           0,
           2,
           0
         ]
       },
       {
         'label': 'KABUL',
         'backgroundColor': 'rgba(54, 162, 235, 0.5)',
         'borderColor': 'rgb(54, 162, 235)',
         'data': [
            " & Label9.Text & ",
            " & Label7.Text & ",
            " & Label6.Text & ",
            " & Label4.Text & "
         ]
       }
     ]
   },
   'options': {
     'elements': {
       'rectangle': {
         'borderWidth': 2
       }
     },
     'responsive': true,
     'legend': {
       'position': 'right'
     },
     'title': {
       'display': true,
       'text': 'Test Türlerine göre kabul ve red adetleri'
     }
   }
 }") & " />"

[exploringG]

Dear @LuizVicente ,

Thank you very much for your idea! It looks really interesting. I shall give it a try. 

About Power BI, I thought about it and tried the standard version but it did not fulfill my needs. Otherwise, I need to pay for the Pro version which is not in my 'shopping list' for now. 

My current mission is plot a stacked bar chart in python. I do think it is possible but the idea you have provided looks really fun to try. 

I'll give it a try and let you know how it goes. 

Thanks again. 

Best,

exploringG