Answered

How to change value by 1 for multiple rows - SharePoint List

(0) Share

Report

Posted on by JustinM5

I have an app where users can list multiple peripherals and it will update the quantity of each in a SharePoint List. Power Apps doesn't like how I'm identifying the field and says, "Invalid argument type. Expecting one of the following: Number, Text, Boolean."

The code is:

ForAll(TempPeriphList, Patch(PeriphData, LookUp(PeriphData, Title = TempPeriphList[@Asset]), {Qty:PeriphData.Qty -1, Comment:Now() & " One device deployed."}));

TempPeriphList is a collection. PeriphData is a SharePoint List. The part that Power Apps doesn't like is "PeriphData.Qty - 1", specifically just the ".Qty" part of it. The data is being saved as a number in SharePoint. The rest of the code works, it's updating the comment for each peripheral listed, just won't update the quantity.

Any help is greatly appreciated!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@JustinM5

You are specifying an entire table when you use PeriphData.Qty it will return a table with a single column called Qty.

Plus the results of your ForAll are not being used properly.

Please consider changing your Formula to the following:

Patch(PeriphData, ForAll(TempPeriphList As _item, With({_record: LookUp(PeriphData, Title=_item.Asset)}, {ID: _record.ID Qty: _record.Qty - 1, Comment: Text(Now()) & " One device deployed." } ) ) )

I hope this is helpful for you.
JustinM5 30 on at

Like
a
(1)

Report
Copy link

Link copied!

That worked! Thank you very much!

I'm going have to look at it for a while to fully understand it (I'm a little confused by the need for ID: _record.ID), but I'm happy it's working!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@JustinM5

The reason for the ID is that the Patch function needs it to match it to an existing record in order to update it.

If it is not supplied, Patch will consider it a new record and thus create new ones.