I'm trying to return an additional SP column in a Flow I've inherited. I've checked the name of the field in the address bar and it's showing as 'BTG%5Fx0020%5FPolicy%5Fx0020%5FOwner'. I've added it to the Uri but I'm getting the following error:
The query to field 'BTG_x0020_Policy_x0020_Owner' is not valid. The $select query string must specify the target fields and the $expand query string must contains BTG_x0020_Policy_x0020_Owner.
The field in SP is a 'People Picker' field. I'm also figuring out how the script works after $filter.
Any help appreciated!
Solved! Go to Solution.
Did you find an answer to your question?
As you wronte the 'BTG_x0020_Policy_x0020_Owner' is a people field, so you have to get the value from it using both $select= ... and $expand= ...
In both places you have to use the BTG_x0020_Policy_x0020_Owner/title - this should give you the value of the field.
Unsure if title after the slash is correct, else you will have to search for this information 🙂
Hope this helps a little. Kind regards, John
Thanks @JohnAageAnderse added the column to the select:
and I'm getting the following error:
The query to field is not valid. The $select query string must specify the target fields and the $expand query string must contains BTG_x0020_Policy_x0020_Owner.
Which I've Googled and I'm not getting much luck.
You are nearly there 🙂
The select and expand should look like this example, where I use the Author column in my list:
Select states what to get, in the above it is the Authors title aka name. Select can only get it, because Expand helps providing the additional information.
Kind regards, John
Thanks @JohnAageAnderse , I think I'm close! I'm getting a different error message!
Is it because of the '/' after the expand?
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!