How to Filter Active Absence Types in a Canvas App Dropdown Using Power Fx?
Table of Contents
Question
You develop a canvas app to manage time off and vacation requests. The app uses Microsoft Dataverse as the data source. The Request table in the data model has a lookup column that references a table named AbsenceType.
You add a drop-down list control to the app. You need to ensure that users are only permitted to select active absence types to select from.
What should you do?
Select only one answer.
A. Add the following PowerFx expression to the onSelect property of the drop-down list: Filter(‘Absence Types’, ‘Absence Types (Views)’.’Active Absence Types’)
B. Add the following PowerFx expression to the onSelect property of the drop-down list: ‘Absence Types’
C. Add the following PowerFx expression to the Items property of the drop-down list: Filter(‘Absence Types’, ‘Absence Types (Views)’.’Active Absence Types’)
D. Add the following PowerFx expression to the Items property of the drop-down list: ‘Absence Types’
Answer
C. Add the following PowerFx expression to the Items property of the drop-down list: Filter(‘Absence Types’, ‘Absence Types (Views)’.’Active Absence Types’)
Explanation
This item tests the candidate’s knowledge of using drop-downs with possible values from a Microsoft Dataverse lookup.
Adding the PowerFx expression to the Items property of the drop-down list with the code segment that includes ‘Active Absence Types’ would filter the list of Absence Types to those included in the “Active Absence Types” view. Adding the PowerFx expressions to the onSelect property would not apply to the Items property. Adding the PowerFx expression with the code segment that includes only ‘Absence Types’ would show all Absence Type rows no matter whether they are active or not.
Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.