cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ppei
Level 8

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

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
ppei
Level 8

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

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

View solution in original post

4 REPLIES 4
Super User
Super User

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

Hi @ppei,

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

R3dKap
Level 10

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

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
Level 8

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

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

View solution in original post

ppei
Level 8

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

SharePoint. Thanks.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,857)