Announcements
I'm trying to get data from a specific column in a SharePoint list.SP list name: PedidosI want to get the data from the column name CANTIDADSet(_NumRev, First(Filter(Pedidos, NumMAT=_NumPed).CANTIDAD));The problem is I get a record from that line instead just the number (in this example: 256)Could you point me what I'm doing wrong?
What type of field is CANTIDAD? You could also try using a lookup.
Set(_NumRev, Lookup(Pedidos, NumMAT=_NumPed).CANTIDAD);
Thanks for reply! works great!It's a type Number column.I wonder if with LookUp function I'm going to have trouble when SP List has more than 2000 records
You shouldn't have an issue because NumMAT=_NumPed looks like a delegable condition. An easy test would be to decrease your Data Row Limit to 1 and give it a try.
Hi @Jeff_Thorpe and @FedericoC ,I have similar requirement where I am having 2 SP Lists:Assume 1st SP list: (Personal Details: Name, Age, Address) is displayed on Details screenand the second list is Contact information: (Phone number, Email)Lets say I have to display Phone number for a particular record in the 1st SP list in that case how to do it?.
Also the above solution that you have given using Set & Lookup it is used where exactly because I tried it on a text label but did not get it and NumMAT=_NumPed are these 2 columns in different SP list which are common and that is being compared?.Regards,Sidhant.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
