Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Filter Lookup column in a Business Process Flow data step (Model Driven App)

(0) ShareShare
ReportReport
Posted on by 65

Hi all,

 

I am in the process of creating my first Business Process Flow. One of the data steps in my first stage is referencing a lookup column to the Account entity.


In my main form for the flow I have applied a filter to that lookup to only show accounts that have a 'CustomerTypeCode' of 'Client'. 

 

I was expecting (hoping?) that the data step in the Business Process Flow would inherit the same filter as the form but that is not the case. In the flow all accounts are listed with no filtering.

If anyone knows how to apply filtering to the data step lookup column that would be most helpful.

Thanks,

Categories:
  • Thenerdy Profile Picture
    Thenerdy 58 on at
    Re: Filter Lookup column in a Business Process Flow data step (Model Driven App)

    Thanks for that - a shame that the default isn't to use the form that you have and create the same filtering that you have already created on the main form you're using the BPF from? It means you're managing filtering from more than one option.

  • Re: Filter Lookup column in a Business Process Flow data step (Model Driven App)

    this will walk you through the steps needed to filter a lookup field in a BPF.. 

    How to Filter Lookups in a Dynamics 365 Business Process Flow | Magnetism Solutions | NZ (Auckland, Wellington, Christchurch and Dunedin)

  • Thenerdy Profile Picture
    Thenerdy 58 on at
    Re: Filter Lookup column in a Business Process Flow data step (Model Driven App)

    So how do you set up a filter on a BPF? I can do that within the form but the BPF doesn't by default follow suite. Presumably you have to do this in javascript?

  • Shashank Bhide Profile Picture
    Shashank Bhide 932 on at
    Re: Filter Lookup column in a Business Process Flow data step (Model Driven App)

    I don't think BPF will inherit filters from the form. You can perhaps create a view on the account entity with required filters and use that as the default view on both the form as well as the BPF lookup view? 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics