cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Biccbacc
Level: Powered On

Adding data to a survey going from Forms to Power BI

Hi!

 

I am just learnin about flow, forms and power BI. I want to use theese apps to gather, organize and visualize different kinds of data. 

 

As a learning project, I want set up an activity-registration for all employees in my company. 

Every year we have a competitin with prizes to employees who run/walk or bike  more than X days. There are also prizes for most km run, most km on a bike, most total registrations etc. We are a lot of emplyees, in different divisons and located in different cities.  I want to simplify the registration (Forms), data collection (Flow), data storage and organization (excel or sharepoint list) and visualize the data for everyone (power BI)

 

So Far, I have made the Forms, collected the data and sent it to power BI and published it to a website. All good. 

Problem:

I dont want everyone to add "division" and " city" to the registration every day. We allready have that information in our list of employees. 

 

How do I add data about "division" and "city" to every registration? I need this data in Power BI, so that I can make graphs and leaderboards based on city and division. 

 

I have a list of all employees, with name, email, division and city. I will also soon have hundreds of registrations from Forms with Name, email, km, date and mode of transportation. My list of employees exists both as a sharepointlist and  can get a copy in excel. 

 

Where do I combine the data? With flow from a sharepoint-list or excel? Or direclty in PowerBI?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Adding data to a survey going from Forms to Power BI

Hi @Biccbacc ,

 

If Data Source used by Power BI is SharePoint Online, you could get the city and division corresponding to Responder by submitting information of the form.

Then update the data to the SharePoint List which is used be a Data Source.

And set the schedule refresh in Power BI, and get the latest data contained in the List every once in a while.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Biccbacc
Level: Powered On

Re: Adding data to a survey going from Forms to Power BI

Thank you for trying to help. Unfortunately, I do not understand what you mean. 

 

 

If Data Source used by Power BI is SharePoint Online, you could get the city and division corresponding to Responder by submitting information of the form.

 


How do i update the sharepoint list with city and division? And from what source?

 

Best Regards 

 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors
Users online (6,052)