trigger a flow when an item is created in two list

[Gizachew]

Hello

I have a flow which trigger when an item is created in a list. I have two list which simultaneously created an item. my point is I want to get the second list items when I run the flow. I trigger flow using one list then I try to get the items from another list using get items. however, get items give me all records in that list. I use filter with created date but it's not working. here is a screen shot of my flow.

I want to get newly created items from "visitor info" list. is there any way I could do this? 

[RobElliott]

@Gizachew you need to tie the tables together with a column value. It is probably not a good idea to use created because you cannot guarantee that the items in the 2 lists will be created at exactly the same time to the second. So, create the item in the first list then after this, in the same flow, create the item in the second list. In that second list have a column for OriginalID and populate it with the ID of the item in the first list. In  Add a Compose action to get the ID of the ID from the first list item. Then in the get items you can have a filter query of OriginalID eq '' and inside the single apostrophes select the outputs of the compose action.

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

[v-mengmli-msft]

Hi @Gizachew ,

Is "newly records" the most recent record created, or multiple records created within a certain time period?

Best regards,

Rimmon

[Gizachew]

@RobElliott thanks for response. yes, I created first list then second goes. the issue is I can get the first list items because flow is triggered when that list is created. however, I can't get the second list items using get items filter query.

[Gizachew]

newly created items

[v-mengmli-msft]

Hi @Gizachew ,

If you mean the newest item, please try this.

Best regards,

Rimmon

[Gizachew]

@v-mengmli-msft   here is what I did. but get item cannot reference get items.

[v-mengmli-msft]

Hi @Gizachew ,

Could you please explain more? If there is an error, please attach the screenshot.

Best regards,

Rimmon

[Gizachew]

Hi @v-mengmli-msft  

I have main list which record some data and another list which records another data. I trigger a flow when list1 created but both lists create same time. I can get items from list1 easily because flow starts with that list. I want to get list2 data only created on that moment.

[v-mengmli-msft]

Hi @Gizachew , 

Try to clear Filter query and test again.

[Gizachew]

Hi @v-mengmli-msft 

Filter can't be blank.