You’re offline. This is a read only version of the page.
Announcements
34
I am working on a model driven app and trying to find a way to refere to Previous and Next record when any record is opened.
I cannot filter a column by using value from other column.
I've created an ID Column (Auto-number) and tried to filter it using js but that too seems not working.
Hi @AnuragT,
Funny enough this used to be possible out-of-the-box and was removed! You can do this now with the new command bar and Power FX experience. If you're using an incremental auto-number then have two buttons (previous and next) then on select of the button, lookup the record and navigate to it. Here's an example of the PowerFX command:
Share
Report
All responses (
Answers (
Navigate(Lookup('Table Name', 'Autonumber' = Self.Selected.Item.Autonumber + 1))Note: the current user might not have access to the next/previous reocrd and the next/previous right might not exist, so you might need to manage these scenarios.
More info: https://learn.microsoft.com/power-apps/maker/model-driven-apps/commanding-use-powerfx
Feel free to submit the idea at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas
Hope this helps!
