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:
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