Announcements
Hello all,
I have a rectangle that should change color when, for example, an item in my sharepoint list has "Number =1" and "Title=Hello". If both criteria exist, the rectangle should turn green, if not red.
Can someone help me with this?
If(Lookup(Table_Name, ItemID).Number = 1 And Lookup(Table_Name, ItemID).Title = "Hello", Green, Red)
Not sure exactly how your set up is looking but try this and see if you can get it to work. Should be live just make sure you call the Refresh(Table_Name) after or you wont have the updated value.
I don't know what I'm doing wrong here.
so the 2nd parameter of the Lookup function needs to return an object or a list item. to make this happen you need to say Lookup(testCalender, number = something).Number. Right now as it is written there is no object being returned to take the .Number value of. Generally I will use the ID of the item to find it using the lookup function.
Hope this helps!
I don't know, it doesn't quite work the way I want it to.Maybe I'll explain the meaning behind it, that might make it easier.It should be later a table plan, in which you can see when which room is occupied. In my list I have then a date and the table number. So I ask if there is no element with e.g. the table number 21 and the date 10/21/2022, if there is not, the rectangle should be green, if there is, it should be red.
Here is my solution:
If(LookUp(Bookings; deskID = "2").deskID = "2" And LookUp(Bookings; date = _dateSelected).date = _dateSelected; Green; Red)
The errors were because the syntax is different in Germany. Thanks a lot!
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 296 Most Valuable Professional
11manish 224
Valantis 181
