Using power automate to update sharepoint list columns from excel table but some data went missing

(0) Share

Report

Posted on by Glaz

Hi,

I have an excel table with many columns but i mainly only need the ID column and the Sector column.

My objective is to create a flow using power automate to lookup the excel table ID column and match the ID column in Sharepoint List, then update the sharepoint Sector Column with the excel table Sector column data.

Note: the sharepoint list has many other columns which i do not want to update. These value are be left as-is.

My flow ran successfully and the sharepoint sector column was updated. However some sharepoint list columns values which used to have data had its data value removed.

Has anyone encounter this strange behaviour? Is this a bug? Anyway to overcome this issue? Really appreciate any help that could be rendered. Thank you.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Glaz

What is the type of these columns?

Was this reply helpful? Yes No
Glaz 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Mira,

Thanks for the quick reply.
The fields that had its original data removed from the Sharepoint list were numbers, currency and date field type.
some of the same field type remains with data and its puzzling.

Rgs
Glaz

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Glaz

Can you check if these fields that disappeared have default values set to it on sharepoint?

Was this reply helpful? Yes No
Glaz 15 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly

Nope there is no default values for these fields in sharepoint list column. For example, when i click on add new item directly from the sharepoint list, what shows up are just empty fields for user input.

Was this reply helpful? Yes No
Glaz 15 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

Glaz 15 on at

Like (1)

Report
Copy link

Link copied!

Just an update. The issue seems to have resolved after i redo the excel table in a new sheet.

Manage to run the flow successfully, requires columns are updated and there no data from unrelated columns were removed.

Was this reply helpful? Yes No