Gallery and Subgallery: form item and fields

(0) Share

Report

Posted on by tama007

Hi everyone!

I am building a form in power apps using data that comes from power bi and a sharepoint excel file.

Basically, in power bi I have the following fields:

- Device id (can have multiple part ids)

- Part id (some devices share the same parts)

- Final id (concatenate of deviceid-partid) -> This is the unique identifier

- Store name

I have a gallery where the item is: GroupBy(PowerBIIntegration.Data, "device_reference", "Grouped1") and a subgallery set to: ThisItem.Grouped1

This second gallery has an arrow button that navigates to the form.

I have an issue setting the form item. I am trying to pass:

LookUp(formcomments, id = Gallery1.Selected.Gallery2.Selected.id_final)

But it doesn't seem to be working.

I also want to pass the device, part and store info to the form automatically, but it's only working for the device:

-Device datacard default set to: Gallery1.Selected.device_reference and it's retrieving the id correctly

-Part datacard default: Gallery1.Selected.Gallery2.Selected.part_id it's returning a blank

-Store name datacard default: Gallery1.Selected.Gallery2.Selected.store it's returning a blank

Any help will be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

tama007 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Add: I get an error saying that there is an issue connecting to data as well, so I am assuming the "Gallery1...Gallery2.Selected.x" is not an appropriate format.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@tama007

Use Set(varItem, ThisItem) in the OnSelect property of Gallery2 and for the Item property of the form:

LookUp(list2, ID=varItem.ID)

Was this reply helpful? Yes No
tama007 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Drrickryp , I've made the change, but I get an error message: Error when trying to retrieve data from the network.

Was this reply helpful? Yes No
tama007 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp I'm marking this as a solution since "Set(varItem, ThisItem)" did not work in the OnSelect for gallery2, but it did in the OnSelect of the arrow button.
Thanks a lot for your help!

Was this reply helpful? Yes No