Switching to another screen when data exist in a field
So my App is conected to a PowerBI Dashboard and there is a table which the app references and adds data to it. I have a column in the table that has a list of IDs that the app references and for each of the ID selected, there is a form on the app that allows users to add data for the selected ID. What I expect the app to do is to switch to another page if other fields for the selected ID contains data.
Or is it possible for 2 forms to switch on a condition on the same screen so when the user selects the ID and it doesn't contain data in the other fields, a form appears to allow the user to insert new data and when there exist data, a different form appears to allow user make changes to the data in those fields.
Assuming your app is a canvas app, this should be possible
In the OnSelect of a button within your gallery of records use an if statement to check for the field containing data, and put a navigate() pointing to screen X (containing your new form) in the true action (containing your new form, and screen Y (containing your edit form) in the false action
Happy to build out a quick Proof of Concept over the weekend if you need further explanation