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?
Solved! Go to Solution.
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.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.