0

I am trying to make a logic app with "Recurrence" triger which get items from SPO list (from view) with condition:

  • if have null values, then pass them some string or boolean (if column is boolean type)

Then get rows from Azure SQL table and compare with data from SPO (above), if there is a match then skip them, if is not a match then add row in Azure SQL with values from SPO item.

Do you have any ideas ?

2 Answers 2

0

I'm thinking you should look at the SharePoint List Webhook

if I read the docs correctly allows you to setup an Azure function or Webjob that triggers on SharePoint List Webhook event corresponding to ListItem changes

1
  • Thanks for suggestion, job is done ! :)
    – jck4real
    Commented Sep 21, 2022 at 9:59
0

Work is done ! With Execute a SQL query (V2) I am getting values from dtb. and with expression from condition length(string(body('Execute_a_SQL_query_(V2)_2')?['resultsets'])) I now if item which I want to add is already in database. With another Execute a SQL query (V2) I can add specific values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.