Syntax expession problem

[euromedi1]

I am facing a problem , reffering syntax of expression on a filter array.

In fact i want to ( virtualy) join the sharepoint list with an excel sheet.

Everything runs fine except this exxpression which gives me wrong data.

The thing which i want to to say is : The email address of the record creator on the sharepoint , is the same with the email on a column in an excel file which called "Email" . I have to refer that the excel column "Email" has unique  values.

I think that on both sides of the filter array , i have to write something different , could you please help me ? Thank's in advance

[efialttes]

Hi!
Syntax look fine
"Everything runs fine except this exxpression which gives me wrong data"
Do you mean that Filter Array does not find any match in the excel table?
How many rows do you have in the table? More than 256? If, so did you activate pagination on 'List rows present in a table'?
https://powerusers.microsoft.com/t5/Connecting-To-Data/Excel-Business-List-rows-present-in-a-table-2...
Hope this helps

[euromedi1]

 Ι mean that Filter Array does not find any match in the excel table

The excel table has about 50 records , For sure it is less thatn 256

[efialttes]

Hi again!
One more suggestion in case nr of rows is not the issue.
Sometimes excel column data is added with 'hidden' spaces. So my suggestion is to switch both value in your condition rule (move the value on the left to the right and viceversa), then replace 'equals' operator and use 'contains' instead... something like
Excel Email Column contains SP Created By item Email
Hope this helps

[efialttes]

Hi again
A third suggestion, in case previous ones did not work. Are you sure Filter Array output is empty? So maybe the Condition action block executed afterwords is the one with a wrong sintaxis.
You can easily check by adding a dummy Compose action block in the middle, assign Filter array output as its input
Hope this helps

[euromedi1]

I swaped the values , and i made an expression for the email from SP. i works better , But  My problem is that the output of the filter array , are all rows which contains the email. And in fact i want the last record of the SP list which contains the email or with the Bigest ID from  the SP list ( this flow creates only records, so the Max ID is the ideal data for me )

[efialttes · Accepted solution]

@euromedi1 

First of all, is the first issue solved?

I mean the one you reported "Filter Array does not find any match in the excel table"

If so, this means we are closer to a happy ending!

Now let's talk about your new issues:

What I see in your screenshots is that you assigned Excel ‘Get rows present in a table’ output as  Filter Array input.

Since you mentioned:

“The email address of the record creator on the sharepoint , is the same with the email on a column in an excel file which called "Email" . I have to refer that the excel column "Email" has unique  values.”

How can you get more tan one result in your Filter Array output? If you assigned Excel ‘Get rows present in a table’ output as  Filter Array input  and Excel column “Email” has unique values, this is not possible right?

Now, regarding your new requirement:

“And in fact i want the last record of the SP list which contains the email or with the Bigest ID from  the SP list”

What I also see in the screenshots you shared is that the trigger is ‘When an item is created’. So I do not see any relationship between this new request (last record of the SP list?) and the screenshots shared so far.

Wait, wait, wait... did you change your Flow logic so it does anymore look like the screenshots shared so far? are you referring to extra service logic not shown in screenshots you shared so far? If answer to both questions is yes, then it can explain why I am not properly understanding your new challenges

Thanx!

[euromedi1]

Thank's again for your quick reply

Sorry , but my english are on so good.

Let me anwer  to you, i will start from the end:

My Flow logic has not been changed 

in fact i want to express that:

1 record ( 1 row) from the excel file , corresponds to 1 record ( in fact the record which i created on the sharepoint list). The only  common data from the excel is the email address , and from the sharepoint list is the email address + the last id with the same email address  from the SP ist.

After the filter array ( which filters the records from the excel list) , Normally i should expect  to have 1 row record, but some reaseon , i get the complete set of rows ( see attached photo) . I checked on the output of the filter array , and i found that on one record ( which has the same email address) , i have the set of rows and not the row of the excel file. In fact i have 48 records of the excel file , in my example i use email with no 45 record. All records except No 45 , have no output  . No 45 record has all rows of the excel file.

that's exactty is my problem.all records excepr Nr 45 , have no output

Nr 45 record has all excel rows

[euromedi1]

I found the problem , i replaced excel connector , the correct connectro in my case should be : Get a row.

Thank you very much , about your help , and your "trigger" to think about the whole flow logic.