Answered

Visibilty of a datacard based on another sharepoint list.

Like (0) Share

Report

Posted on 7 Mar 2024 05:57:07 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:

General Questions

All responses (4)

Answers (2)

ace991 9 on 08 Mar 2024 at 19:48:04

Like (0)

Report

Re: Visibilty of a datacard based on another sharepoint list.

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!
ace991 9 on 08 Mar 2024 at 03:24:35

Like (0)

Report

Re: Visibilty of a datacard based on another sharepoint list.

thanks both worked fine for me.
Verified answer

v-jefferni on 07 Mar 2024 at 10:06:04

Like (0)

Report
Re: Visibilty of a datacard based on another sharepoint list.

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,
Verified answer

kelseytran 292 on 07 Mar 2024 at 06:41:00

Like (1)

Report
Re: Visibilty of a datacard based on a sharepoint list.

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!