Unanswered

Facing issue to import data from sharepoint to datatable

(0) Share

Report

Posted on by Umeriqbal01

i upload a data into sharepoint and get data in power automate with Datatable activity and store the data in excel from datatable
but problem is i am getting 1st 0 index row is empty how i can fix this
my sharepoint data

and my datable is

can someone help me to fix this please

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Since there is some space between headers and 1st row in your SharePoint file it is taking that as row and with empty values...

You can delete it
By using find and replace activity to find the empty row and use delete that specific row
With the index we get from find and replace activity

Hope this helps
Usha.
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please provide some screenshots of your flow so that we can get clarity about the issue
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If you are using Create new data table in your flow to create the data table, it always gets one empty row added to it, if you add column names. This is the way the action works for some reason. Simply add Delete row from data table right after creating it and delete the row at index 0. Then add your items to the table afterwards.