Power Platform Community Forum Thread Details

Hi,

I am having some issue with power bi and power apps integration. I am passing values form power bi to power apps and filtering the data in the gallery as I am using power bi filters to filter the data in power apps. But It doesn't show all the data from CDS and also as I add new data from new form it is updating the power bi data but not loading in power apps. But if I edit the form then the changes are shown in the power apps.

I am using direct query for the data source.

For one of the gallery in the items section I have added following code

Sort(
Filter(
'ADAMM - Properties',
'Property Acronym (P)' in [@PowerBIIntegration].Data.'Property Acronym (P)' And StartsWith(
'Property Acronym (P)',
'Property Search Input'.Text
)
),
'Property Acronym (P)',
Ascending
)

On the edit button (On select ) I have below:

Set(varMode, "Edit"); Navigate('Property Add/Edit');

On the Add button (On select ) I have below:

Set(varMode, "New"); Navigate('Property Add/Edit', ScreenTransition.Fade)

For the add / edit form in the onvisible scree I have:

If(varMode = "Edit", EditForm('Property Add/Edit Form'), NewForm('Property Add/Edit Form'))

For the add / edit form On item part I have follow

If(varMode = "Edit", 'Property - Gallery'.Selected, varMode = "New", Defaults('ADAMM - Properties'))

Could some one help me with this. Thanks for the help in advance.

Categories:

Building Power Apps