Unanswered

Update Row in Google Sheet from Sharepoint List

(0) Share

Report

Posted on by jannet

Hello,

I have a SharePoint list. I have created a flow where it would insert a row if the status is marked as a new request. And if the status is marked as complete, it would update the row with the results.

However, I am running into the issue where the flow wont update the row.

Update Row 1.PNG Update Row 2.PNG

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@jannet

Can you provide a little more information? When you say that the Flow won't update the row, is it because of an error?

Take a look at one of your runs and walk though it. When you come to a condition, does it act the way that you expect?

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @jannet ,

Please check from your flow run history to see if the flow has run into the if yes branch of the Condition and if the "Update row" action has run.

If the Condition always run into the if no branch of the condition, please check if there is a row in your sheet and the same ID with the sharepoint item ID, make sure that you have save the ID of the item to the ID column in your sheet.

And please take a try to format the ID from the item and the sheet to string to see if the Condition could run into if yes branch to run the "Update row" action.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
jannet 26 on at

Like (0)

Report

@v-alzhan-msft & @ScottShearer

The flow does run. However, when the flow running the condition on if the sharepoint ID is equal to google sheet ID. It is returning false and there isn't any dup. ids.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @jannet ,

If the Condition always run into the if no branch of the condition, please make sure that you have save the ID of the item to the ID column in your sheet when create new row to the sheet.

And please take a try to format the ID from the item and the sheet to string to see if the Condition could run into if yes branch to run the "Update row" action.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No