Answered

Patch blank / empty value from combobox people picker to a Sharepoint List

(0) Share

Report

Posted on by CU27081801-0

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.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@lsmael

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.
CU27081801-0 17 on at

Like
a
(0)

Report
Copy link

Link copied!

I have tried this and so far no good.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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: "" } ); ...
CU27081801-0 17 on at

Like
a
(1)

Report
Copy link

Link copied!

It worked like a charm. Thank you very much!