
Announcements
Hello guys I have an app that is about giving feedback from the users.
The questions are in required format in sharepoint
but I want to create a row that contains their credentials and blank or null questions. So when they access the form it will have blanks for them to answer.
Is there anyway I can add another choice on the drop down just to comply to the required field on NEW mode which then filters out on users when on EDIT mode.
I will create another choice from the dropdown of Sharepoint naming it "Not Choice"
then will filter or exclude it on edit view.
Hi @nagestiada ,
Could you please share more details about your scenario? Would you like to submit a blank value as a template choice in SP list?
If you would like to add a blank value into the dropdown selections, you could create a collection in OnVisible of the screen:
ClearCollect(coloptions,Choices(List.ChoicesColumn).Value);
Collect(coloptions,{Value:Blank()})Then use this collection as the Items of the choices dropdown control.
However, this would only work in PowerApps, not in SP list. In SP list, required column need a non-blank value.
On your end, I would recommend you to add a choices like "/" for the default choice in New Mode. In NewForm, set DefaultSelectedItems of the Combo box to:
LookUp(Choices(List.ChoicesColumn),Value = "/")
Then in EditForm, you could remove this choice by creating collection:
ClearCollect(coloptions,Choices(List2.Test123).Value);
Remove(coloptions,{Value:"/"})
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.