Power Platform Community Forum Thread Details

Hello dear community,

I'm starting to customize an Edit form linked to a sharepoint List.

I have a problem with a choice field.

So, first, my Sharepoint List contains lot of people pickers columns and an ApprovalStatus column which is a Choice field (values: New, Aprroved, Under Review, Rejected)

I customized the Edit form with Power Apps because I need to set the value in ApprovalStatus column to 'New' when an item in the Sharepoint list is modified (a Power automate approval flow runs when a 'New' status is detected)

For that, I built my custom form

Please find here the formula for 'ApprovalStatus':

Items: Choices([@LocationsList].ApprovalStatus)

DefaultSelectedItems: If(SharePointForm1.Mode=FormMode.Edit,{Value:"New"} ,ThisItem.ApprovalStatus)

It seems working because, for test, I created a Text field (at the bottom Left of the form) with the formula: DataCardValue14.Selected.Value which show me 'New' as value

When I click on my form button 'Save' (OnSelect: SubmitForm(SharePointForm1)) or on the Sharepoint Button 'Save' unfortunately, I obtain an empty value in Sharepoint List.

When I check the Version history in the sharepointList, I can see my change date and time but without any change included concerning the ApprovalStatus