Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Community Calls Conversations
Suggested answer

Line Graphics

(0) ShareShare
ReportReport
Posted on by 331
Hi Community,
 
I have a sharepoint list with a column that identifies control points (A, B, C, .....). Another column shows the time, and the third shows the temperature. How could I make it so that every time I enter a new measurement, a graph is displayed with the temperature on the Y axis and the time on the X axis, for the control point where I am entering the measurement?.
 
Thanks¡.
  • Suggested answer
    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.

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,318 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,111 Most Valuable Professional

Leaderboard

Featured topics