web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Obtain specific values...

Power Apps

Answered

Obtain specific values from a SharePoint List depending of one condition

(0) Share

Report

Report

Posted on by OmarTorresM

8

Good morning everyone,

I am developing an App in Power Apps with a database in SharePoint, and I need to obtain the value of one of the columns of one list depending on the value assigned in a variable called "_proyecto" but when I try to make it the formula gives me an empty array "[]". The code that I am using is the following:
"Set(_numeroEquipos;JSON(Filter(Proyectos;'Nombre del Proyecto'=_proyecto).'Numero de equipos'))".
Can you give a hand detecting the mistake?. I don't know if I have to use another method, or maybe I am missing something in the code.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@OmarTorresM

Are you intentionally needing the JSON text of the record, or just the record?

If you just need to Numero de equipos from a matching record, then this formula:

Set(_numeroEquipos; LookUp(Proyectos;'Nombre del Proyecto'=_proyecto; 'Numero de equipos') )

If you need a table of all records matching, then use this formula:

Set(_numeroEquipos; Filter(Proyectos;'Nombre del Proyecto'=_proyecto.)'Numero de equipos') )

I hope this is helpful for you.

Join the conversation