Power Platform Community Forum Thread Details

Line Graphics

Hi,

1. Prepare Your Data Source

Ensure your SharePoint list has the following columns:

ControlPoint (text, e.g., "A", "B", "C", etc.)
Time (datetime)
Temperature (number)

2. Setup Your PowerApps App

a. Connect PowerApps to the SharePoint List

Open your PowerApps app.
Connect your app to the SharePoint list containing the control points, time, and temperature data.

b. Create a Filtered Table for a Specific Control Point

Add a gallery or a collection that filters data based on the selected control point.
Example formula to filter the data for a specific control point (e.g., "A"):
```
Filter('Your SharePoint List', ControlPoint = "A")
```

c. Create the Graph

Use the filtered table to create the graph.
Add a line chart or bar chart, setting:
- X-Axis: Time
- Y-Axis: Temperature

d. Graph Formula

If using a bar chart:

BarChart(
Filter('Your SharePoint List', ControlPoint = "A"),
Time,
Temperature
)

If using a line chart:

LineChart(
Filter('Your SharePoint List', ControlPoint = "A"),
Time,
Temperature
)

e. Select Control Point

Add a dropdown or text input to select the control point (A, B, C, etc.).

Use the selected value to filter the data for the graph:

Dropdown(
Items: Distinct('Your SharePoint List', ControlPoint),
Value: controlPointSelection,
OnSelect: Set(controlPointSelection, Dropdown.Selected)
)

3. Enhancements

Date Filtering: Add additional filters (e.g., for a specific time period) to refine the graph.
Formatting: Customize the graph's appearance (colors, titles, labels) to match your needs.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Quick Links

Leaderboard