Initially I started trying this with a list with "Choices" as a column type in list with State and Configuration being the field names but now even with creating the file on the fly the filter fails. Why is this filter not limiting the records it returns? I have tried ( =, lower() to check case, and others) I really need to match the exact string in the column data. All examples that I usually see is working with drop down or some sort of object that might reference ThisItem.Value. The goal here is to get a list of existing lists and have another list(meetingConfig) be able to turn on or off the list of choice so I don't use it later when combining data so that the user does not have to delete it. This will also be applied to planner lookups later.
// Setup Collection
ClearCollect(MeetingConfig,
{ Title: "test1", Configuration: "Agenda", State: "Open" },
{ Title: "test2", Configuration: "Meeting", State: "Open" });
//Make sure Collection is empty
Clear(AgendaList);
ClearCollect(AgendaList, Filter( MeetingConfig, "agenda" in Lower(MeetingConfig.Configuration ) ) );
Solved! Go to Solution.
Clear(AgendaList);
ForAll(MeetingConfig As ThisConfig, If("agenda " in Lower(ThisConfig.Configuration), Collect(AgendaList, ThisConfig)))
Clear(AgendaList);
ForAll(MeetingConfig As ThisConfig, If("agenda " in Lower(ThisConfig.Configuration), Collect(AgendaList, ThisConfig)))
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
188 | |
56 | |
50 | |
37 | |
36 |
User | Count |
---|---|
270 | |
91 | |
83 | |
76 | |
75 |