Answered

Odata Filter On Created by SharePoint Get Items

(0) Share

Report

Posted on by Lowkey

I have a flow that is initiated by a user from a PowerApp. Multiple users use the app, so when the Flow is initiated i want the data from Get Items to be the only data from the current user that is created by that user in the sharepoint list to send through the chain. For Example when a user presses the button, the flow would get the items from the sharepoint list, compare it to the user profile, and then send only created by data through the chain of events. Any help would be greatly appreciated i don't know what the syntax is for Odata to pull the Created By column and compare it to user profile Mail.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Lowkey ,

I have made a test on my side and couldn't filter query the Created By email in the ODATA in the Get items action, I'm afraid that it is not supported currently and you could only take a try with the Filter Array action, please refer to screenshot below to create the flow:

Expression in the flow:

items('Apply_to_each_2')?['Email']

In the Parse JSON action, you could generate the schema from sample, you could copy the sample from the output of the Get items action:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Lowkey 31 on at

Like (0)

Report
Copy link

Link copied!

Thank you Alice, this looks like it is going to work great, my only issue now is that I am not that familiar with Json, so when i work in the Schema, how do I write date columns from SharePoint, Person columns ie i am looking for an email from a person column and choice value columns. Also is the column written like this say for Notes: column would it be
"Notes:": {
"type": "string"

?
Thank you so much you have already been a great help!

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Lowkey ,

You could generate the schema from sample, you could:

1.create a flow tom run the get items action, copy the Body output of the Get items action.

2.Add the parse JSON action, insert the Body output to the Content field, and click the generate from sample, then Insert a sample JSON Payload, the Body output is the sample JSON Payload, just paste the Body out put in it, and click Done.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Lowkey 31 on at

Like (0)

Report
Copy link

Link copied!

Thank you again Alice for the solution and the article. It helped me get to what I wanted.

Was this reply helpful? Yes No