Power Platform Community Forum Thread Details

Hello everyone,

I have two sharepoint lists, sharepoint list 1 looks like this:

ID: Id of sp list

Titel: Text

Anzahl Lager: Number

Übrige Testgeräte 1: Number

Foto: Picture

And then I have a 2nd Sharepoint list 2:

RefID: Number

Titel: Text

Ausleiher Name: Text

Emailadresse: Text

Datum: Date

Anzahl ausgeliehener Testgeräte: Number

This is a 1:n relationship: SP list 1 contains all test devices with the corresponding number (1); SP list 2 tracks colleagues and their borrowed test equipment(s)

You can enter the number of devices and borrow them on a registration page. When this happens, I want the "Übrige Testgeräte 1" column to be decremented by the number entered in the corresponding text input

Example: Übrige Testgeräte 1: 20; text input 1: 5; Übrige Testgeräte 1 is reduced to 15.

How do I get that?

Thank you in advance!

Categories:

Building Power Apps