Hi All,
I using a form in PowerApps where I have a column called Action on RPC(choice field with values - Accepted, Rejected, On hold, Duplicate). When the form is saved for the first time this column should save a value as "New" by default and this "New" will not be there in the Choices. So I have added a Text input box and gave values as "New" and when form saved for first time it will add New to the SharePoint list. In another screen when navigating from gallery to the respective item, Acton on RPC shows the Parent. Default as New since it is saved in the SharePoint list(attached screenshot). Is there any other way when this column has value as New saved in SharePoint list it should not reflect in app and if other values are there it must show the Parent. Default value. Any help or suggestion on this?
Thanks in advance.
If I give in the above way and go to the form edit mode the column Action on RPC will be having the Parent. Default value as "New" since it is saved in the SharePoint. but in my scenario since I'm manually saving the value as New and when I navigate to the Form Edit mode the column Action on RPC should not reflect this value New and the combo box should be blank and the user must be able to select the value from the list in Combo box.
You can leave out the textbox and instead have the Update property of the card as
If(ThisItem.'Action on RPC'.Value=Blank(),{Value:"New"},ComboboxRPC.Selected)
That way when the form is saved for the first time, Parent.Default will be blank and instead "New" will be saved. It will remain New until the user changes the RPC combobox.
WarrenBelz
146,605
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional