PowerApps (with PowerBI data), all screens to reflect selected record

(0) Share

Report

Posted on by milky_bar_may

228

Hi PowerApps Team,

I have a problem that I am hoping you can help me solve.

My PowerApp is designed with Power BI integration as my datasource.

The design of the App has to have the following flow:

Screen 1: A gallery displaying the customer name and subregion. An arrow next to each record in the gallery that navigates you to Screen 2.

Screen 2: After the user selects the arrow, depending on which record they want to see from Screen 1, Screen 2 should only display that specific information of that record.

Therein lies the crux of my problem and is the same issue for Screen 3 and Screen 4.

After the user chooses a specific record to navigate to from Screen 1, the rest of the screens should update to reflect only that records information.

I have tried various solutions with onselect but have yet to find a solution.

Can you help please?

Thank you

Milky

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Why are you using Power BI as the source instead of the main source that Power BI is using? I've never used Power BI as a data source so I'm not entirely sure how it behaves, but traditionally in PowerApps, the way it would work is to reference the selected entry from a gallery (on any page) is as below:

Was this reply helpful? Yes No
milky_bar_may 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Thanks for your response.

I am not too sure I understand your question. I used the PowerApp visual in the marketplace and added my fields from Power BI to create my app. Hopefully that helps to clarify what I meant.

So on the arrow that I have, if I put that line of code in all the remaining screens will only reference that specific Gallery record?

Many thanks for your help

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @milky_bar_may ,

What are screen3 and screen 4 for?
If you want to pass the Selected Item from Gallery1 to From in screen2, It is not supported, because Form only supports to display/edit data source, but the PowerBIIntegration is not. So you have to customize a from manually, Please check my following test.
1. The PowerBIIntegration.Data in my test has two fields, Name and Title
2. Set OnSelect of NextArrow in Gallery1 to Navigate(Screen2)
3. Set fours label's Text property as below:
Label1: "Name"
Label2: Gallery1.Selected.Name
Label3: "Title"
Label4: Gallery1.Selected.Title
Then when you click the arrow, the screen2 will show the detail of selected items.
Best regards,
Sik

Was this reply helpful? Yes No
milky_bar_may 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both, it's working now.

Was this reply helpful? Yes No