Retrive lookup filed from sharepoint list

(0) Share

Report

Posted on by dejan

Hi all,

I'm trying to retrieve data from several lookup fields from a SharePoint list using the get items action.

Required fields do not appear in dynamic content.

Does anyone have some solutions? I believe that using expretion should be the solution but I'm not able to do so.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @dejan

You use the

items('Apply_to_each')?['Lookup']

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
dejan 45 on at

Like (0)

Report
Copy link

Link copied!

Hi @CFernandes,
thank you for your answer.
Unfortunately, this is not working for me I'm not able to pull any data with approach.

My Geti tems is returning what is expected but still output of compose is blank

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@dejan - Can you show me a screenshot of your SharePoint Library\List and the Column setting?

Was this reply helpful? Yes No
dejan 45 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes
This is column settings

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @dejan

Does you lookup column have any values in it? I am asking because you have not selected "Show additional column"

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
dejan 45 on at

Like (0)

Report
Copy link

Link copied!

Hi @CFernandes
yes all rows are populated,
I have add
link to the item column hoping that this will help. Strangely, I can see and pull data from one lookup. but not from the other (6) lookup columns that I need.

Was this reply helpful? Yes No
dejan 45 on at

Like (0)

Report
Copy link

Link copied!

I think that they are on a different site competing with this list

Was this reply helpful? Yes No
dejan 45 on at

Like (0)

Report
Copy link

Link copied!

Hi @CFernandes
the problem is that lookups pull information from the list that is on another site, those lookups that pull information from the list which are on the same site are visible, but from another site are not.

Was this reply helpful? Yes No
Verified answer

dejan 45 on at

Like (0)

Report
Copy link

Link copied!

So
As I said, the problem is that the lookup I'm trying to reach is on a different site.
To access those date previous owner created the site column because that is the only way how you can do a lookup from one site to the other. How to Create a Cross-Site Lookup

when you use power automated you can not reach the site column (I couldn't find a solution)
So in the end we moved sharepoint list to the same site create new lookups and then was able to use power automate to extract data.

Was this reply helpful? Yes No