Power Platform Community Forum Thread Details

Hello guys,

i have an app where users can create a request that is recorded to SharePoint list. It has draft or publishes state and allows the user also to delete the request if required...

to create a new request the button goes:

ResetForm(Form1); NewForm(Form1);
Refresh('sip');
Patch('sip', Defaults('sip'),
{
 Status:{Value:"Draft"},
 Title: Company.Selected.Title
});

//refresh and select last item
Set(varID, First(Sort('sip', ID, SortOrder.Descending)));

//this will ensure the button to "add product" is visible and form is editable
EditForm(Form1);

to save the draft:

Patch('sip', LookUp('sip', ID = ThisItem.ID),
{
 Status:{Value:"Draft"},
 Title: Company.Selected.Title
},
 Form1.Updates
);

to submit (also triggers a flow)

Refresh('sip');
Patch('sip', LookUp('sip', ID = ThisItem.ID),
{
 Status:{Value:"In Progress"},
 Title: Company.Selected.Title
},
 Form1.Updates);
//trigger flow
'sip-1Newcase'.Run(ThisItem.ID);

//change view and navigate to success screen
ViewForm(Form1); Navigate(success)

The trouble i have, is that sometimes, one user will overwrite other users request... i can see that even in version history of SPO that "Jack" created some draft but "Jil" changed it... the gallery that shows their drafts has items as following (filtered by upn in a dedicated column...)

Sort(Filter('sip',CreatedbyUPN=createdbyupn.Text And galleryfilterstatus.Selected.Value=Status.Value),Modified,SortOrder.Descending)

Community site session details

Accidental rewriting existing items in SPO List

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates