Answered

Refer to a Filter result in a formula

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am currently trying to make an 'Inventory App' for my company.
I use a SP List. I implemented an option to book a certain Item, but now I am looking for a way to kind of put the Item back into storage.
When booking an item I let the App create a new Entry with the same name and the desired amount, which gets substracted from the original one.
The 'back into storage' function so far looks like this:

Patch(
Inventar;
First(
Filter(
Inventar;
Title = InventarGalerie.Selected.Title && ID < InventarGalerie.Selected.ID
)
);
{Anzahl: + InventarGalerie.Selected.Anzahl}
)

For reference: Anzahl = Amount, Inventar = SP List, InventarGalerie = Galery that displays the list

The first part seems to work fine, but I have no idea how i can refer to the filter results in my formula.
I think i need something like {Anzahl: FilterResult + InventarGalerie.Selected.Anzahl} .

Any help will be apreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Unless I misunderstand you, you'd like to refer to the record that you've just updated with Patch.

If that's the case, it's worth noting that the return value from Patch contains the updated record.

For example if you use the following formula, you can use LastUpdatedRecord to refer to the record that you updated.

Set(LastUpdatedRecord;
Patch(Inventar; First( Filter( Inventar; Title = InventarGalerie.Selected.Title && ID < InventarGalerie.Selected.ID ) ); {Anzahl: + InventarGalerie.Selected.Anzahl} )
)

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to reference the Filtered result from the Filter formula within your Patch function?

If you want to reference the Filtered result from the Filter formula within your Patch function, I have made a test on my side, please consider modify your formula as below:

Patch( Inventar; First( Filter( Inventar; Title = InventarGalerie.Selected.Title && ID < InventarGalerie.Selected.ID ) ); { /* <-- Modify your formula below */
Anzahl: First(Filter(Inventar; Title = InventarGalerie.Selected.Title && ID < InventarGalerie.Selected.ID)).Anzahl + InventarGalerie.Selected.Anzahl
} )

Please take a try with above solution, check if the issue is solved.

More details about Filter function in PowerApps, please check the following aeticle:

Filter function

Best regards,

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

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msftThank you for the quick response, the solution you provided works!

Was this reply helpful? Yes No