Answered

how to check wether sql table has no rows in flow

(0) Share

Report

Posted on by Tejaswini1234

150

i have sharepoint list which i want to move from sharepoint to azure sql table , and want to check first wether sql table is empty or not

Categories:

General topics

All responses (5)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tejaswini1234

You can execute a query -> Select * from tableName and then this will result in a list of items. You can check the length of this list and if it is 0 (empty DB) then configure the next actions of the flow.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Tejaswini1234 ,

Take Sql server as an example to show how to determine whether sql table is empty.

Azure sql will return value, return all rows as an array, you could put value in the array variable.

Then use length() function to determine if the array variable is empty. If the result is equal to 0, the table is empty.

Like:

Hope it helps.

Best Regards,
Tejaswini1234 150 on at

Like
a
(0)

Report
Copy link

Link copied!

How to insert ,update and delete record in sql table as if it performend in sharepoint list using flow.
Tejaswini1234 150 on at

Like
a
(0)

Report
Copy link

Link copied!
Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tejaswini1234 ,

Please check this thread and see if it helps:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/how-to-do-modification-insertion-and-deletion-in-SQL-table-if-it/m-p/315480

Best Regards,