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:

General Questions

Connecting to Data

Using Apps Using Formulas

All responses (5)

Answers (1)

Verified answer

Moe69 on at

Like (0)

Report

Re: Question – SP Lists - PowerApps Forms

@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
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Question – SP Lists - PowerApps Forms

@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.
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Question – SP Lists - PowerApps Forms

@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.
Moe69 on at

Like (0)

Report

Re: Question – SP Lists - PowerApps Forms

@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
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Re: Question – SP Lists - PowerApps Forms

@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.