Link to another data source

(0) Share

Report

Posted on by kyoshihito

Hi.

I am troble with linking(Extract) another sharepoint list of certian feild.

I am using this PowerApps for Data sharing for a Project.
And linking progress feild from anouther sharepoint source call "Conference_Minutes" and field call "progress"

I am creating a canvas app in PowerApps from a SharePoint list of "Project_A"
in "Project_A" PowerApps, i want to link sharepoint source "Conference_Minutes" of field "progress"
since inside "Project_A" there are alot of sub-project. so once i link between certain sub-project and certain "progress"
i want them to save. and when next time i open the powerApps its linked.

Example
inside "Project_A" there are 1)Sub-projectA, 2)Sub-projectB, 3)Sub-projectC
and other sharepoint "Conference_Minutes" there are 1)progress for Sub-projectA, 2)progress for Sub-projectB

so i want to Extract the conference_minutes progress to Sub-project.
not only view, i want to make those data to be editable.

please teach me what iteam or logic should i use. if there similer yourtube movie which explaining its better.

Thank you very much for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kyoshihito ,

Could you please share a bit more about the data structure of your "Conference_Minutes" List and "Project A" List?

Which column do you use to link the two SP Lists?

Further, do you want to display the related conference_minutes progress based on specific Sub-project within your app?

Based on the needs that you mentioned, I think the two Gallery controls could achieve your needs. Within your app, you could consider add two Gallery controls in your app screen (maybe you need to configure your app as Tablet Layout app).

Set the Items property of the first Gallery (Gallery1) to following:

Project_A

Set the Items property of the second Gallery (Gallery2) to following:

Filter(Conference_Minutes, SubProject_Name = Gallery1.Selected.ProjectName)

Note: The ProjectName represents the Text type column in your 'Project_A' List. The SubProject_Name represents the LookUp type column in your "Conference_Minutes" List, which references values from the ProjectName column in your 'Project_A' List

For your second Gallery, you could configure it as a Editable Tabular Gallery, then you could view or edit data within the Gallery. More details about configuring a Gallery as a Editable tabular grid, please check the following video resource:

https://www.youtube.com/watch?v=Y5G5p84mD84

https://www.youtube.com/watch?v=41Mpgn7svLs&t=1s

Best regards,

Was this reply helpful? Yes No
kyoshihito 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft
Thank you for your reply
and I have asked similar question before and could not solve yet.
which structure is exactly same as below link question.
showing one certian field after mutliple filtering the sharepoint source

could you help me to solve this problem?
thank you

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kyoshihito ,

Based on the previous thread you posted, I think the formula provided could achieve your needs. Please type the following formula within the Gallery:

Filter( CSL, '03) Registration No.' = 'dropdown_ID number'.Selected.Value, // add .Value property after that Selected property '01) Service Point'.Value = Dropdown_City.Selected.Value, // Type ',' rather than ';' '02) Country'.Value = Dropdown_Country.Selected.Value )

above formula may cause a circular reference error, I think this issue is related to the Default property of your Country Dropdown and City Dropdown box. Please remove the formula (Gallery1.Selected.'02) Country'.Value and Gallery1.Selected.'01) City'.Value) from the Default property of your Country Dropdown box and City Dropdown box, then the circular reference error would disappear.

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No