Answered

Formulas in Collect inside a ForAll loop

(0) Share

Report

Posted on by Herbata

So I'm trying to nest a formula inside a Collect function to automatically convert one currency to another and I've run into a little bit of a problem. Here's my current ForAll loop:

ForAll(Filter(colPodsumowaniePracownika,kategoria = "Zaliczka") As varZal,
 Collect(colPodsumowanieZaliczki,
 {
 ID: varZal.ID,
 kategoria: varZal.kategoria,
 data_wyplaty: varZal.data_wyplaty,
 kurs: varZal.kurs,
 tabela_kursow: varZal.tabela_kursow,
 waluta_krajowa: varZal.waluta_krajowa,
 waluta_obca: varZal.waluta_obca
 }
 )
)

But I've wanted to do something like this:

ForAll(Filter(colPodsumowaniePracownika,kategoria = "Zaliczka") As varZal,
 Collect(colPodsumowanieZaliczki,
 {
 ID: varZal.ID,
 kategoria: varZal.kategoria,
 data_wyplaty: varZal.data_wyplaty,
 kurs: varZal.kurs,
 tabela_kursow: varZal.tabela_kursow,
 waluta_krajowa: varZal.waluta_krajowa,
 waluta_obca: varZal.waluta_krajowa * varZal.kurs
 }
 )
)

So that "waluta_obca" would automatically be calculated depending on "waluta_krajowa" and "kurs".
Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Herbata,

Try the following code and see if it helps.

ForAll(Filter(colPodsumowaniePracownika,kategoria = "Zaliczka") As varZal, Collect(colPodsumowanieZaliczki, { ID: varZal.ID, kategoria: varZal.kategoria, data_wyplaty: varZal.data_wyplaty, kurs: varZal.kurs, tabela_kursow: varZal.tabela_kursow, waluta_krajowa: varZal.waluta_krajowa, waluta_obca: Value(varZal.waluta_krajowa) * Value(varZal.kurs) } ) )

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Herbata 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Works great, thank you so much 🙂

Was this reply helpful? Yes No