Distinct and Filter command not working with Excel Online Business

Like (1) Share

Report

Posted on 13 Aug 2024 10:33:04 by debusam

Hi,

When I am using sharepoint list or Import from Excel as datasource I am not getting any error with this line, however if I use Excel Online Business, I am getting syntax error.

Distinct(Filter(EME_DATA,'Support Ticket Number' = SF_ID_1.Text),Text('Product Name'))

This command is used in the Items property of a dropdown list and it is supposed to display the product name when Support Ticket Number is entered in another Text Input fields called SF_ID.

Are there any limitation in Excel Online business ? How can I overcome them in my case ?

Thanks

Debo

Categories:

General Questions

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 42,617 Super User 2025 Season 1 on 14 Aug 2024 at 02:25:03

Like (0)

Report

Distinct and Filter command not working with Excel Online Business

Hi

Why do you have a Text() wrapper around the Column you want to be distinct?

I've never seen anyone do that.... but yeah.. i can see why it works, just... never seen it. I am surprised it doesn't generate a delegation warning of its own.

Can you please share the error.

Its a little.. weird to say i get an error, but you dont share the error, its common place.. just not sure why.
scalca 243 Super User 2025 Season 1 on 13 Aug 2024 at 10:57:49

Like (1)

Report

Distinct and Filter command not working with Excel Online Business

try to convert the Support Ticket Number into Text type like Text('Support Ticket Number') it should give you a delegation warning.
therefore I would consider moving into a SharePoint list since there are some limitations connected to excel online