You’re offline. This is a read only version of the page.
395
I have a gallery with the datasouce linked to sharepoint list and currently have the gallery filtered (see below, i have this under Items) I am trying to add search bar that a user can type into to filter by customer. So i have added a text input (SrchBox), then trying to add;
Search(KBXoffline, SrchBox.Text,"Customer") in the items off the gallery. Because i already have the syntax below, it wont allow me to to ; and paste it in. Do i need to combine these two syntax?
FirstN(Sort(If(User().Email in varAdminEmail, KBXoffline, Filter(KBXoffline, 'Created By'.Email = User().Email)), Created, Descending), 50)
Any assistance would be much appreciated,
KR's,
Matt383
Hi @Matt383 ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
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 @Matt383 ,
Typing gremlins again - should be colon : in the With() statement - corrected in original post
OK @Matt383 ,
This should find up to 500 without Delegation Warnings (and you can increase this to 2,000 in Advanced Settings)
Share
Report
All responses (
Answers (
With(
{wKBX:KBXOffline},
FirstN(
Sort(
Filter(
wKBX,
If(
User().Email in varAdminEmail,
true,
'Created By'.Email = User().Email
) &&
SrchBox.Text in Customer
),
Created,
Descending
),
50
)
)
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 @Matt383 ,
I meant the number of records in your list (not fields)
Hi @Matt383 ,
Please see updated post - dangers of free-typing. NOTE; the in Filter (and Search) are not Delegable, neither is User().Email (although there is a workaround for this). How many records are in your list ?
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.
