Power Platform Community Forum Thread Details

I am trying to create a Power Automate a flow to send an email when a Purchase Order has been added.

There are two sharepoint lists

Sharepoint List A is the PO Header List where the Id is used as a Purchase Order Number

Sharepoint List B is the PO Lines List where the Title is used to hold the Purchase Order Number and the Line number is incremental as Purchase Order Number may have several line

So the flow is triggered when an item is created in Sharepoint List A where the Purchase Order Total is greater than zero

Get item is used to fetch the PO Header details

Compose is used to convert the ID to a string using string(outputs('Get_item')?['ID'])

Question is how can I fetch the PO Lines - I have tried using get items and in the filter, I have tried using

'Title' eq string(outputs('Get_item')?['ID']) but get error when running

The expression 'Title' eq string(outputs('Get_item')?['ID']) is not valid. Creating query failed.
clientRequestId:
serviceRequestId:

I want to compare the PO Hearder ID with PO Lines Title

I have out in the Get Items in the Filter tab

The expression "'Title' eq string(outputs('Get_item')?['ID'])" is not valid. Creating query failed.
clientRequestId: 9fe4a80c-3d08-4b7a-a03c-005457d686a3
serviceRequestId: 9fe4a80c-3d08-4b7a-a03c-005457d686a3

Categories:

Building flows