web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps get a value form colle...

Power Apps

Answered

get a value form collection

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a question about using lookup collection value.

I want to get a value form collection.

Could someone advise me how to get a value?

here is my collection table.

Screen

Some formula is working but I don’t think this is a good formula to get a value.

working

LookUp(LookUp(book,true,items).volumeInfo,true,volumeInfo).imageLinks.thumbnail
LookUp(LookUp(book,true,items).volumeInfo,true,volumeInfo).title
LookUp(LookUp(book,true,items).volumeInfo,true,volumeInfo).publishedDate

not working

LookUp(book,items.volumeInfo.title.Value=TextInput3.Text ).items.volumeInfo.title

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

What does your fourth formula want to do? It is not supported to reference multiple level field in PowerApps

Since this is a single line table, your formula is equivalent to the following:

First(First(book).items).volumeInfo.title
First(First(book).items).volumeInfo.imageLinks.thumbnail
First(First(book).items).volumeInfo.publishedDate

To your fourth code, the right syntax should be like this:

LookUp(First(book).items,volumeInfo.title=TextInput3.Text ).volumeInfo.title

Hope this helps.

Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Worked😆
Thank you😌

Was this reply helpful? Yes No

Join the conversation