cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

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

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 II
Super User II

Hi @ppei,

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

Super User
Super User

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

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

SharePoint. Thanks.

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (8,209)