web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to bring columns, ...
Power Automate
Unanswered

How to bring columns, and which datatype should i pick?

(0) ShareShare
ReportReport
Posted on by 9

Hi , i have few flows running,  which moves data from sharepoint lists to sql, i have imported all the data into sql using those flows, unfortunately i missed out few columns that need to be in sql from sharepoint,  how can i update my sql rows with the new column 
i have a primary key in sharepoint and sql - (sqlid ) , can i map this and create a flow to bring the new column data? if yes which flow should i use.

second part , on my sharepoint list i have a column called activity startdate which is datetime, but unfortunately when i tried samedatatype on sql , it is returining me an error , do you know which datatype do i need to use to extractdatetime from sharepoint to sql

Categories:
I have the same question (0)
  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @GMkk1 ,Try the Update row (V2) action providing Primary key.

    Follow this

    Using SQL server update rows action with uniqueidentifier as a primary key - Microsoft Q&A

     

    Try converting SP date to UTC

    convertToUtc(items('Apply_to_each')?['Created'], 'GMT Standard Time')

     

  • GMkk1 Profile Picture
    9 on at

    Hi, Thanks for your response, when i tried to update the rows it is throwing me an error 

    GMkk1_0-1712137575036.png

    not sure if my flow is right or wrong, could you please help me to get this 

    GMkk1_1-1712137763800.png

    id is my primary key, where id in sharepoint = id in sql 

    Time is working for me , i appreciate that 

  • GMkk1 Profile Picture
    9 on at

    I'm so sorry, thats my fault, i checked my primary keys that's the issue.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard