cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Faisal_Baloch
New Member

Image Formula in Lesson "Connect to Loan table data in my Canvas App"

Formula: Lookup (BookCopies, BookCopies=ThisItem.'Book Copy".BookCopies).Book.BookImage

 

In the power up course I understood that: "(BookCopies, BookCopies=" is trying going in table "BookCopies" and inside it has a field "BookCopies" with the book reference no. 

 

But what is  "=ThisItem.'Book Copy".BookCopies" is not clear in the lecture. My confusion is:

 

From where "Book Copy" came from and what dose this "BookCopies" refer to is it the table or the field. and how it's creating a reference?

 

I am lost in details please help to clarify. 

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Multi Super User
Multi Super User

Hi @Faisal_Baloch ,

 

ThisItem is an identifier that is used in the context of a gallery and refers to the displayed item. In this case the Items property of the gallery is set to Loans, which means that anything inside the gallery that refers to ThisItem is actually referring to the Loans table.

 

Having said that, ThisItem.'Book Copy' references the 'Book Copy' column in the Loans table. Since that column only saves a key of the book copy and not the full data of the book copy, a LookUp function is used to retrieve the full data, including the BookImage.

 

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

1 REPLY 1
BCBuizer
Multi Super User
Multi Super User

Hi @Faisal_Baloch ,

 

ThisItem is an identifier that is used in the context of a gallery and refers to the displayed item. In this case the Items property of the gallery is set to Loans, which means that anything inside the gallery that refers to ThisItem is actually referring to the Loans table.

 

Having said that, ThisItem.'Book Copy' references the 'Book Copy' column in the Loans table. Since that column only saves a key of the book copy and not the full data of the book copy, a LookUp function is used to retrieve the full data, including the BookImage.

 

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Helpful resources

Announcements

Learn what to expect in the Power Up Program

Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course.   Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.  

Welcome to the Power Up Program Community

The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate.  As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards.  Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.

Top Solution Authors
Top Kudoed Authors
Users online (4,484)