Answered

Question – SP Lists - PowerApps Forms

(0) Share

Report

Posted on by Moe69

Question – SP Lists

I have a SharePoint customized forms, connected to List A and List B, both used the same DataSource.

The List A uses the default item of the forms SharePointIntegration.Selected, and List B, uses a LookUp function to get the specific List B item based on the selected List A item.

List A Item:

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@'ListA']),SharePointIntegration.Selected)

List B Item

LookUp(ListB, ID = SharePointIntegration.Selected.ID)

The question I would like to ask is this, is it possible to add a 3rd list (List C) to the current setup? I have tried to use the same LookUp function that List B uses in List C, but unfortunately this didn’t work.

So please could someone advise if this is possible to connect List C to List A and List B?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Moe69

SharePoint Integration is mainly used to provide a friendly user interface for a single list. You are pushing it to try to include more than one list. I suggest that you create an full app instead. You can do that easily from SharePoint and you will need the flexibility of that format to work with multiple connected lists and potentially other sources of data.

Was this reply helpful? Yes No
Moe69 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp

Thank you for your valuable advice, I wasn’t aware of such constraints when using SharePoint Integration customised form.
You suggested that I can create a full app instead? Are you referring to using PowerApps canvas? If not could you advise which app or how I go about exploring this avenue please.
Also, could I use a PowerApps canvas to build the same design and format I currently what to use?
Thank you in advance

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Moe69

Copy the url of your SharePoint list then go to make.Powerapps.com and watch the short video in the SharePoint box. Then select the SharePoint option and follow the directions. It will create anew canvas app.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Moe69

Copy the url of your SharePoint list then go to make.Powerapps.com and watch the short video in the SharePoint box. Then select the SharePoint option and follow the directions. It will create anew canvas app.

Was this reply helpful? Yes No
Verified answer

Moe69 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp

Thank you for your feedback, much appreciated and a lesion learnt. i will be looking to rebuild the forms using PowerApps canvas vice SP integration.

Thank you

Was this reply helpful? Yes No