Unanswered

Power Apps - Using data from one sharepoint list to populate another results list

(0) Share

Report

Posted on by brokencornets

Hi all

I'm making my first attempt to build an app with PowerApps and I'm loving it so far but I guess I've got to the inevitable tricky part and I'm not sure how to make it do what I want it to.

So we have a number of assets that we're doing some condition-based monitoring on, they have a bunch of sensors (between 10-15 usually) attached to them and every so often we want to take manual readings from the sensors and record them in the app.

I have some SharePoint lists set up which I'm connecting to:

Asset Data - columns include unique Asset Number, Location, Monitor Type, Install Date, etc.

Sensor Points - which has a unique SensorPointID, Asset Number and Sensor Description

Test Dates - which has a unique TestDateID, Asset Number, Date and Person

Test Results - which has SensorPointID, TestDateID and two result columns, RMS and Frequency

So after my work so far I'm able to filter/add/amend assets and view previous test results, but what I now want to do is be able to upload new results to the Test Results list.

What I want to do is click a 'New Results' button for an asset and that give me a form with all Sensor Points for that asset (taken from Sensor Points list) and two black boxes for each Sensor Point to record results, and then I want to click a 'Confirm' button and those values be uploaded to Test Results.

I feel like I have the structure set up right in SharePoint but don't understand how I can take records from one list and use that to upload to another list, and I'm not getting too far with Google so thought I'd turn to the experts. Any pointers would be hugely appreciated, thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@brokencornets So the Structure of "Asset Data" and "Sensor Points" looks like this.

Asset Data
Asset Number Location Monitor Type Install Date
ASS0001 USA XYZ 20.02.2022
ASS0002 EUROPE ABC 01.01.2018

Sensor Points:
SensorPointID Asset Number Sensor Description
0001 ASS0001 FOO
0002 ASS0001 BAR
0003 ASS0001 Power
0004 ASS0002 Ranger
0005 ASS0002 Lorem Ipsum
... ... ...

The Result Table shoud look like this
SensorPointID TestDateID RMS Frequency
0001 1 400 40
0002 1 20 300
0003 1 90 80
0001 2 50 60
0002 2 80 90
... ... ... ...

Does this looks like what you are trying to achieve?

Was this reply helpful? Yes No
brokencornets 42 on at

Like (0)

Report

@PowerRangerthanks for the response, and yes, that's basically it for the structure.

I'm already able to get a result table - I've got some dummy data and I'm able to return a table of results for a specific asset on a speecific date. But what I don't understand is how to create a page to enter new results to be uploaded into the results table.

So I want to pick an asset and then click 'add new results' and I'm imagining showing a form populated with all the data points associated with that asset, but with two blank columns for RMS and Freq. Then submitting that form would add new results to the Test Results list.

I hope this makes sense!

Was this reply helpful? Yes No