Power Platform Community Forum Thread Details

I don't know why i have such a tough time sometimes combining functions but i need some help please. 🙂

I need to do the following (which currently works):

GroupBy(
Filter(
'List of Departments',"1.1" in DepartmentID,
!IsBlank('Area (Area1)')),
"Area1","grAreaDetail")

But where the 1.1 is, i need it to show only the options that STARTS WITH 1.1. right now its showing things that contain 1.1 and that is not what i want.

For some reason my sharepoint column is showing as 'Area (Area1)' , i changed the name but it never updated even after refreshing and waiting a day, oh well.

So i want to filter the 'List of Departments' list by the DepartmentID that STARTS WITH 1.1.

I don't want it to show any blank rows.

Then it groups by the Area1, grAreaDetail.

Categories:

Building Power Apps