Flow get items filter query person. - When an item is created or modified ...

Flow get items filter query person. - When an item is created or modified - Get Items (Filter: SyncedID eq Body/IDx) Oct 30, 2021 · If you ever wondered how to filter through a SharePoint Person or Group column in Power Automate Get Items action, you’re in the right place. Apr 8, 2021 · The query inside the Get Items action is an OData query. Any and all help would be greatly appreciated Nov 2, 2023 · Learn how to get items from sharepoint list in Power Automate using power automate get items flow action and also checked power automate get items filter query examples. Unfortunately, you can't use complex object columns like People/Group columns in an OData query. You'll need to get a broader set of records and then use the Filter Array to find records for a specific person. my flow is triggered when an item is added to the second list and it needs to lookup the id from the first list Jun 19, 2025 · When building Power Automate flows with SharePoint, you often need to get list items or files that meet specific conditions – for example, “all completed tasks created after Jan 1”. Though they are different actions, the capabilities for both the actions are same. To filter through that column you need to choose the value you want to filter on since the Person column is a lookup column and contains more than one Feb 5, 2023 · I have been trying to filter a Get Items action with both a person column and a text column I have a Get items action configured as such; I also tried filtering by person column and the variable; But I keep getting the same error; I can't figure out what I'm doing wrong here, any ideas. the other list also have an employee column that is a person or group type. I'm not able to enter a static email address in, as the email address changes per user submitting on their time sheet. kxhofw zvjgg pif exry nrlj ionv aup bwwnwe rfkkl rmmvx