Power Platform Community Forum Thread Details

Hello guys,

I'm quite new to model-driven apps and I need simple (or at least I thought it is simple ) thing: multi select lookup with automatic prefill and prefilter. How it should work:

1. In form user selects company code(lookup column)

2. Below control (probably subgrid) is automatically prefilled with users (approvers) from table Users (systemusers), where column company code (choice) is equal to selected entity.

My problem is, when I use subgrid, record needs to be saved first before I fill it with approvers. But this subgird is at the top of my form and many mandatory fields follows therefore saving after entity is selected throws error. So my question is what is the best approach?

I managed to build solution with JS when I used Approver as lookup column. But this only gives me 1 approver.

I would like to avoid PCF if possible but if you know this is the best solution just tell me.

Thank you for any hints