compare a record value form another sharepoint list and use that in IF function

(0) Share

Report

Posted on by IMathur

291

Hi Folks,

Using the below formula, in gallery item to fill color:

If(Filter(SPList1, ProjectName) = Filter(SPList2, ProjectName) && LookUp(SPList2, ThisItem.DataDeleted = "false", true), RGBA(255, 0, 0, 1), RGBA(141, 198, 63, 1))

Gallery is made using SPList1, and sequenced using ProjectName column.

I am not sure, what is going wrong here, please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@IMathur

You cannot compare records in PowerApps. You will need to compare to a column within each record.

However, your formula is actually comparing a table to a table because you are using the Filter function for this, which returns a table.

Is there a specific column you need to compare within each record, or perhaps you are just looking to see if a record exists?

Was this reply helpful? Yes No
IMathur 291 on at

Like (0)

Report

Hi @RandyHayes

Thanks for the reply,

Let me explain the scenario:
List 1:
Project Name | Project start Date | Project End Date | Project Status

List 2:
Project Name | Data Deleted

Gallery uses List 1:
Project 1 , Project 1 status, now i want the red/green dots based on data deleted column from List 2

Please let me know if this helps to understand the issue

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@IMathur

Is Project Name the unique keys between the two lists, or is there some other identity that connects them?

Was this reply helpful? Yes No
Neha 30 on at

Like (1)

Report

Hi @IMathur ,

You can write this formula in the fill property of your circle icon -
If(LookUp(SPList2, ProjectName =ThisItem.ProjectName).DataDeleted = false, red, green)
Here LookUp will help to retrieve the first matching record from list 2 and .DataDeleted will fetch the value of DataDeleted column. ThisItem will get the current Row's record.
You can also store project id column in list 2, it will make sure the data is unique and help you compare IDs in your lookup instead of project name.

Thanks,
Neha

Was this reply helpful? Yes No