cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

Syntax help Dates..

I'm looking for some syntax help just can't seem to get it right so thought I'd ask the experts who generally resolve my issues very quickly ! 😀

 

I have sharepoint list with a Date Picker Field called ExpiryDate.

 

I have a gallery which pulls from that data source and it has a Date Picker Field called  CalcExpiry (it calculates based on other factors)

 

I want to add another field in my gallery that looks at ExpiryDate if there is something there it uses that.. if not it uses CalcExpiry

 

I'm not sure A) whether to use a label or a DP field  for this new field? and B)  having tried both I just can't get the right syntax !!  Here's what I currently have which seemed logical !  but it's errors all over the place 😀

 

 

If(IsBlank(ThisItem.ExpiryDate,DPCalcExpiry.SelectedDate,ThisItem.ExpiryDate))

 

Have tried switching things around but can't hit on the right one !

 

Any help gratefully received

 

TIA

1 ACCEPTED SOLUTION

Accepted Solutions
Post Patron
Post Patron

Fixed !!  

 

I had closing bracket in the wrong place

If(IsBlank(ThisItem.ExpiryDate),CalcExpiry.SelectedDate,ThisItem.ExpiryDate)

🙄 

View solution in original post

1 REPLY 1
Post Patron
Post Patron

Fixed !!  

 

I had closing bracket in the wrong place

If(IsBlank(ThisItem.ExpiryDate),CalcExpiry.SelectedDate,ThisItem.ExpiryDate)

🙄 

View solution in original post

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 (6,389)