I have a dataset in Excel that is currently sent around quite a few offices. This dataset includes a user selector where the users can choose either a yes or a no and then a user editable comments column.
Once they all fill in the sheet with their answers and comments I run the next stage.
This is cumbersome and I figure there must be a simpler way with Power BI!
The closest I can seem to find for this functionality is something called Flow which I believe is a Powerapp (don't really know what a Powerapp is, assume some expensive add-on for functionality that should already be in the product).
Is there a way to build a simple report with just a Pivot Table with some filters and a user selectable Yes/No column that will save that response to either the original table or a linked table that I can then export into Excel? Preferably at no addidional cost to the server based "Pro" licence that my team has already had to buy.
My head say there must be a way to do something so simple, but perhaps I am wrong as a bit of google did not give me any easy to follow guides online.