Are you sure you are using the correct names for your SharePoint list and created by field? The data source name in the filter should be green if it is a valid data source which leads me to believe the name isn't correct.
Sorry Jeff - you are correct, I had the SP List as 'Engagement List' instead of the correct 'Engagement Form'. That being said, it still isn't working. When Toggle1 is checked, all items disappear from the list. Please refer to the attached screenshot. That being said, I do like how you are setting a global variable in order to prevent delegation warnings.
Where did you set the gvCurrentUser variable? If you set it in the OnStart of the app and you haven't closed and reopened the app you will need to click on the ellipse next to the App control and select Run OnStart.
That was it, thanks Jeff - I didn't realize that was necessary.
I apologize in advance, but if you think you could nest your gallery items formula with the default one, it would help me understand the nesting syntax a bit better?
If(Toggle1.Value, Filter('Engagement Form', 'Created By'.DisplayName = gvCurrentUserName), 'Engagement Form')
SortByColumns(Filter('Engagement Form', StartsWith(Activity_Name, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
If I understand you correctly, you can just do this....
Filter('Engagement Form', 'Created By'.DisplayName = gvCurrentUserName),
If(SortDescending1, Descending, Ascending)
It seems that you dropped the below portion of the formula. It appears to be needed for the search box to work.
This is working! Thank you so much 🙂
I'm probably going with Jeff's solution however, as I like that the use of the global variable prevents delegation warnings. Still looking to nest that with the default Gallery.Items formula (while maintaing search functionality), if anybody knows?
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!