Can't Get data from 1 Column

(0) Share

Report

Posted on by firda59

372

Hi,

I have this flow for copy data from excel to SP list,

Since someone changed the header table in excel, it always getting error. I don't know why, my SP list can't grab 1 column (Title column) data from that excel. If I checked from detail flow, get items output are blank.

Before error happen, output can appear in get items operation

Can anyone help me to fix it? Thank you.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Did you inspect the output of your excel action?

Is it returning all the rows and columns from excel?

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ

the output in excel normal, the column (orange color) are appear in this output,

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Have you applied the oData filter in your Get Items action properly?

You mentioned that it is not returning any values meaning either there are no items in list or the filter is incorrect.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ

the filter work well
Others column can work well, but 1 column is blank. I don't know why, because there is no error message
blue column I just added to replace red column, but still cant work

Was this reply helpful? Yes No