Announcements
No record found.
Is it possible to replicate the 'is one of' filters in the dynamics excel addin?
For example I want to filter this d365 filter in excel:
Voucher is one of
CRNJRN*
INVJRN*
see if this helps
Thanks Rahul, I see where you are coming from and I think it would work if I only wanted Contains JRN
I should have stated I would also want to see, PURCRN*, PURINV*, GLCIJ*
Hi SteveUK,
I found a verified thread said that excel addin allows standard syntax, but it does not work for me, you can try it: community.dynamics.com/.../using-filter-in-the-excel-add-in
If it does not work, only use excel's own filters.
The Excel add-in is not supporting 'is one of' filtering. Based on the number of records, you can retrieve the data using multiple times the entity or retrieve per keyword.
Can you tell what you want to achieve here? What is the business scenario? If it is about reporting, why aren't you using e.g. BYOD with PowerBI?
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 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 663
André Arnaud de Cal... 439 Super User 2026 Season 1
Syed Haris Shah 337 Super User 2026 Season 1
