0

I have this SharePoint list named "WorkFlow Groups", which contain title and email, as follow:

johnjohnPter_0-1709218365190.png

Now I want to do a call to get all the items, then filter the items by the Title to get the email (the "WorkFlow Group" field), i tried the following but did not work:

johnjohnPter_1-1709218502966.png

johnjohnPter_2-1709218564601.png

enter image description here

enter image description here

enter image description here

but I will get null value... any advice?

2
  • 1
    Why are you using Select action again? Also, use GroupEmail instead of WorkFlowGroup in compose action formula. Commented Mar 1 at 10:39
  • 1
    Try solution given below without additional "select" action. Commented Mar 1 at 10:46

1 Answer 1

1

Ideally, no need to use the "Select" action in this case, use flow like:

enter image description here

Expression used in compose:

body('Filter_array')[0]?['WorkFlowGroup']

Where WorkFlowGroup is an internal name of your column in SharePoint list. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?

Output:

enter image description here


If you want to use "Select" action for any other reasons:

First, change the value of the GroupEmail key in the Map field (right hand side) of "Select" action to:

item()['WorkflowGroup']

then try using expression like below for compose action:

body('Select')[0]?['GroupEmail']
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.