{"id":315,"date":"2021-03-25T11:01:21","date_gmt":"2021-03-25T11:01:21","guid":{"rendered":"http:\/\/4us2use.at\/?p=315"},"modified":"2021-03-25T11:03:27","modified_gmt":"2021-03-25T11:03:27","slug":"copy-paste-from-excel-into-canvas-power-app","status":"publish","type":"post","link":"http:\/\/4us2use.at\/?p=315","title":{"rendered":"Copy & Paste from Excel into Canvas Power App"},"content":{"rendered":"\n

Problem:<\/strong><\/p>\n\n\n\n

Power App doesn’t provide functionality to just paste copied content from Excel into a table or a gallery. But it’s annoying people, if they have to type all the values from a calculated Excel file 1:1 into the Power App.
So I found a workaround, that people can just copy & paste values from a standardized table, with which values they need to start an approval workflow for many times.<\/p>\n\n\n\n

Solution:<\/strong><\/p>\n\n\n\n

First we create a simple input form on Power App, containing a Text Input field, a table and a button. In my demo I use a SharePoint list as data source. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Then create a Flow with a Power App trigger.
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Link the button to the Flow and pass in the text value.<\/p>\n\n\n\n

Collection of formulas for you to copy:<\/strong><\/p>\n\n\n\n

Formula for the button:
\nYOURFLOWNAME’.Run(TextInput1.Text);Refresh(YOURDATASOURCE)<\/p>\n\n\n\n

Expression to get the rows:
split(decodeUriComponent(replace(replace(uriComponent(variables(‘strRawTxtInput’)),’%09′,”),’%0A’,’#NEWLINE#’)),’#NEWLINE#’)<\/p>\n\n\n\n

Expression to get the columns:
split(decodeUriComponent(replace(uriComponent(items(‘ForEachRow’)),’%09′,’#TAB#’)),’#TAB#’)<\/p>\n\n\n\n

Have fun \ud83d\ude09


\"1\"2\"3\"4\"5 (2<\/strong> votes, average: 3.50<\/strong> out of 5)
<\/span><\/span>Loading...<\/span> <\/p>\n","protected":false},"excerpt":{"rendered":"

Problem: Power App doesn’t provide functionality to just paste copied content from Excel into a table or a gallery. But it’s annoying people, if they have to type all the values from a calculated Excel file 1:1 into the Power App.So I found a workaround, that people can just copy & paste values from a … <\/p>\n

Continue reading “Copy & Paste from Excel into Canvas Power App”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11,6],"tags":[],"_links":{"self":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/315"}],"collection":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=315"}],"version-history":[{"count":3,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/315\/revisions"}],"predecessor-version":[{"id":321,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/315\/revisions\/321"}],"wp:attachment":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}