Filter query syntax problem with "Created By" column

(0) Share

Report

Posted on 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 ?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

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
euromedi1 27 on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (1)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

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
Verified answer

efialttes 14,756 on at

Like (2)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

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
euromedi1 27 on at

Like (2)

Report
Copy link

Link copied!

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