Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Distinct and Filter command not working with Excel Online Business

Like (1) ShareShare
ReportReport
Posted on 13 Aug 2024 10:33:04 by 5
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:
  • Suggested answer
    Michael E. Gernaey Profile Picture
    42,036 Super User 2025 Season 1 on 14 Aug 2024 at 02:25:03
    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 Profile Picture
    243 Super User 2025 Season 1 on 13 Aug 2024 at 10:57:49
    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

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 89 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard
Loading started