Hi,
I have a form which is filled by the users in Excel. Screenshot
The user starts with the First quetion - Number of Years . User enters any value between 1-5.
Then the second question is made visible - COL Base.
Depending on the answer Yes or No, The column Code and Price is populated from a look sup sheet is excel.
The next Question Cos Line or Factory should be populated, if the answer toi COL Base is No.
This question will have answwer Yes or No and based on the answer the columns Code and Price is populated.
I want to use Flows to do this and the data to be shown as a table in Power BI.
Is this achievable ? Is this to be done using Forms, Flows and Power BI ?
Any help will be highly appreciated.
Best Regards
Srini
Hey @cheenusing
Yes, you can create an MS Form as per the requirements and then using flow, populate that to an excel sheet. Note that if the excle sheet is online and the PowerBI report is based on that you can simply add the row to the excel file and then add an action to refresh the PowerBI report in flow.
If you want to completely bypass the excel part, you can add an action to add a row in the PowerBI dataset and then immediately refresh it. --> the flow will be triggered when somebody responds to the form, then get response details, add the row and refresh the data set.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @cheenusing,
It is possible to create the such Microsoft Form by using branching rule, there is the document that how to use it:
https://docs.microsoft.com/en-us/forms-pro/create-branching-rule
And you can create a Flow with a trigger When a new responded is submit to get the Response, then put into a excel table.
But There is no action could import excel file into Power BI, so you need to import it using PowerBi, not Flow.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.