Hi,
I'm working on a PowerApps integrating Power BI. The ultimate goal is for the users to add/edit/delete entries of a SharePoint list via PowerApps directly on the Power BI dashboard, with certain fields filtered on the dashboard data (PowerBIIntegration.Data.'Field') .
The Power BI dashboard integrates an Oracle database as its datasource and features multiple slicers used as filters on the information that is shown (for example, if the user wants to see information for a certain period only, the tiles are filtered consequently with the value selected on the 'Period' slicer).
I added a PowerApps tile to the dashboard. It uses some of the Oracle db fields also used for the filtering slicers. The PowerApp integrates a SharePoint list as a datasource for its add and edit forms. On the add form with autogenerated fields based on the SharePoint list, I have two dropdown fields that I want populated with the SharePoint list options but filtered with the data coming from my dashboard (PowerBIIntegration.Data), but PowerApps doesn't seem to allow it. How can I achieve what I want to do here?
I tried multiple syntaxes but nothing seems to work as expected.
1. With Filter(Choices('ListName'.'FieldName'); 'FieldName' in 'PowerBIIntegration.Data.Field), nothing shows up in the dropdown;
2. With Filter('ListName'.'FieldName'; 'FieldName' in 'PowerBIIntegration.Data.Field), it thinks the types of 'FieldName' and 'Field' are not similar enough for a comparison;
3. And when I try to add 'Value' after Period, as follows : Filter('ListName'.'FieldName'; 'FieldName'.Value in 'PowerBIIntegration.Data.Field)
I get a dropdown list with multiple blank choices :
Thank you
