Cross-site lookup fields not accessible in MS Flow
-
- Posts: 2
- Joined: Thu Jun 04, 2020
Dear
I searched trough a lot of topics regarding this issue. I have multiple lookup fields but I can't access them using MS Flow.
I just want to store their values in to a variable, but the value just isn't accessible.
The names of the columns are: 'School' and 'Vestiging' (our SharePoint Online has dutch language, Opzoeken is lookup) In flow I tried accessing them with an expression: And also the columns are not appearing in the search function: While the normal lookup and standard fields are appearing: The return of the variable just gives an empty string when running the flow:
I searched trough a lot of topics regarding this issue. I have multiple lookup fields but I can't access them using MS Flow.
I just want to store their values in to a variable, but the value just isn't accessible.
The names of the columns are: 'School' and 'Vestiging' (our SharePoint Online has dutch language, Opzoeken is lookup) In flow I tried accessing them with an expression: And also the columns are not appearing in the search function: While the normal lookup and standard fields are appearing: The return of the variable just gives an empty string when running the flow:
- Attachments
-
- 2.PNG (23.75 KiB) Viewed 69840 times
-
- 1.PNG (10.86 KiB) Viewed 69840 times
Hello sandernelen,
Please try to use this expression in the flow:
Where Lookup is the internal name of the field. You can find the internal name of the field either in Forms Designer or in the List Settings >> Columns Settings >> Page URL.
Please try to use this expression in the flow:
Code: Select all
@{triggerBody()?['Lookup']?['Value']}
-
- Posts: 2
- Joined: Thu Jun 04, 2020
Dear mnikitina
Something went wrong with my post, the suggestion you gave I already found in another post and does not work for me:
Column name in URL: Declare variable with field as string: Output is empty when running flow: I also tried just to 'compose' the field in flow, still can't get the value... Any other suggestions?
Thanks in advance,
Sander
Something went wrong with my post, the suggestion you gave I already found in another post and does not work for me:
Column name in URL: Declare variable with field as string: Output is empty when running flow: I also tried just to 'compose' the field in flow, still can't get the value... Any other suggestions?
Thanks in advance,
Sander
Hello sandernelen,
Have you selected a specific View for the field Limit columns by View? If yes, please make sure the view you’ve selected contains all columns. Do you see the lookup column in the dynamic content?
Also please try to create a new flow and check if you can see the lookup column in the dynamic content.
If that doesn't help, please contact Microsoft support for help as this issue is not related to cross-site lookup columns.
Have you selected a specific View for the field Limit columns by View? If yes, please make sure the view you’ve selected contains all columns. Do you see the lookup column in the dynamic content?
Also please try to create a new flow and check if you can see the lookup column in the dynamic content.
If that doesn't help, please contact Microsoft support for help as this issue is not related to cross-site lookup columns.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 3 guests