Share
Report
84Hi there,
I have several Google Sheets with are updated constantly from our CRM system. I want to be able to display the DATA in my Power App.
The first thing I want to do with this data is to display a count of the rows in the Current Month and display this as a number. This number would update as more data comes into the Google Sheet and reset to zero at the start of each month ready for new data to be added.
The second is that I want to be able to show a count of each postcode area as a pie chart. This would be controlled by a drop-down menu so you can view the data over different time periods.
The images I am sharing in the post is my current App and the data is showing from Tables in Sharepoint. I have had to make a very convoluted system using Zapier and Power Automate to get the data automatically out of my CRM system and into a Sharepoint List. This isn't that reliable and data sometimes fails. I am hoping by using the data directly from Google Sheets will be better.
Thanks in advance.
Ian
All responses (
Answers (
