Security Filter Formula

chiukim · 07-10-2022 05:43 PM

Hello. I trying to filter this huge table for this app to work. and i just want to show the latest transaction/row per SKU.
Can anybody else suggest how to properly filter this table? Thanks

Aurelien

Hi @chiukim

A security filter cannot apply a formula to a table from which criteria comes from.

I suggest you update the last transaction information, with a data action directly to the SKU table, everytime a new row is added to your transaction table.

Then, use a security filter with criteria coming from this table.

Something like:

IN([_THISROW],SkuTable[lastTransactionID])

chiukim

what is [lasttransactionID]?

Aurelien

This is a suggestion.

I mean: everytime you add a new transaction, I suggest you set this transaction ID in a new column that you need to create in your SKU table.

This can be done with a data action that you attach to a form saving.

So, the transaction ID from the "current new row" would be inserted in the "LastTransactionID" column of your SKU table, at the matching row of the SKU involved.