IF function works in one field but not in another similar field

[ppei]

I have a very strange case. Hopeful someone can give me some hints how to resolve it. I have the same IF function that works in one field, but not in anther field and not in another form with same fields.  My IF function is for a date picker field, I want to set it DefaultDate property to be today if someone has filled out a People picker field. This is my function.

If(!IsBlank(SupervisorSignature.Update),Today(),Parent.Default)

It works in one form. But if I change to another field for an employee signature field or for the same field in another form, it doesn't work. 

Anybody has any ideas?

Thanks in advance.

Pei Pei

[Drrickryp]

Hi @ppei,

Are you using SharePoint, CDS or some other connector for your PeoplePicker field?

[R3dKap]

Hi @ppei,

I find it strange that you use the ".Update" property of the people picker...

If your people picker field is, by example, a User field type, then you could try this:

If(!IsBlank(SupervisorSignature.Selected.Email),Today(),Parent.Default)

Be sure to go up to the ".Email" part because if you stop at the ".Selected" part if might still be not blank because the object behind exists even though it doesn't contain any data...

Keep us posted if this helps you solve your problem...

Emmanuel

[ppei · Accepted solution]

Emmanuel,

Thank you for your reply. Unfortunately, the suggestion doesn't work for me. I actually got the Update property from a Rule in PowerApps. I actually found out a strange way to make it work. I just need to change SupervisorSignature's card name and refer it in the formula. The workable one is the one that has different card name from the field name suggested by PowerApps. I cannot explain why but it works.

Thanks,

Pei

[ppei]

SharePoint. Thanks.