How to connect a form from a different data source to the original form

(0) Share

Report

Posted on by WelshFuzz

Hi Everyone

I am brand new to PowerApps so sorry if this is very basic stuff.

The Background

I am creating a problem creation database.

In SharePoint I have ListA which can be created by UserA, and then assign the problem to UserB. This then creates a new item in listB and only allows UserB to be able to edit the item in ListB.
UserA can’t edit listB and UserB can’t edit ListA.

in powerApps I have the gallery showing ListA on selection then I want to view formA and fromB

formA input is Gallery1.Selected.

now my problem is I don’t know what to have the input for FormB. Logically it would be something like Gallery1.Selected.ID=‘FormB’.’IssueNumber’

could someone help me with this please

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report
@WelshFuzz

Assuming that the ID value ListA is associated with the 'IssueNumber' value in List B, you would set the Item property of FormB to:

LookUp(ListB, IssueNumber = Gallery1.Selected.ID)

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

To add to what @timl said, although User A doesn't need edit access to List B they must have at least Read access or what you are trying to do won't work. The same thing is true for User B to List A.

Was this reply helpful? Yes No
WelshFuzz 6 on at

Like (0)

Report

Thank you, it’s working 😊
Just need to spend some time and get all the other functionality working.

thanks again.

Was this reply helpful? Yes No
WelshFuzz 6 on at

Like (0)

Report

Thank you, they do.

Was this reply helpful? Yes No