Check if an item exists in a SharePoint list

[GhassSD]

Dears,

I need to create a flow that search in a SharePoint list for a special value.

if this value exist a series of action should take place. 

i did my flow that get the SharePoint list, and i set the condition as below but with no success.

Issue is with the expression used.

Any Idea.

Thank you

[Hardesh15]

@GhassSD  What is your condition here?

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[GhassSD]

Dear @Hardesh15 ,

I got the dynamic content "Mix" from previous step in my flow, in this case "Mix" contain a string. I need to search for this string if exist in the SharePoint list that I got already her items in Get Items 2.

what condition i should use ?

Thanks you

[Hardesh15]

@GhassSD  so left hand side is correct. In logic you need to use contains and in right hand side just paste your string which you are looking in mix column.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[GhassSD]

Dear @Hardesh15 ,

"in right hand side just paste your string" how?

"Mix" is a dynamic content, his value differed according to the data input of the flow.

in the right side I need to set the expression, to search in my SharePoint list if this value exist.

Thank you 

[Hardesh15]

@GhassSD  See apply to each. It will check one by one with mix column value. Suppose you have 10 list items in which 3 have text 'search'. Then your condition will be mix contains search. For 3 loop items it will go into condition Yes block and for rest 7 it will go into condition NO block. 

Am i missing something here? Can you share complete flow screen.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[GhassSD]

Dear @Hardesh15 ,

I have this SharePoint list, I need to check if the last record in Mix column exist already before in the list, so directly the LOETime should be updated in the last record to be 0.5.

How I can achieve this. 

Thank You.

[Hardesh15]

@GhassSD  we can pick last record from list by using top count as 1 in get list items action. I have thought process for this. Need to test such scenario. As its already late night here. I will try to create your scenario and provide solution.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[GhassSD]

Dear @Hardesh15 ,

Big thanks for your effort.

Thank you dear

[GhassSD]

Dears,

Any help please

Thanks guys

[Hardesh15]

@GhassSD  I have tried your situation. but it is giving me two search results-one is search text and another one is existing similar text.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[GhassSD]

Dear @Hardesh15 ,

Thanks man for your try.

Can you share a screenshot for your flow and the condition.

[Hardesh15]

@GhassSD Here it is-

1. Getting latest list item

2. In my case choice1 column is similar to your Mix column

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[GhassSD]

Dears,

so our issue now is to get SharePoint list items without the last record ?

[GhassSD · Accepted solution]

Dears,

To get all SharePoint list items without the last record you can:

Get your items

Count them

Get the short list items with your count -1

or directly in Top Count: add(length(outputs('Get_items')?['body/value']),-1).

But I solved it by a workaround,

I calculate the length:

So the condition , If not equal to 1 so the value already exist, so the condition:

Thanks .

[Hardesh15]

@GhassSD  i thought you want to check with latest record because top will always give you top items. Suppose you have ceeated 10 items per day. If you fetch 10 records from top you will get latest items.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh