Unanswered

why this on change function does not work ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to be able to edit the budget of a workpackage and if the sum of the budget for this specific workpackage is larger than the avaiable budget in the project table then the speficic budget for the workpackage should be set to the previous budget!

I have two tables Workpackage and Project

If(Sum(Filter(colA; Projektname = ThisItem.Projektname) ; Budget) + Value(ThisItem.Budget) - Value(LookUp(colA; ID = ThisItem.ID).Budget) <= Value(LookUp(Projektstammdaten; Projektname = ThisItem.Projektname).'Plan / Budget Faktura'); Select(Parent); ThisItem.Budget = LookUp(colA; ID = ThisItem.ID).Budget)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

WarrenBelz 155,940 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I have parsed this for ease of reference

If( Sum( Filter( colA; Projektname = ThisItem.Projektname ); Budget ) + Value(ThisItem.Budget) - Value( LookUp( colA; ID = ThisItem.ID ).Budget ) <= Value( LookUp( Projektstammdaten; Projektname = ThisItem.Projektname ).'Plan / Budget Faktura' ); Select(Parent); ThisItem.Budget = LookUp( colA; ID = ThisItem.ID ).Budget )

The fundamental issue if you are using this OnChange is that is is expecting an action - the first possibility is one

Select(Parent)

but this is not (an action) - it is simply a statement which really belongs in a filter (it does not set anything)

ThisItem.Budget = LookUp( colA; ID = ThisItem.ID ).Budget

I am not sure exactly what you are trying to do

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

if Select(Parent) is executed then it goes to the gallery and update the collection !

Was this reply helpful? Yes No
WarrenBelz 155,940 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

Yes, but this is not doing anything - it is simply a statement which you will get an error on as it is not an action.

ThisItem.Budget = LookUp( colA; ID = ThisItem.ID ).Budget

You need to specify the action required in the alternate circumstance (when you do not go to the gallery)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

can you give me the whole code ? pls

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
i did but still does not work !
If( Sum( Filter( colA; Projektname = ThisItem.Projektname ); Budget ) + Value(ThisItem.Budget) - Value( LookUp( colA; ID = ThisItem.ID ).Budget ) <= Value( LookUp( Projektstammdaten; Projektname = ThisItem.Projektname ).'Plan / Budget Faktura' ); Select(Parent); true )

Was this reply helpful? Yes No
WarrenBelz 155,940 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

Do you get any error on the posted code. If not, I need to understand what you two options are trying to do. One is Select(Parent) - where does that go and the other is reverting to previous budget. Bear in mind that I have no idea how or when you are writing data.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

i did something different now but still thx!

Was this reply helpful? Yes No