Answered

Visibilty of a datacard based on another sharepoint list.

(0) Share

Report

Posted on by ace991

Hello , My question is: I want to set the visibility of a form's datacard which is from a sharepoint list,based on a value set in another sharepoint list.The value is set as a Yes/No field.How can I do that?

Thankyou!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

kelseytran 292 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @ace991 ,

Assuming you've already connected to both your SharePoint lists in your app, you can use a Lookup function to determine the visibility of the card.
If( Lookup( ), true, false )
A simple example would be like this - in the lookup, put the list your Yes/No column is in and then the second argument would be if its Yes/No; the if statement will see whether if statement is true, then the visibility will be true, if not, it won't be visible.
------------------------------------------------------------------------------------------------------------------------------
If I answered your question, please accept my post as a solution and if you liked my response, please give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ace991 ,

Since it's a Y/N column, they're Boolean values by default when fetching from the list. You can use the field value directly in Visible of the Data Card:

LookUp(SPList2, ColumnName = ThisItem.ValueColumn).YNColumnName

Best regards,

Was this reply helpful? Yes No
ace991 9 on at

Like (0)

Report
Copy link

Link copied!

thanks both worked fine for me.

Was this reply helpful? Yes No
ace991 9 on at

Like (0)

Report
Copy link

Link copied!

So my code looks like this but it is incorrect with errors showing up,'Site Name' is a choice column what code should i write so that the RTCIS value is looked or found based on the site name,i want to make it dynamic:
If(
LookUp(Notes,'Site Name'= "ABC" && RTCIS=true,RTCIS),
true,
false
)
Thanks in advance!

Was this reply helpful? Yes No