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

Date Format not working in Lookup

I have a date "StartDate" in a list called Group. Its a date only type standard format in the SP list.

On the Custom form I have the format in the date picker "ddd mmm yyyy"

 

In the lookup I cannot get it to work using 

 

LookUp(Group,ID=ThisItem.GroupID,DateValue(Text(StartDate,"[$-en-US]ddd mmm yyyy")))

 

Am I doing things right? 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User III
Super User III

Text(LookUp(Group,ID=ThisItem.GroupID,StartDate),"dd-mmm-yy)

Is this the formula inside a gallery

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

6 REPLIES 6
eka24
Super User III
Super User III

Text(LookUp(Group,ID=ThisItem.GroupID,StartDate),"dd-mmm-yy)

Is this the formula inside a gallery

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

WarrenBelz
Super User III
Super User III

Hi @StuCundy ,

You need to refer to something matching the date - if equaling (exactly) your Date Picker for example, it would be as below

LookUp(
   Group,
   ID=ThisItem.GroupID &&
   DateDiff(
      YourDatePicker.SelectedDate,
      StartDate,
      Days
   )=0
)

If greater than/less than a bit easier. What are you wanting to match it to?

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks @eka24 OMG perfect!

Hi @WarrenBelz 

I can see that using this from within the gallery would work.  I am actually formatting an email and want to include data from a number of data sources so the formula @eka24 provided was perfect.  Thank you as well.

If it worked then mark as a solution

@StuCundy ,

Yes @eka24 was a bit better mind reader in this instance (and Your DatePicker reference lead me down the track I took).

Just bear in mind for the future, the more specific information you provide on exactly what you are trying to do, the more accurate the response you will get.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (67,508)