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

[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!

[PowerRanger]

@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?

[brokencornets]

@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!