Hi I have a IF function in my fill option, in a gallery. The title field will change color if all checkboxes in an other gallery is true.
This is working fine, but if there are many rows (above 25) with the checkbox = true, it dosn't work anymore.
If(IsBlank(LookUp(SAP_Import;Unik=ThisItem.Title && CheckBox));White; If(IsBlank(LookUp(SAP_Import;Unik=ThisItem.Title && !CheckBox));Green;Yellow))
Is there a work around to solve this ?
Regards
Tony
Solved! Go to Solution.
I cannot see your data, so can only follow the values you posted. Put two labels in the gallery with this
IsBlank(
LookUp(
SAP_Import;
Unik=ThisItem.Title
).Unik
)
and this
IsBlank(
LookUp(
SAP_Import;
!Checkbox
).Unik
)
These will return true or false.
If you do not get the result you are expecting, have a look at your logic.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @Thansson ,
I am not sure of your exact requirements here, but try this
If(
IsBlank(
LookUp(
SAP_Import;
Unik=ThisItem.Title
)
);
White;
If(
CheckBox.Value;
Green;
Yellow
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
HI @WarrenBelz
Thank you for your answer. This is not working for me.
I need to lookup selected "Unik" in a SharePoint list, if all checkboxes for this selected "Unik" are true, then the field should turn green. If only one checkbox is true, then it should be Yellow, if no checkboxes are selected, then it should stay white.
What do you mean by "all checkboxes" - you have only mentioned one field Unik
Hi
The title field in a gallery is supposed to be colored, depending on a SharePoint list.
The SharePoint list is connected to an other gallery, with checkboxes.
Title is the same as unik in the sharpointlist, so if all checkboxes belonging to "unik" (or selected "Title"), the color of the title field should change color.
UNIK Column1 Column2 Checkbox
111 True
111 True
111 False
222 True
222
This command is working, but nut if the there is have more than 25 rows, belonging to the unik value
If(IsBlank(LookUp(SAP_Import;Unik=ThisItem.Title && CheckBox));White; If(IsBlank(LookUp(SAP_Import;Unik=ThisItem.Title && !CheckBox));Green;Yellow))
Hi @Thansson ,
Probably something like this
If(
IsBlank(
LookUp(
SAP_Import;
Unik=ThisItem.Title
).Unik
);
White;
If(
IsBlank(
LookUp(
SAP_Import;
!Checkbox
).Unik
);
Green;
Yellow
)
)
Bear in mind that this is not Delegable, so how many rows are in your table?
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @WarrenBelz Thank you
Number of rows changes everyday from 2000 to 3000 rows, can I use another way?
How come it is not Delegable ?
Here is a list of non delegable:
First, FirstN, Last, LastN
Choices
Concat
Collect, ClearCollect
CountIf, RemoveIf, UpdateIf
GroupBy, Ungroup
Hi @Thansson ,
The non-Delegable list is actually bigger than that (see my blog on this subject), but you could try this
With(
{
wUnik:
LookUp(
SAP_Import;
Unik=ThisItem.Title
).Unik;
wCheck:
LookUp(
SAP_Import;
!Checkbox
).Unik
};
If(
IsBlank(wUnik);
White;
IsBlank(wCheck);
Green;
Yellow
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @WarrenBelz
All the fields becomes yellow, but the warning sign disappear.
So it must be in the right direction.
I cannot see your data, so can only follow the values you posted. Put two labels in the gallery with this
IsBlank(
LookUp(
SAP_Import;
Unik=ThisItem.Title
).Unik
)
and this
IsBlank(
LookUp(
SAP_Import;
!Checkbox
).Unik
)
These will return true or false.
If you do not get the result you are expecting, have a look at your logic.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
User | Count |
---|---|
256 | |
103 | |
92 | |
47 | |
37 |