Filter query syntax problem with "Created By" column

Like (0) Share

Report

Posted on 18 Apr 2020 21:53:07 by euromedi1

I am facing a problem when i try to update a sharepoint list from an excel file.

Mainly i have a query filter syntax problem on Get item .

in the SP list , the column " Created By" , i have adjusted , so i see the work e mail from my domain. , the column " NAME" on the excel has the same email address list. but if i execute the flow i have the error : Expression is not valid.

As you can see , the expression can read both , but for some reason it cannot compare them.

I also try on the filter query , not to write the " Created By" , and i put it as a function , i had the same result.

On the second photo , both email address is 100% exactly the same

Could you please help me ?

I have the same question (0)

All responses (7)

Answers (1)

euromedi1 27 on 19 Apr 2020 at 07:57:07

Like (2)

Report

Re: Filter query syntax problem with "Created By" column

It Works !!!! When you want to use the "created By"( for instance i want to use the creator email ) , the syntax for the filter query is : Author/EMail eq 'type_your_column_name'

Thanks for your help

Was this reply helpful? Yes No
euromedi1 27 on 18 Apr 2020 at 23:44:55

Like (0)

Report

Re: Filter query syntax problem with "Created By" column

This is my block of get item

Please note that the excel column : NAME , has the emails addresses

Maybe the solution is multiple filter ( but i don't know the syntax to fix it !!!) on filter Query

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on 18 Apr 2020 at 23:26:28

Like (2)

Report

Re: Filter query syntax problem with "Created By" column

Hi!

Maybe a typo, make sure you try with
Author/EMail instead (capital M)
https://powerusers.microsoft.com/t5/Connecting-To-Data/Multiples-OData-Filter-Query-in-SP-List-from-PowerApps-Trigger/td-p/377463

If this doesn't work either, Can you share a screenshot of your current flow design, so I can see the ODATA expression on your 'Get items' action block?
Thanx!

Was this reply helpful? Yes No
euromedi1 27 on 18 Apr 2020 at 22:40:35

Like (0)

Report

Re: Filter query syntax problem with "Created By" column

It seems that we are on the correct way. !!!!
But Right now , i have the error : One or more field types are not installed properly. Go to the list settings page to delete these fields.
clientRequestId: 5774382b-a08f-4a57-91f5-b60d30dc02bb
serviceRequestId: 5774382b-a08f-4a57-91f5-b60d30dc02bb

Was this reply helpful? Yes No
efialttes 14,756 on 18 Apr 2020 at 22:18:46

Like (1)

Report

Re: Filter query syntax problem with "Created By" column

Hi again!
First problem fixed. Now, replace Created By and use instead
Author/EMail

Hope this helps

Was this reply helpful? Yes No
euromedi1 27 on 18 Apr 2020 at 22:09:07

Like (0)

Report

Re: Filter query syntax problem with "Created By" column

no , the same problem , right now it seems that it cannot read the SP column from the list

Was this reply helpful? Yes No
efialttes 14,756 on 18 Apr 2020 at 22:01:12

Like (0)

Report

Re: Filter query syntax problem with "Created By" column

Hi!
I think there is a missing single quote at the end of your ODATA expression
Hope this helps

Was this reply helpful? Yes No