I have made an app that turns the following input from a form and collection.
Form:
| Owner | Bob Smith |
| Job | Carpenter |
| Gender (Owner) | Male |
| Pet Name | concat() |
| Animal | concat() |
| Color | concat() |
| Sex (Pet) | concat() |
Collection:
| Pet Name | Animal | Color | Sex (Pet) |
| Ping | Duck | White | Male |
| Figo | Cat | Orange | Male |
| Bella | Dog | Black | Female |
The form uses the concatenate function to turn the pet characteristics into a string, resulting into a single record:
| Owner | Job | Gender (Owner) | Pet Name | Animal | Color | Sex (Pet) |
| Bob Smith | Carpenter | Male | Ping; Figo; Bella | Duck; Cat; Dog | White; Orange; Black | Male; Male; Female |
Current situation
Using a Power Automate flow, this record is turned into an HTML table with the same formatting as this record.
However, in order to make this output feasible for an RPA, the strings need to be split again and be in the following format:
| Owner | Job | Gender (Owner) | Pet Name | Animal | Color | Sex (Pet) |
| Bob Smith | Carpenter | Male | Ping | Duck | White | Male |
| Bob Smith | Carpenter | Male | Figo | Cat | Orange | Male |
| Bob Smith | Carpenter | Male | Bella | Dog | Black | Female |
Desired situation
Does anyone have any suggestions on how to do this? Can my record be split through an Automate flow?