Skip to main content

Notifications

Community site session details

Community site session details

Session Id : KHI4uF2KBlVQ+VXGY8oBrZ
Power Apps - Community Calls Conversations
Suggested answer

Line Graphics

Like (0) ShareShare
ReportReport
Posted on 17 Dec 2024 00:32:43 by 335
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
    Garima_PowerPlatform Profile Picture
    170 on 17 Dec 2024 at 00:36:04
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard

Featured topics

Loading started