{"id":6718,"date":"2021-05-10T09:41:18","date_gmt":"2021-05-10T09:41:18","guid":{"rendered":"https:\/\/softreetechnology.com\/?p=6718"},"modified":"2021-05-10T09:41:20","modified_gmt":"2021-05-10T09:41:20","slug":"create-power-apps-login-screen-using-credentials-from-sharepoint-list","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/","title":{"rendered":"Create power apps login screen using credentials from SharePoint list"},"content":{"rendered":"\n<p>In our blog, we will be going to retrieve user name and password from SharePoint lists and using that credential; we will login and navigate to the welcome screen.<\/p>\n\n\n\n<p>Steps to Create Login Screen<\/p>\n\n\n\n<p>Step 1: Create a custom list having fields with user name and user password as shown in<\/p>\n\n\n\n<p>Below image.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"462\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png\" alt=\"\" class=\"wp-image-6719\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri1.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri1-300x213.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri1-324x230.png 324w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri1-570x405.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Step 2: Login to the power app\u2019s window through \u201c<a href=\"https:\/\/make.powerapps.com\/\">https:\/\/make.powerapps.com\/<\/a>\u201d . Create new Canvas app from blank with any layout either Tablet or Phone layout.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"410\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri2.png\" alt=\"\" class=\"wp-image-6720\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri2.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri2-300x189.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri2-365x230.png 365w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri2-570x360.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Step 3: Add two screens. One for Login another for Welcome screens.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"457\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri3.png\" alt=\"\" class=\"wp-image-6721\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri3.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri3-300x211.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri3-327x230.png 327w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri3-570x401.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Step 4: Login Screen is used for submitting a user name and password from a SharePoint list.<\/p>\n\n\n\n<p>Add three labels (to display window title, user name and password), two text inputs (to hold user name and password) and a button to login as showing in below image.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"450\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri4.png\" alt=\"\" class=\"wp-image-6722\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri4.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri4-300x208.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri4-332x230.png 332w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri4-570x395.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Step 5: On the Welcome screen, just add a label which will display a success message if user name and password is from SharePoint list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"936\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri5.png\" alt=\"\" class=\"wp-image-6723\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri5.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri5-208x300.png 208w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri5-160x230.png 160w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri5-514x740.png 514w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Step 6: Add SharePoint list as SharePoint data source. Add it through a View tab -> Data sources -> Search SharePoint -> Add a new or existing connection -> select your specific SharePoint Site -> Choose the specific list (User Credentials) -> Click on Connect button&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"1024\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri6-499x1024.png\" alt=\"\" class=\"wp-image-6724\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri6-499x1024.png 499w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri6-146x300.png 146w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri6-112x230.png 112w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri6-361x740.png 361w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri6.png 650w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/figure>\n\n\n\n<p>Step 7: Now click on \u201cLogin\u201d button. On it\u2019s select button add the below code.<\/p>\n\n\n\n<p>If (Count Rows (Filter (&#8216;User Credentials\u2019, and (txtUserName.Text = User_x0020_Name,<\/p>\n\n\n\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 txtUserPassword.Text = User_x0020_Password)))=1,Navigate(&#8216;Welcome Screen\u2019, None),Notify(&#8220;Invalid Login Details\u201d, Error));Reset(txtUserName);Reset(txtUserPassword);<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"115\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri7.png\" alt=\"\" class=\"wp-image-6725\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri7.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri7-300x53.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri7-410x73.png 410w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri7-570x101.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Step 8: Now save and test with pressing \u201cF5\u201d. Give user name and password from SharePoint list it will navigate to welcome screen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"605\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri8.png\" alt=\"\" class=\"wp-image-6726\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri8.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri8-300x279.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri8-247x230.png 247w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri8-570x531.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"464\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri9.png\" alt=\"\" class=\"wp-image-6727\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri9.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri9-300x214.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri9-322x230.png 322w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri9-570x407.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>If we add any other user name and password that is not present in the list it will notify error on log in screen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"393\" src=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri10.png\" alt=\"\" class=\"wp-image-6728\" srcset=\"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri10.png 650w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri10-300x181.png 300w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri10-380x230.png 380w, https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2021\/05\/pri10-570x345.png 570w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p>Keywords:<\/p>\n\n\n\n<p>1. Develop Login screen using power apps<\/p>\n\n\n\n<p>2. Create a canvas power app login form<\/p>\n\n\n\n<p>3. How to create login screen in PowerApps<\/p>\n\n\n\n<p>4. Create power apps login screen using credentials from SharePoint list<\/p>\n\n\n\n<p>5. How to create login screen in Power Apps using SharePoint list<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our blog, we will be going to retrieve user name and password from SharePoint lists and using that credential; we will login and navigate to the welcome screen. Steps to Create Login Screen Step 1: Create a custom list having fields with user name and user password as shown in Below image. Step 2: Login to the power app\u2019s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-6718","post","type-post","status-publish","format-standard","hentry","category-sharepoint"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create power apps login screen using credentials from SharePoint list - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create power apps login screen using credentials from SharePoint list - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"In our blog, we will be going to retrieve user name and password from SharePoint lists and using that credential; we will login and navigate to the welcome screen. Steps to Create Login Screen Step 1: Create a custom list having fields with user name and user password as shown in Below image. Step 2: Login to the power app\u2019s [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-10T09:41:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-10T09:41:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create power apps login screen using credentials from SharePoint list - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/","og_locale":"en_US","og_type":"article","og_title":"Create power apps login screen using credentials from SharePoint list - Softree Technology","og_description":"In our blog, we will be going to retrieve user name and password from SharePoint lists and using that credential; we will login and navigate to the welcome screen. Steps to Create Login Screen Step 1: Create a custom list having fields with user name and user password as shown in Below image. Step 2: Login to the power app\u2019s [&hellip;]","og_url":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/","og_site_name":"Softree Technology","article_published_time":"2021-05-10T09:41:18+00:00","article_modified_time":"2021-05-10T09:41:20+00:00","og_image":[{"url":"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Create power apps login screen using credentials from SharePoint list","datePublished":"2021-05-10T09:41:18+00:00","dateModified":"2021-05-10T09:41:20+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/"},"wordCount":348,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png","articleSection":["SharePoint"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/","url":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/","name":"Create power apps login screen using credentials from SharePoint list - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#primaryimage"},"thumbnailUrl":"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png","datePublished":"2021-05-10T09:41:18+00:00","dateModified":"2021-05-10T09:41:20+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#primaryimage","url":"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png","contentUrl":"https:\/\/softreetechnology.com\/wp-content\/uploads\/2021\/05\/pri1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/sharepoint\/create-power-apps-login-screen-using-credentials-from-sharepoint-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Create power apps login screen using credentials from SharePoint list"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6718","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=6718"}],"version-history":[{"count":1,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6718\/revisions"}],"predecessor-version":[{"id":6729,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6718\/revisions\/6729"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=6718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=6718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=6718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}