Unanswered

Sharepoint get items filter by created by

(0) Share

Report

Posted on by Community Power Pla...

Hi Jedi's, force be with ya'll

How can identify the field name for the users who created the items on my sharepoint list

Eg1: Author eq 'Luke Skypea'
Eg2: CreatedBy eq 'Luke Skypea'

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Gristy 2,429 on at

Like (0)

Report

Hey
I am afraid the Filter Query is not supported for Person Field usage.
To work with Person field in SharePoint List through the REST Call, we need to take use of the $Expand function within OData, while currently only the following is supported:
$filter
$orderby
$top

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Gritsy thank you for the information, if i know this earlier i should just created a force name inoutation on my sharepoint, and right now i have 4000 records

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

Create a new SLT field that is hidden
Use flow to populate that field with the Created By Name
Filter on that field.

You will need to go through and update the existing 4000 but you could do that with a instant flow also i.e. Get Items, Update Item

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, I am almost there
What i did is using flow i used
1.Get items where it had an output of all records
2.apply each item
2.1 update items
fields str_createdby = Author.displayname and str_modifiedby = edited.displayname

Result: it went good just in 99 records the rest are faileds, plus the 99 records was modified by me instead of modified my others

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (0)

Report

to modify by others you would need to use SEND HTTP action to pass in correct value.

Was this reply helpful? Yes No
MartinPyman 29 on at

Like (1)

Report
I know this is an old query, but thought I'd explain a solution (and I will add more details to my blog soon)

When you use Get Items in Power Automate and you want to use the filter property, there's a couple of things to note. The Odata query is expecting the ID for the user from the User Information List, Modified By and Created By internal names are Editor and Author.

This is what you can do...
Do a get items to the Site Collection that hosts the library you want to get stuff out of, use a custom value in the List Name... type "User Information List" - without the quotes

On this step add the following filter where Display Name is the display name of the users you want to get
Title eq 'Display Name'

Just for debugging you can then make a compose function and set it to this expression (assuming the step name was "Get items") - this also assumes you don't have duplicate display names in your AD
first(outputs('Get_items')['body/value'])?['ID']

Then do a second Get Items on the list you want to filter Created By. In the filter section put in
Author eq 'Outputs'
(where outputs is the dynamic content output from the Compose step)

Hope it helps

Was this reply helpful? Yes No
MartinPyman 29 on at

Like (1)

Report

There's an even easier solution you can find it on my blog
https://martinpyman.blogspot.com/2021/10/power-automate-get-sharepoint-items-by.html

Was this reply helpful? Yes No
Suggested answer

pradeep_khanna 31 on at

Like (0)

Report
Actually I found a very simple Solution to this:

"Get Items" from the SP List/Library:

Insert an action of type "Filter Array":

Filter the Output of "Get Items" where "Author Email" eq "Target Email":

Code-View for the Nerdier ones:

{

"type": "Query",

"inputs": {

"from": "@outputs('Get_Survey_Responses')?['body/value']",

"where": "@equals(item()?['Author']?['Email'],items('For_each')?['EmailID'])"

}

}

VIOLA!! The Output of the Filter step contains the filtered set of items from the SP List

Was this reply helpful? Yes No