I think your requirement to update multiple selected lookup column with Filter based on Lookup fieldscannot be achieved. But I think it could be achieved with single selection.
May I know where did you get the information of these 2 Lookup columns? Is it from the same SharePoint list or another one? If it is from another list, please also add this list to the data source list in the app. In my example, the source list name isList_Testand the list to update isList.
1. Add a dropdown1 control, set its Items property to: List_Test Value to: Name
2. Add another dropdown2 control, set Items property to:
For patch usage withlookup field, we need to patch a recordrather than a value. And this is the part that multiple selected lookup won't work.The Record must match the Schema defined under your lookup field.
Thanks for this @v-monli-msft. The data is coming from the SharePoint lists. For example, List B has a Look up from List A. List C has a lookup from List B. I am trying to customise List C form where there are two look up columns (from List B).
I think what you are suggesting is that I should use 2 custom dropdown controls and get the data directly from List A and B and then apply the filter?
Also, am I correct that for Pitching I would need a custom Save button?