SharePoint get data from subsite dynamically

(1) Share

Report

Posted on by freedumz

Hi everyone

I'm trying to do a tricky thing with project server

So this is the idea, I use project server, on this server I've all my projects, for each project a sharepoint site is linked

For example, I've a project EatUnicorns

So I've a make a connection with this sharepoint site

https://mysharepointsite/sites/Projects/ , and I tried to reach my list Rainbow I can't acces it( here, I mentioned no Project, it is the general website)

but if I etablish a connection with this website:

https://mysharepointsite/sites/Projects/EatUnicorns, I can reach my list Rainbow

So the idea is the following

I built an app where all my project are listed, if I selected one projet, I have all data about it

But now what I'd like to do is when I select a project,

I could reach all list from the selected project so the idea would be to have a dynamic URL for my sharepoint URL in my databaseselection

https://mysharepointsite/sites/Projects/DynamicValue

So is it possible?

If it isn't, what is the best way to do that? Would it be to put all lists in a database with their projectID ?

Many thanks

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

freedumz 69 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi everyone
I'm trying to build an app for my project online but I've a last question
I found a way to get the 5 lists I have for my project but it is long (I've 95 projects, so I've to add 95 X 5 datasources)
So my question is for the future, is it possible to add a database automatically ?
For example, if I build a new project called ProjectTrial, I'd like to get my 5 lists directly
Is it a way to do that? With flow?

Many thanks in advance for your help
v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

No, it is not available.

Customize connection is currently not supported.

your requirements would need to build up the SharePoint connection aotumatically based on the Project URL, which is not available according to my knowledge.

Regards,

Michael
freedumz 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok thanks you for your feedback @v-micsh-msft
I maybe found anoter way, is there a limit of the number of datasource we can add in a project?
Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

There should be no limits on that part based on what I know.

Check the article below for the limits in PowerApps:

https://docs.microsoft.com/en-us/powerapps/limits-and-config

Regards,

Michael
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-micsh-msft.

I'm trying to do the same thing. Could you please share your solution?

Best regards,
Rodrigo.