Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Extract data from Smartsheet List and create csv file to attach the file in sharepoint list

Posted on by 2
Hi folks, I currently working on creating a csv file with header Employee Name, Email and Position based on data that I extract from Smartsheet Employee List. 
 
 
 
the output that I want in csv file is:
 

 
but I am stuck where I always get this output instead:
 

 
This is how my flow looks like,
 
 
 
compose formula: 
 
concat(items('For_each')?['Employee Name'], ',', items('For_each')?['Email'], ',', items('For_each')?['Position'])
 
next flow after For each action
 
  
 
Appreciate it if you guys have any idea on how to resolve this issue.   
  • SO-18110510-0 Profile Picture
    SO-18110510-0 2 on at
    Extract data from Smartsheet List and create csv file to attach the file in sharepoint list
    hi @Jalpa Mahesh Dhola, I already update the screenshot. let me know if still not upload correctly. thanks
  • Extract data from Smartsheet List and create csv file to attach the file in sharepoint list
    Can you please check the screenshots again?
    Its not uploaded correctly.
    I have gone through similar requirement but what's the issue here is still not clear.
    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard