Hi,
I want to update second company details also in same row not in the second line.
Here is my pot file. Can you please check and give me solutions?
Main.xaml (110.3 KB)
Thanks.
Firstly add to list the CompanyName Values
then by using string join funtion.
str=string.join(“,”,List))
Did you check my bot file? Can you check it and able to make correct please?
add all company names into a list using (list.append)
similar to the company job title and experience date create seperate list for every column and join the lists and make it into string and use that string to write in the cell
it helps.
can you able to write the flow for this?
Where to add this flow steps in my bot file? Thanks.
can you please share the output of the company names you are getting
try to use the below screenshots
please let me know if face any issues
We will get out like this:
First company name: Cloud Innovators Solution
First company job title: Social Media Marketing Specialist
First company: 1/2020 - 10/2020
Second company name: StoriCamPK
Second company job title: Marketing Communications Manager
Second company date: 7/2022
for Job_Titles has done in code
attached screen shot
list variables asisgn in variable pannel
Create a List Variable
create a string value to that assign string.join(“,”,Listvariable)
then pass that string variable to write cell
i have gone trhough your post
You need to use If activity inside the for each activity
Hope this helps
1 Like
Hi @Shiva_Nikhil
Yes, I followed if else condition as you mentioned. It works perfect.
Your guidelines helped to fix the issue. Thank you so much.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.