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

Show Item Detail From Multiple Datasource

I have a problem, to display data on the detailform taken from 2 data sources.

 

I have 2 datasource "registrationList" and "scheduleList", Some of the data in "scheduleList" is taken from "registrationList", what I want is that I can display the contents of the "attachment" column from the registrationList on the detailform based on the ID in the ScheduleList after a gallery fetched from the scheduleList is pressed.

 

registrationList = memberID, Name, Address, Attachment
scheduleList = memberID, day, time, room

 

How do I do this, thank you

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @arasyid :

Do you want to get the Attachment associated with an item in the gallery based on the scheduleList?

If so,please try this:

1\Add a gallery and set it's items property to 

scheduleList 

2\Add a button control into this gallery and set it's OnSelected property to:

Set(TheVar,LookUp(registrationList,memberID=Thisitem.memberID).Attachment) /*TheVar is my custon variabel*/

Related attachments will be saved in the variable TheVar, you can directly call TheVar to get the corresponding attachments.

 

In addition,if you want to display the contents of scheduleList and registrationList based on scheduleList.The point is to use AddColumns function.

Set the gallery's items properto to:

AddColumns(
  scheduleList,
  "Attachment",
  LookUp(registrationList,memberID=scheduleList[@memberID]).Attachment
)

Then you can directly use this formula to get the attachments associated with the item you selected:

GalleryName.Selelcted.Attachment

Best Regards,

Bof

 

 

 

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @arasyid :

Do you want to get the Attachment associated with an item in the gallery based on the scheduleList?

If so,please try this:

1\Add a gallery and set it's items property to 

scheduleList 

2\Add a button control into this gallery and set it's OnSelected property to:

Set(TheVar,LookUp(registrationList,memberID=Thisitem.memberID).Attachment) /*TheVar is my custon variabel*/

Related attachments will be saved in the variable TheVar, you can directly call TheVar to get the corresponding attachments.

 

In addition,if you want to display the contents of scheduleList and registrationList based on scheduleList.The point is to use AddColumns function.

Set the gallery's items properto to:

AddColumns(
  scheduleList,
  "Attachment",
  LookUp(registrationList,memberID=scheduleList[@memberID]).Attachment
)

Then you can directly use this formula to get the attachments associated with the item you selected:

GalleryName.Selelcted.Attachment

Best Regards,

Bof

 

 

 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (9,611)