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
Please can you help me?
379
