Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
POSPOS
Helper V
Helper V

Microsoft Forms to Power BI

Hi All,

I have initially created a 'Forms for Excel' from SharePoint and then created a form. After I submit responses from the form, all of them were automatically saved in SharePoint which I used in Power BI. No additional steps were done.

Now, when I performed the same steps :

step 1 - Create a 'Form from Excel' in SharePoint

Step 2 - Create a form

Step 3 - Submit my response

Step 4 - Check if the results are saved in SharePoint -- this step Failed

 

The results are not being saved in the excel. It remains blank.

Can someone suggest if anything has changed from before? This worked fine until February 2024.

 

Thank you.

3 REPLIES 3
foodd
Super User
Super User

OK.,  for sanity sake, step through Reza Dorrani's walkthrough on Saving Form Responses to a SharePoint List.

 

Have you tried:

  • Verifying there are no issues managing, creating and updating Excel for the web files stored in OneDrive?   
  • Verifying there are no issues managing, creating, updating, and running  Power Automate Flows? 
  • Verifying that another Licensed User including a Tenant Administator that they are able to create a
    Form, the dependancies, and have the responses write out to a List as expected?

    If your requirement is solved, please make THIS ANSWER a SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

     

     

    ✔️

foodd
Super User
Super User

Hello @POSPOS , are you saying that when the Form response is submitted, that the SharePoint List does not update?   Do you have an alert set to notify when a new response is submitted?    Have you created a new Form for Excel, verified that the response storage has been created ... ?

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

@foodd  - Yes the  Form response is submitted, that the SharePoint List does not update

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors