Hey everyone, I've been doing a lot of research on this but can't get it right. I have a Sharepoint List and a flow that will email managers to update specific items. I don't want managers to edit any other item, or any other column other than what's allowed by the form.
What I've figured out so far:
- I can use power automate to send a customized url to the exact item that needs to be updated
- I can use power apps to edit the form so only certain fields can be modified
The problems:
- Either on save or on cancel, the page redirects to the entire List and gives the option to edit. I've been unable to overcome this with the Launch function.
- I'm assuming I would have to share the list for the managers to update, so even if I figured out #1, they would still probably be able to manipulate it beyond what the business process allows
I'd also be perfectly happy using a SQL Server table as a source rather than a Sharepoint List, but so far I haven't been able to figure out how to send a form to edit an individual item in the table.
Just to take a step back and make the overall business objective clear, there is a semi-automated process where an admin creates new records. Those records need to be distributed to various managers to fill in blanks. Most of these managers are not tech savvy-- they just need a simple form to fill out. I want to give them a simple form for the exact one record they need to update, without the ability to modify any other columns.
