The app I'm developing in PowerApps consists of a series of forms distributed across different screens which users can edit and access later to add new information. The information that the user has entered is stored in an SQL Server table.
I'd really want users to get redirected automatically where they left the form. In other words, once the user selects an element to edit (which corresponds to a row in SQL Server) I want them to get to the screen where the first empty input field (based on what was stored to the database) is.
My initial approach was to build a relationship between fields and screens so that I know what screen to navigate to once I know that field X is the first that was left empty. However, I'm having a hard time getting that field/column name.
Any thoughts on this? How would you implement this? Is there a more efficient approach?
I've tried your approach with a few screens and it works. However, since I have a ton of screens and fields I was hoping for something less tedious like looping through the database table columns and getting the first blank column and redirecting the user to the screen based on a dictionary-like data structure.
I'll give it a couple days in case anyone else responds and then I'll accept it as a solution.