Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Update Row in Google Sheet from Sharepoint List

(0) ShareShare
ReportReport
Posted on by 26

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.PNGUpdate Row 2.PNG

  • Verified answer
    v-alzhan-msft Profile Picture
    on at
    Re: Update Row in Google Sheet from Sharepoint List

    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.

  • jannet Profile Picture
    26 on at
    Re: Update Row in Google Sheet from Sharepoint List

    @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.

     

    Update Row 3.PNG

  • v-alzhan-msft Profile Picture
    on at
    Re: Update Row in Google Sheet from Sharepoint List

    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.

     

  • ScottShearer Profile Picture
    25,208 Most Valuable Professional on at
    Re: Update Row in Google Sheet from Sharepoint List

    @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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,631 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,991 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow