I'm using two lists on my SharePoint:
Team Members, where I have the Name column and Status Column that can be Active or Inactive.
Document Management, where I have the Document Name and Owner (lookup from Team Members column)
I have a PowerApps form and I'm trying to filter the Choice field to show only Active Team Memebrs, I have the follwing formula on my Owner field on Items property:
Value in Filter('Team Members', Status.Value = "Active").Name
But I'm not sure why when I write this down it seems PowerApps does not recognize 'Team Members' as a list and I cannot complete this filter (when I start typing 'Team... it does not appear as I type 'Document Management'):
I'm sorry if this is a obvious thing that I'm missing. I started using PowerApps recently.
Thanks in advance for your time and support!
Solved! Go to Solution.
Ok.... I'm really embarrassed right now.....
I thought that using a LookUp wouldn't require to add the list on data source. I've added and it worked perfectly!
I'm so sorry for taking your time with such a newbie mistake. 😟
Thanks a lot for all the support provided! Have a nice week!
Oh no worries at all!! This is all part of the learning cycle and there are many here to patiently work through things.
Keep up the pace and certainly feel free to bounce questions on this forum when you have them.
I am having a similar issue. I am working with two lists. 1. Audit Items, 2. Functional Groups. The 'Functional Groups' list has two fields: 'Functional Group' and 'Area'. The Audit Items list has two look up fields, you guessed it... 'Functional Group' and 'Area'.
In my form I need to do two things with these columns - First I need to make the Choices in the Functional Group distinct - there are multiple Areas for each functional group. And I also then need to filter the Area filed by the functional group so that when the user selected a Functional group, the system presents only the filtered list in the Area dropdown.
1. I cannot figure out how to do a distinct on the Functional Group column. Nothing seems to work.
2. My attempt at filtering the Area field doesn't work: Filter(Choices([@'Admin Role Gap Analysis'].Area), Value in Filter('Functional Groups & Areas','Functional Group'=DataCardValue5.Selected.Value).Area). this formula doesn't show any warnings to errors, but it simply doesn't produce the expect results.
BTW... I attempted to create these fields as non-lookup choices, which worked on the form, the results would not save in SharePoint. So I am thinking if these are lookup fields that may not happen.
I am trying to do the same filtering as the example, but I get all the items of the source data. In my case, I have two SharePoint Lists:
I want to select only active projects when introducing a new timesheet. I am trying:
Filter(Choices([@'Timesheets'].Project); Value in Filter('Projects'; 'Project closed' = false).Title)
The funny thing is that I got it a few days ago by using the following formula, but it stopped working one day...
Filter('Projects'; 'Project closed' = false)
Check out the News & Announcements to learn more.
Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.