You’re offline. This is a read only version of the page.
I have an application that currently collects data, then uses Power Automate to turn that data into a report. I noticed that there were a handful of blanks in my report, and found that the blanks come from filtered data in SharePoint.
There is a SharePoint list connected to the application with about 155 items currently. One of the columns in this list is 'Job Titles'. When I go to the 'Job Titles' column and filter it by 'Manager', the list is blank and nothing comes up. I then searched through the list and found that 'Manager' does in fact exist in the list, but when I filter the list for it, nothing shows up. I believe this is the source of my Power Automate issue. This list originally came from an Excel Document, and it is indexed.
Does anyone know why this happens in my SharePoint list, and how can I solve it?
Hi @CSilva,
Could you please tell me that how you pass your data from Power Apps to Power Automate?
To filter SP list based on 'Job Titles' column in your Power Apps, you just need to use a Gallery and set Items:
Share
Report
All responses (
Answers (
Filter(list, 'Job Titles'="Manager")If you filter in your flow,and you configure the filter query as you mentioned, unfortunately, the Filter Query in List rows present in a table action does not support the use of fields with spaces in the field name as filter parameters.
This is a known limitation.
As a workaround, use the Filter array instead:
551
