Hi,
I have an issue with a Flow Sharepoint Get Items action.
Its a very simple filter that tries to get an item of a sharepoint list (lets call it List A) based on a value from another sharepoint list (Lets call that List B). The Value in Column Title List A is 'Sol'. List B Title has unique values, so I want to filter it out and only get the items that has 'Sol' in the Title.
The query is as follows
Title eq 'Title'
Which is
Title eq 'Sol'
But I get a invalid expression
The expression "Title
eq 'Sol'" is not valid.
clientRequestId: 9704f697-51c7-47de-972e-40d0f764ba7e
serviceRequestId: 5abf9f9e-d0d9-7000-fe72-a61f41d61aed
I tried manually enterting the string 'Sol' but still the same.
If I remove the fiilter, I can see that the value is there
{
"value": [
{
"@odata.etag": "\"5\"",
"ItemInternalId": "1",
"ID": 1,
"Title": "Sol",
"Email_x0020_address": "sol@it-x.co.uk",
"Allocated_x0020_number_x0020_of_": 40,
blah blah blah
Now, I do have a work around where I use a condition and not use a a filter, BUT would like to see if I can work with a simple filter
Solved! Go to Solution.
Hi @solte98,
You should use expression:
Title eq 'Title dynamic content of the item in List A'
I have made a test on my side to create a flow as below:
And the expression in the Filter Array column as below:
Title eq '@{triggerBody()?['Title']}'
When an item is created in the List A and the Title is Sol, the flow would run successfully as below:
Best regards,
Alice
Hi @solte98,
You should use expression:
Title eq 'Title dynamic content of the item in List A'
I have made a test on my side to create a flow as below:
And the expression in the Filter Array column as below:
Title eq '@{triggerBody()?['Title']}'
When an item is created in the List A and the Title is Sol, the flow would run successfully as below:
Best regards,
Alice
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
80 | |
55 | |
55 | |
43 | |
39 |
User | Count |
---|---|
83 | |
81 | |
76 | |
65 | |
42 |