How to look up SharePoint Record

[sjcitpro]

How do I look up a SharePoint list records ID using the record title.  Also record may not exist.  I have a PowerApps button that uses a Flow to create a SharePoint record but if that record already exists then I only want to update it.

[v-bacao-msft]

Hi @sjcitpro ,

Do you want to filter items through Filter Query?

And if there are no similar items, create a new item; if there is, update item.

Please refer to the following method to configure Flow.

• Use length() function to determine if Get items has any output.

Image reference:

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

Please take a try.

Best Regards,

[sjcitpro · Accepted solution]

 Thank you so much for 

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

I just could not figure out how to test for empty value.