In today's video we will create a PowerApp that will store stopwords in a SQL table on an on-prem server. The PowerApp will log the user of the app and a timestamp. After the stopword 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! Download pbix file: Frequency count video: SQL statement with key and autogenerate 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 _____________________________________________ Giacomo blog: Want to know more about PowerApps? Follow: @ArtsyPowerApper and @dchristian19 Want to know more about Flow? Follow: @PNWAdventureGuy SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: - Join our DAX Fridays! Series: - Power BI dashboards for beginners: - Power BI Tips & Tricks: - Power Bi and Google Analytics: ABOUT CURBAL: Website: Contact us: QUESTIONS? COMMENTS? SUGESTIONS? You’ll find me here: Twitter: @curbalen, @ruthpozuelo Google +: Facebook:
Video Owner : Curbal
0 Comments