Answered

Urgent assistance needed: How to apply lookup to every item in a list

(0) Share

Report

Posted on by nviddivo

Good Afternoon,

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 am using the following formula for the look up and I am successfully returning data for single row at a time if I edit that row.

LookUp('REMS and Mandatory HUB Shipping Tracker', PatientSrcNumber = Value(DataCardValue7.Text),ShipDate)

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

w1sd0m 151 on at

Like (0)

Report
Copy link

Link copied!

use filter not lookup

Was this reply helpful? Yes No
nviddivo 19 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Wisdom. How would you do this? Any more details?

Was this reply helpful? Yes No
w1sd0m 151 on at

Like (1)

Report
Copy link

Link copied!
you already have it in the code, try swapping out LookUp with Filter and just add the property selector argument at the end.

Filter('REMS and Mandatory HUB Shipping Tracker', PatientSrcNumber = Value(DataCardValue7.Text).ShipDate

Was this reply helpful? Yes No
nviddivo 19 on at

Like (0)

Report
Copy link

Link copied!

I won't pretend I am an expert here. I tried as you have it written and it didn't populate the entire list with ship dates. Perhaps I am missing the property selector argument but I don't even know what that is.

Was this reply helpful? Yes No
Verified answer

v-chenzhi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @nviddivo ,

Do you have two lists in SharePoint and want to Update the ShipDate of the SubList to the ShipDate of the MainList according to PatientSrcNumber?
I assume you have this in SubList and MainList and display MainList in DataTable

Set the Items property of DateTable to following

ForAll( MainList, { PatientSrcNumberMAIN: PatientSrcNumberMAIN, ShipDateMAIN: LookUp( SubList, PatientSrcNumberCHILD = PatientSrcNumberMAIN, ShipDateChild OtherColumnName:OtherColumnName // Note that if you have other column needed to be assigned value to, please replace it with the real column name ) } )

If ShipDateChild in Sublist is updated, the corresponding ShipDateMAIN in Mainlsit will also be updated

Best Regards,
Zhi Chen

Was this reply helpful? Yes No