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
Solved! Go to Solution.
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!
Proud to be a Flownaut!
Proud to be a Flownaut!
Ι 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
Proud to be a Flownaut!
Proud to be a Flownaut!
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 )
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!
Proud to be a Flownaut!
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
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.
Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
User | Count |
---|---|
50 | |
40 | |
39 | |
34 | |
33 |
User | Count |
---|---|
69 | |
64 | |
60 | |
58 | |
50 |