power automate filter query returns non existing result

Like (0) Share

Report

Posted on 6 Sep 2021 10:54:04 by Sifu

832

Hello All,

I have a document library that I want to filter for a yes/no column... this worked for quite some time, now after holiday it returns results that are not there... from the file that i can download/look in i get the IDs

and filter for them... only one file exists the other I can filter for but there's nothing in, any idea why is that?

All responses (9)

Answers (0)

Sifu 832 on 06 Sep 2021 at 13:29:45

Like (0)

Report

Re: power automate filter query returns non existing result

1) Is the connection in your account or is it a shared/service account? ServiceAccount that has however full access
2) Are they files in subfolders? yes
3) Are they folders/subfolders? yes

but I solved it by replacing the yes/no column with a text column where the default value is NO ...it seems to work fine
eric-cheng 5,171 on 06 Sep 2021 at 13:04:07

Like (0)

Report

Re: power automate filter query returns non existing result

Hi @Sifu ,

So it is returning you items that you cannot see in the library?

Assuming you have selected the correct SPO site and library name:

1) Is the connection in your account or is it a shared/service account?
2) Are they files in subfolders?
3) Are they folders/subfolders?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Sifu 832 on 06 Sep 2021 at 12:41:36

Like (0)

Report

Re: power automate filter query returns non existing result

no matter how, it still returns me items that are not existing, i suspect there is a problem with the SPO list
eric-cheng 5,171 on 06 Sep 2021 at 12:35:32

Like (0)

Report

Re: power automate filter query returns non existing result

Hi @Sifu ,

Sorry, please try the below filters:

To get no items

To get yes items

Test Library with 3 files

Please note that if you created your column AFTER you uploaded the files, you won't return those files as they have null/empty values rather than False. You will need to either manually update the properties to No and save OR add another condition for null.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
eric-cheng 5,171 on 06 Sep 2021 at 12:26:56

Like (0)

Report

Re: power automate filter query returns non existing result

.
Sifu 832 on 06 Sep 2021 at 12:00:44

Like (0)

Report

Re: power automate filter query returns non existing result

it still pulls the not existing files, ..., also it seems to be same for "no", "false" or "0"
eric-cheng 5,171 on 06 Sep 2021 at 11:49:48

Like (0)

Report

Re: power automate filter query returns non existing result

Hi @Sifu ,

Whilst the SP column is a Yes/No field, you will need to use true / false in your odata filter.

Please refer to my screenshot earlier.

To return all Yes Items

To return all No Items

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Sifu 832 on 06 Sep 2021 at 11:24:31

Like (0)

Report

Re: power automate filter query returns non existing result

the column seems fine:
the flow looks like this:
eric-cheng 5,171 on 06 Sep 2021 at 11:14:08

Like (0)

Report

Re: power automate filter query returns non existing result

Hi @Sifu ,

How many items are in your list? Has the SP column changed? Can you share the filter you are using?

To return columns with yes, it should be:

Can you use the output in a Compose action to get the length() and see how many items are returned

length(outputs('Get_items')?['body/value'])

or alternatively us it within a loop?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn