PLEASE HELP : Date Lookup in PowerApp SharePoint Form

[nviddivo]

Hi All,

I am trying to do a lookup function in a SharePoint power app form to look up a date in another list based on a unique ID that is present both lists. I successfully connected the two lists in the same app and I am not having any issues selecting the fields. I am consistently receiving an error about the items being incompatible for comparison. I confirmed the columns are exactly the same Date format. 

The formula I am trying to use is as follows:

LookUp('REMS and Mandatory HUB Shipping Tracker', 'Patient SRC Number' = DataCardValue7, 'Ship Date')

Error:

Hoping someeone has some ideas.

Thanks!

Nick 

[WarrenBelz · Accepted solution]

Hi @nviddivo ,

Assuming PatientID is Text and DataCardValue7 is a Text box, you need this

LookUp(
   'REMS and Mandatory HUB Shipping Tracker', 
   'Patient SRC Number' = DataCardValue7.Text
).'Ship Date'

If Patient ID is numeric (which I suspect), you need this

LookUp(
   'REMS and Mandatory HUB Shipping Tracker', 
   'Patient SRC Number' = Value(DataCardValue7.Text)
).'Ship Date'

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.

Visit my blog Practical Power Apps

[nviddivo]

Thank you so much, Warren! That worked. I am having to go into every item to get the formula to update. Do you have any tips on how to make the whole list do the lookup? 

Thanks!

Nick

[WarrenBelz · Accepted solution]

Hi @nviddivo ,

If you do this

UpdateContext(
   {
      varTracker:
      LookUp(
         'REMS and Mandatory HUB Shipping Tracker', 
         'Patient SRC Number' = Value(DataCardValue7.Text)
      )
   }
)

then each reference field is available (example)

varTracker.'Ship Date'

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.

Visit my blog Practical Power Apps

[nviddivo]

hi Warren, I am using this function and it doesn't seem to be working. This is how I entered it. Did I mess it up?

UpdateContext( {varTracker:LookUp('REMS and Mandatory HUB Shipping Tracker', 'Patient SRC Number' = Value(DataCardValue7.Text), Vartracker.'Ship Date'))})

[WarrenBelz]

Hi @nviddivo ,

You just need this (you are setting the whole record as the Variable)

UpdateContext(
   {
      varTracker:
      LookUp(
         'REMS and Mandatory HUB Shipping Tracker', 
         'Patient SRC Number' = Value(DataCardValue7.Text)
      )
   }
)

Your ship date is then

varTracker.'Ship Date'

and all other fields in the record are 

varTracker.TheirFieldName

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.

Visit my blog Practical Power Apps

[nviddivo]

I feel completely lost. I'm sorry :(. Where do I type in the varTracker.'Ship Date'? and where do I enter VarTracker.TheirFieldname. Here is an image of what I have...

[nviddivo]

@WarrenBelz This is some additional information about what I am trying to do. Perhaps it will make it more clear

I am working to connect two lists. In one list we will have main list that will be include qualifying information for about 5,000 customers. Our staff will use this as a work list to track their transition from a competitor. There are drop downs, status's and notes that will regularly be updated as we work through these clients. I also have a list that will include some additional information, including the date we sent their first shipment. I am doing a power app form with lookup to pull in the shipping date through a unique ID (Patient SRC Number) that is available in both lists. 

I need to be able to update shipping data for all items in the list at least a couple times per day so our staff can see if a shipment has occurred. Does anyone have any tricks for how I can force all items in the list to complete the lookup and return the ship date either real time or on a predetermined schedule? 

Thanks!

Nick

[WarrenBelz]

Hi @nviddivo ,

Nowhere in there - you asked the question Do you have any tips on how to make the whole list do the lookup? 

And I provided the code to set varTracker as the whole record. So instead of varTracker being just the ship date, it is now the whole record where 

 'Patient SRC Number' = Value(DataCardValue7.Text)

I assume you set this elsewhere. 

The DefaultDate is simply varTracker.'Ship Date'. Can you please take a small step back to understand all of this as it will assist you greatly going forward.