Flow runs! and value shows as copied to the desired column but column in empty in SharePoint List

(0) Share

Report

Posted on by amk1421

195

Implemented a flow to "create" or "update" existing item in target list from source list.

Currently, the Update(action from one of condition steps) ran successfully and updated all column values except for column "ProjectID" which is a number. In flow run history, value shows to be copied in column but in SP list it stays empty

ProjectID from right side condition ran "outputs" equals to integer 23

Snap 2023-06-01 at 15.40.42.png

But in SP list all columns have values copied except for "ProjectID"

Snap 2023-06-01 at 16.11.52.png

WHY THIS STRANGE BEHAVIOR??

@Pstork1 @Nived_Nambiar @Expiscornovus @ManishSolanki @SudeepGhatakNZ @Sundeep_Malik @RobElliott @wskinnermctc @annetoal @LinnZawWin @Chriddle

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Pstork1 69,554 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What is the actual JSON of the Outputs() you are using for the projectID and why aren't you using the regular dynamic content for that item like you are for Project Name and Project Process ID?

Was this reply helpful? Yes No
amk1421 195 on at

Like
a
(0)

Report
Copy link

Link copied!
@Pstork1 I used the dynamic content first and selected "ProjectIDCopy" a number column from source list but failed to copy value then tried "compose"

int(triggerOutputs()?['body/ProjectIDCopy'])

Actual json output

"ProjectName#Id": 23, "ProjectName_x003a_ID": { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 23, "Value": "23" }, "ProjectName_x003a_ID#Id": 23, "ProjectNameCopy": "TEST", "ProjectIDCopy": 23, "Modified": "2023-05-30T12:12:25Z", "Created": "2023-05-30T12:11:47Z"

Then after flow ran the output body shows the value copied to target list column "ProjectID"

Strange!! what to do?

Was this reply helpful? Yes No
Pstork1 69,554 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show the column setup for ProjectID in SharePoint?

Are there any updates of the item running later in the flow that might be overwriting the value added here?

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In SharePoint, how do you have ProjectID configured? Is it a string or a number?

Anne

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Your column is likely setup as a text/string. You need to covert the column to integer/number.

Was this reply helpful? Yes No
amk1421 195 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 "ProjectIDCopy" column is set as number type column

Was this reply helpful? Yes No
amk1421 195 on at

Like
a
(0)

Report
Copy link

Link copied!
@AWorley Column from source list is "ProjectIDCopy" and it is set as number. I also tried converting it back again in the Flow via:
int(triggerOutputs()?['body/ProjectIDCopy'])

Both cols are number type. Strange right?

Was this reply helpful? Yes No
amk1421 195 on at

Like
a
(0)

Report
Copy link

Link copied!

@annetoal Target list column "ProjectID" is number and so is the source list column "ProjectIDCopy"

Was this reply helpful? Yes No
Verified answer

AWorley 414 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Could you show the flow inputs for the action? Something doesn't seem right with it.

If possible I would delete the column and remake it.

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No