Forum Discussion

duycao's avatar
duycao
Frequent Visitor
6 years ago

File name becomes Column name

Hi all,   This is I think a very simple staff but I've struggled with this for a while.   Basically, I connect data via the SharePoint folder. I need to update the data to that folder on a weekly...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, duycao 

 

Based on your descirption, I'd like to suggest you use sharepoint folder connector to connect to the folder in the sharepoint. Please make sure each file has a sheet with same name and the table in the sheet has same structure.

 

Result:

 

For further information, I'd like to suggest you refer to the document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • duycao's avatar
    duycao
    Frequent Visitor
    6 years ago

    Hi, thank you for your suggestion.

     

    I did follow the steps you suggested from the beginning but I still face this issue you can see in the below image, the program didn't take the first row as the header.