So I have a Patch button that will patch several fields to a Sharepoint list. In the sharepoint list the person column is not required but the patch function won't work at all if the combobox people picker is left empty. The formula to patch this column is the one bellow (which works fine providing someone was selected):
;
Agente:{ //name of the column in sharepoint list
Claims: Concatenate(
"i:0#.f|membership|";
Agente.Selected.Mail // Person email
);
Department: "";
DisplayName: Agente.Selected.DisplayName; // Agente here is the combobox name
Email: Agente.Selected.Mail; // Person email
JobTitle: "";
Picture: ""
};
PS: don't mind the semicolons, for some reason it's the way to work in brazilian portuguese Powerapps.
Solved! Go to Solution.
@lsmael
Well, you're going to have to submit a blank. The formula you provided will not.
Your formula should be:
...
Agente:
If(IsBlank(Agente.Selected.Mail); Blank();
{
Claims: "i:0#.f|membership|" & Lower(Agente.Selected.Mail);
Department: "";
DisplayName: Agente.Selected.DisplayName;
Email: Agente.Selected.Mail;
JobTitle: "";
Picture: ""
}
);
...
Turn on the Formula Level Error management feature in your app. Otherwise, you will not be able to write a blank back to the satasource.
I hope this is helpful for you.
I have tried this and so far no good.
@lsmael
Well, you're going to have to submit a blank. The formula you provided will not.
Your formula should be:
...
Agente:
If(IsBlank(Agente.Selected.Mail); Blank();
{
Claims: "i:0#.f|membership|" & Lower(Agente.Selected.Mail);
Department: "";
DisplayName: Agente.Selected.DisplayName;
Email: Agente.Selected.Mail;
JobTitle: "";
Picture: ""
}
);
...
It worked like a charm. Thank you very much!
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |