Hey all,
I'm building an app that will allow users to comment within a filtered Power BI dashboard - having filtered based on location and time period, they will add comments using an edit form, and be displayed a gallery of comments related to that selected period.
Pretty straight forward. Except seems I'm new to Power BI integration and my Googling skills are failing me.
I've got the gallery filtering on both time and location no problem. Next up is the actual edit form. I want to pull the selected filters into the app as hidden fields that are saved to the SharePoint list. Once that's done I've got everything set, I'm just not sure the formula required to write that pull. Seeing a lot of lookup but can't make it function.
basically I have 2 fields in Power BI I need - 'time' and 'location'. Here's what I attempted but I'm getting back that this is providing a record - which is not what I want. I need a string for these fields to save back to SharePoint for my filter command on the gallery.
LookUp('SharePoint List', Location = First(PowerBIIntegration.Data).'PBI Location')
Error is "Expected text value"
Any guidance? Thx!
