Forum Discussion

Munez's avatar
Munez
Copper Contributor
Feb 19, 2020

Auto increment id

How do I add auto increment on excell after downloading excel document from Microsoft forms pro, it's comes with Id on forms but on pro no id
microsoft forms
Ramteja's avatar
Ramteja
Icon for Microsoft rankMicrosoft
Feb 19, 2020

Munez 

That is not an auto increment Id, its a response Id of the response, try deleting one response in the middle.. Forms Pro is not sending this data when exporting responses.

 

  • Munez's avatar
    Munez
    Copper Contributor
    Feb 19, 2020

    Ramteja  thanks, i wanted to use excel data to generate powerbi report  from forms pro any suggesting? 

    • Ramteja's avatar
      Ramteja
      Icon for Microsoft rankMicrosoft
      Feb 19, 2020

      Munez What kind of report you are trying to generate?
      Based on your requirement we can give you suggestions

      • Munez's avatar
        Munez
        Copper Contributor
        Feb 19, 2020

        Ramteja 

        something like this

Resources