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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / Building an excel form...
Power Automate - Using Connectors
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

I have the same question (0)
  • v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Building an excel form to be used in Power BI

    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
    Re: Building an excel form to be used in Power BI

    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
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans