Announcements
Hi everyone, I want to add a button that will Pull data from the already imported table and I want to select three columns to make a line chart of it. Can anyone tell me how can I do this?
To create a line chart in a canvas app by pulling data from an already imported table and selecting three columns, you can follow these steps:
Insert a button control onto your canvas app screen. You can find the button control in the Power Apps Studio under the Insert tab.
Select the button control, and in the Properties pane, set the OnSelect property to the following formula:
ClearCollect( ChartData, Table_Name ); Navigate(Screen_Name, ScreenTransition.None)
Replace "Table_Name" with the actual name of the table that contains your data, and replace "Screen_Name" with the name of the screen where you want to display the line chart.
The ClearCollect function is used to populate a collection named "ChartData" with the data from the specified table. This collection will be used as the data source for the line chart.
The Navigate function is used to navigate to the screen where you want to display the line chart. You can replace "Screen_Name" with the name of your desired screen.
On the screen where you want to display the line chart, insert a line chart control from the Power Apps Studio's Insert tab.
Select the line chart control, and in the Properties pane, set the Items property to the collection "ChartData" that you created in step 2.
Configure the line chart's properties to display the desired columns. In the properties pane, set the following properties:
Adjust other properties such as the title, legend, axis labels, etc., according to your preferences.
Preview or publish your app and click the button to pull the data and display the line chart on the designated screen.
By following these steps, you can create a button that pulls data from a table and displays a line chart based on the selected columns in your canvas app.
I don't know may be I'm using an older version of Powerapps that's why CategoryAxis, Values aren't visible in my case. But anyways ,thanks @ShaheerAhmad , that was helpful.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 405 Super User 2026 Season 2
Mohsin Ali 368
WarrenBelz 244 Most Valuable Professional
