OK.....Let me preface this by saying that I'm very green when it comes to power apps. I've recently built my first app but I'm having trouble with 2 items. My data source is an excel file on my onedrive. It has 6 columns "assetnum", "description", "location", "status", status message, and "status date". I do not use the app to add new records I only use it to update existing records. The only columns that the user will be able to edit are the "status" and the ""Status Message" column. The "status" is a dropdown with only 2 items available "Operating" or "Down". The user will change the status using the dropdown, then type a message in the multiline text field "status message" then the user will click on the "submit form" button (on select - submitform(editform1)
Request #1
1). When the user submits the form I want the "status date" to automatically update with the current date and time.
Request #2
2.) If the user changes the status to "Operating" and submits the form, I want the app to automatically update the status message to "Good"
Is this possible? Believe it or not but I've scoured these boards for hours trying to find a solution to no avail. I know that I should probably not be using an excel file as my database but this file is linked to another query and that's why I chose to use it. Any insight will be much appreciated, thanks for your time!
