cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sora
New Member

Update row excel from form answer

Hello,

 

im struggle to understand how to update a row from a form answer

 

i explain i have a form for the HR , HR complete the form and i get a excel i convert this excel to a CSV with power automate

 

Sora_0-1660668436613.png

in my form my first question is wich group the new user need to be in :

Sora_1-1660668537897.png

but when i get my CSV i got this result : 

Sora_2-1660668588036.png

but what i want is :  Group1;Group2

so my question is what i need to write / use function in "update row" to convert ["Group1","Group2"] to Group1;Group2

 

may be start with :

 

Sora_3-1660668814988.png

 

thanks you for the help 🙂

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Sora
New Member

Hi Everyone

 

I finaly find a solution , thanks to @MarconettiMarco you link help a lot to understand and find a way to do what i need

 

so my final solution is not with Variables but with compose and join

 

compose to have ";" and not "," : 

 
json(outputs('Obtenir_les_détails_de_la_réponse')?['body/r2d556e8bfe824fb398cc63113049911f'])

 

join to replace unwanted character 

replace(replace(replace(outputs('Obtenir_les_détails_de_la_réponse')?['body/r2d556e8bfe824fb398cc63113049911f'],'[',''),']',''),'"','')
 
Sora_0-1660817886764.png

 

View solution in original post

8 REPLIES 8
MarconettiMarco
Super User
Super User

Hello @Sora ,

please refer to the following article, regardless where to write the responses:

https://powerautomatejoy.com/2022/08/01/how-to-get-multiple-choice-responses-from-forms-and-put-them...

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

thanks you but is not that, i want to update a row in excel

Hello @Sora,

the solution provided allows you to replace unwanted characters, then you can use the variable to update your excel row.

 

BR,

Marco

ok i understand is almost works thanks

 

but is not remove the " and not replace the , by ; 

 

Sora_0-1660676296306.png

 

Hello @Sora ,

have you initialized the array variable putting this expression?

 

createArray('[',']','"')

 

the last character is “ between single quotes.

 

BR,

Marco

yes 

 

Sora_0-1660677582368.png

 

what i have do : 

Sora_5-1660677732616.png

Sora_6-1660677773365.pngSora_7-1660677812779.png

 

 

Sora
New Member

Hi Everyone

 

I finaly find a solution , thanks to @MarconettiMarco you link help a lot to understand and find a way to do what i need

 

so my final solution is not with Variables but with compose and join

 

compose to have ";" and not "," : 

 
json(outputs('Obtenir_les_détails_de_la_réponse')?['body/r2d556e8bfe824fb398cc63113049911f'])

 

join to replace unwanted character 

replace(replace(replace(outputs('Obtenir_les_détails_de_la_réponse')?['body/r2d556e8bfe824fb398cc63113049911f'],'[',''),']',''),'"','')
 
Sora_0-1660817886764.png

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,700)