The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Store data from Power Apps in SQL, approve it in Power Automate and use it in Power BI

In today’s video we will create a Power App that will store stopwords in a SQL table on an on-prem server. The Power App will log the user of the app and a timestamp.

After the stop word is sent to SQL, a flow will be started to approve the new word.

The data will then be imported in Power BI where the words will be excluded from the Word Cloud for test analysis.

A 360 solution for text analytics!

Watch the tutorial:

Store data from Power Apps in SQL, approve it in Power Automate and use it in Power BI

This is the SQL statement used in the video that autogenerate an ID:

CREATE TABLE [dbo].[Stopwords](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Stopword] [nvarchar](150) NULL,
 [Timestamp] [nvarchar](17) NULL,
 [Created by] [nvarchar](150) NULL,
 CONSTRAINT [PK_StopwordsId] PRIMARY KEY CLUSTERED
 ( [Id] ASC )WITH
 (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] 
GO

Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents