cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Sharepoint get items filter by created by

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'
5 REPLIES 5
Super User
Super User

Re: Sharepoint get items filter by created by

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

Anonymous
Not applicable

Re: Sharepoint get items filter by created by

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
Super User
Super User

Re: Sharepoint get items filter by created by

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

Anonymous
Not applicable

Re: Sharepoint get items filter by created by

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
Super User
Super User

Re: Sharepoint get items filter by created by

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

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,278)