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

I have the same question (0)

All responses (5)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

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

Like (1)

Report

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,

Was this reply helpful? Yes No
Tejaswini1234 150 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tejaswini1234 150 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No