web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Building an excel form...
Power Automate
Unanswered

Building an excel form to be used in Power BI

(0) ShareShare
ReportReport
Posted on by cheenusing

Hi,

 

I have a form which is filled by the users in Excel.   Screenshot

 

Capture.JPG

 

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

Categories:
Using connectors
I have the same question (0)
  • v-litu-msft Profile Picture
    v-litu-msft Microsoft Employee on at

    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.

  • yashag2255 Profile Picture
    yashag2255 24,769 Super User 2024 Season 1 on at

    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. 

    fdd.PNG

     

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans