In a powerapp form (connected to a sp list), I have a text field, changed it to allow values so that makes it a drop down.
Now i have a document library (prequal contracts) added as a source in which _PrequalLookupValue is a text field, so for items property, I set below and it does show me drop down values.
Only thing I now want to do is, filter based on a managed metadata field called '_RequiredReporting' eq 'Yes' in Prequal Contracts Library. Can someone please help me with the expression for the same, thanks in advance.
thanks a lot @dariobois Please see below.
PrequalLogReporting is a sharepoint list.
as shown below, prequal is a text field and in the powerapp form, I have changed this field to 'Allowed values' so it turns into a drop down.
Now below is a screenshot from prequal contracts document library.
So the 'Prequal' text field on the app, needs to pull values from 'PrequalLookupValue' (from prequal contracts) field where 'RequiredReporting' (prequal contracts) equals 'Yes'.
Below is what I did for Prequal field on the app, I think this will make it a bit clear.
In that case, just unlocked it, then edit the "items" property of the 'Precual' new Dropdown type Control with this formula:
Filter( Choices(PrequalLogReporting._PrequalLookupValue), Id in Filter( 'Precual Contracts', _RequiredReporting.Label = "Yes" ).ID )
Can you rewrite the formula, word to word, and corroborate if naming, commas, upper and lower cases are ok?
You can also try to put the "Filter" segment on a aux gallery or table control to verify if the data is Ok.
Verify that you have a Lookup column in the PrequalLogReporting sharepoint list, named _PrequalLookupValue like this
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.