I wonder if someone can help. I have a list hosted on SharePoint online to track statuses of projects. One of the columns show the current status, so "New", "In Progress", "Under Review" and so on. The list is managed through PowerApps. At present, this field "Status" is a single line of text.
My intention is that when an user access a record via PowerApps, they will need to update some fields. When they click on the "submit" button, the Status field on SharePoint will then be updated from "New" to "Under Review". When they navigate to other sections of the app, the Status field for this record will also be changed automatically depend on which option they selected.
I have tried all the functions that I can think of, but I can't seem to find one that would automatically set a specific status back to the SharePoint record that they are working on.
Would someone be able to help?
Thanks.
