1

I have a flow that creates items from list A into list B.

Say in list A, my column is "Repeatable" with a "Check" like so:

enter image description here

I am trying to only include checks in my list B

enter image description here

How do I filter for these in my flow?

I am trying to use this Center eq 1463 and (AutomationType eq 'Management Reporting' or AutomationType eq 'Testing') and Repeatable eq 'Yes'. but it does not work.

Any help would be appreciated.

3
  • When do you want to run a flow (and create new item in list B)? Only when Center eq 1463 and (AutomationType eq 'Management Reporting' or AutomationType eq 'Testing') and Repeatable eq 'Yes'?? If yes, you can add triggee conditions using these values to "when an item is created" Trigger on list A Dec 24, 2022 at 0:30
  • Sorry this is for a manual trigger. It seems like it is not taking my repeatable eq Yes into account.
    – Jonnyboi
    Dec 24, 2022 at 16:25
  • Repeatable is a yes/no column I should add.
    – Jonnyboi
    Dec 24, 2022 at 19:51

1 Answer 1

1
+50

I think this is related to this answer: SharePoint Online Rest API - Filter by boolean (yes/no)

To filter by Yes/No which on the backend recognized as Boolean, you should use

  • 0 for false/no (Repeatable eq 0),
  • 1 for true/yes (Repeatable eq 1),
  • and null for empty (Repeatable eq null).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.