Forum Discussion

IshRashad's avatar
IshRashad
Copper Contributor
Jan 20, 2024
Solved

Help with reverse-engineering an expired form from the linked Excel table

Hi,
I've been on a steep learning curve about Forms, to help a client user. And I'm a (relative) novice to troubleshooting Forms. Bear with me, please...
- My entry point was a "missing" form. To cut to the chase, it was a personal form shared with others via links (not transferred to an ms365 group), the user had left the organization, etc. So the form was past recovery, purged out of the system. And it caught them by surprise when it expired a few days ago, after the 30-day recovery cut-off.
- I now have only the Excel table where responses were being collected.
- It's easy enough to create a new form but there's one column that puzzles me, and I'd appreciate it if any of the expertise here can explain this:
- This is a forms "choice" item, and I'll explain with an example:
Let's say the 3 choices are:
- Fruit
- Vegetables
- Other

In the table rows, as expected, I can see entries where people have selected these options.
But I also see some entries with what look like concatenated additional strings. Like...

Vegetables;

Fruit;

Fruit;Apples;

Fruit;Apples;Jonathans;


And I just cannot figure out how these could have been entered via a form.
Is there a way of concatenating text fields with choices? Because that's what it looks like. I have experimented with branching and the "other" field, etc in vain.
Can anyone shed any light on this, please? It's doing my head in. 🙂

Thanks!

 

  • IshRashad it just means it's a choice question that allows multiple answers to be selected.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

2 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor

    IshRashad it just means it's a choice question that allows multiple answers to be selected.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

    • IshRashad's avatar
      IshRashad
      Copper Contributor
      Ha ha. Thanks, Rob.
      Of course, I didn't check that (obvious) possibility.
      Many thanks (says he, red-faced)
      Cheers
      Ish

Resources