I have 2 dropdown field in a Data view i.e. Location and Department. I don't want to show all department name in Department field instead, when I will select a Location based on selected location whatever department are there in this location I want to show only those department name in Department dropdown field.
use the constrained by property
Add an OnChange microflow to the Location dropdown. In this OnChange Microflow refresh the Caller-of-the-Page, this should trigger the load of the Department dropdown again.
Populate the Department dropdown by microflow and make it restrict the values based on the association that was just set between the Caller-of-the-Page entity and the Location entity.