Adding values during item update

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I am currently doing this to add to an existing cumulative value in a SharePoint list:

UpdateIf(DataSource, Title = varRecord.Title,
 {
 DevHours: DevHours + Value(TextInputDevelopmentHours.Text)
 }
)

I need to make some changes to my overall formula and would like to use Patch instead to avoid any delegation issues down the line. It doesn't seem that Patch supports this type of adding values together.

Is UpdateIf the only function that allows this? I would rather avoid a lookup to get the current value if at all possible.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Al_10 1,691 Super User 2024 Season 1 on at

Like (0)

Report

@JR-BejeweledOne

what is the datatype for DevHours column? what is the datatype of DevHours parameter that you use to update DevHours column?

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like (0)

Report

@JR-BejeweledOne

if DevHours parameter just updates the DevHours column value of the item:

ForAll( RenameColumns(Filter(DataSource, Title = varRecord.Title), "ID", "tempID") As ThisItem,
Patch(DataSource, LookUp(DataSource, ID = ThisItem.tempID),
{
DevHours : ThisItem.DevHours + Value(TextInputDevelopmentHours.Text)
}
)
)

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
I have 2 use cases for this. One uses varRecord.ID (when editing an item) and what you see below is the 2nd use case. Not sure where the error is, but I *think* it's before the patch as it's not recognizing the data source name at that point.

ForAll( RenameColumns( Filter(DemoProjectCumulativeHours, MasterID = ComboBoxProject.Selected.ID && Title = DevName), "MasterID", "tempMID") As ThisItem, Patch(DemoProjectCumulutiveHours, LookUp(DemoProjectCumulutiveHours, MasterID = ThisItem.tempMID), { DevHours: ThisItem.DevHours + Value(TextInputDevelopmentHours.Text) } ) )

Was this reply helpful? Yes No
Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like (0)

Report
@JR-BejeweledOne

there is a typo

DemoProjectCumulutiveHours

DemoProjectCumulativeHours

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Thank you! I am waiting on new glasses and when my eyes get really tired, I miss that sort of thing.............

Was this reply helpful? Yes No