Dynamic SharePoint List datasource for Form in Canvas Apps

(0) Share

Report

Posted on by annajhaveri

8,531 Most Valuable Professional

Hello,

We have multiple site collections in SharePoint, those site collection use same structure of document libraries, i mean same content type and column. Is it possible to create one Canvas app that can work with all similar libraries of different site collections?

Thanks,

Anna Jhaveri

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-bofeng-msft on at

Like (0)

Report
Hi @annajhaveri :

Could you tell me:

Do you want the app to connect to libraries with the same data structure in multiple SharePoint sites?(The answer is "Yes")

What's the meaning of "work with"?Could you provide some clear description?

Best Regards,

Bof

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @annajhaveri yes that is possible. Create collections to all the SharePoint libraries and in the app you can either have a menu or button that can switch between the collections.

e.g.

Two collections: ClearCollect(_A, [1,2,3,4]); ClearCollect(_B,[5,6,7,8])

gallery Items = If(TextInput6.Text = "a", _A,_B)

Hope tis helps

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@v-bofeng-msft thanks for response here are the answers

Do you want the app to connect to libraries with the same data structure in multiple SharePoint sites?(The answer is "Yes")

Anna: yes, also we would have atleast 50 sites, each site has 15 libraries with same structure, new sites get added in future, which should also work with Canvas app, so we would like one app to work for any library of same structure in site without making changes to Canvas app when new site is created or new library is created, is that possible?

What's the meaning of "work with"?Could you provide some clear description?

Anna: Work with means the canvas app will be a form, edit form, and to allow user to edit column values for specific document in the canvas app. The form should work for any document library of same structure in any site

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@rubin_boer thanks for response, but that will require me to change the Canvas App when a new library added to add new connection?

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @annajhaveri yip we have that limitation at runtime but i was looking at this some time ago maybe you will find this helpful.

https://www.c-sharpcorner.com/article/connecting-datasource-dynamically-in-power-apps-using-power-automate-part-1/

https://www.c-sharpcorner.com/article/connecting-datasource-dynamically-in-power-apps-using-power-automate-part-2/

I have never tried it, but it looks something worthwhile trying.

All the best

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @annajhaveri :

First of all,according to your description, this app needs to connect to 750 (50*15) data sources. This may be difficult to achieve, because the official recommendation is "Don't connect to more than 30 data sources from the same app."

I think this link will help you a lot:

Limit data connections

Secondly,one Form cannot support multiple data sources, so I am afraid your request cannot be fulfilled.

For example:

If I set the form control's DataSource property to:

Library1

It is fine.

If I set the form control's DataSource property to:

If( condition1, Library1, condition2, Library2, condition3, Library4 )

Although this will not cause any error, but this form will not work normally.

Best Regards,

Bof

Was this reply helpful? Yes No