Beginner's Questions: First Day using Power Apps

(0) Share

Report

Posted on by tanthiamhuat

I am first day using Power Apps, and trying to do this simple thing.. with a Power Apps as below"

What I want to achieve is this:

Users will select their inputs (Country, Date, Total Scope1,2,3 Emissions), and press the Save button. Upon each Save button pressed, I want all the above input information to be saved in an Excel file (appended mode or overwrite mode) in a column format, that is Column 1 = Country, Column 2 = Date, Column 3 = Total Scope 1 Emissions, Column 4 = Total Scope 2 Emissions, Column 5 = Total Scope 3 Emissions.

I read from https://www.youtube.com/watch?v=tQCBWMR7T64 it is possible for Tabular data, but I am not sure how do I manipulate it for inputs entered by users from the UI.

If that is possible, the next thing I wish to do is to save those information in Azure Blob Storage or Azure SQL Database, which would be more difficult.

Appreciate it very much.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use power automate. Crete an excel file in Onedrive for Business or Sharepoint and create a table in that file with the needed columns. Start your flow in power apps and send the needed inputs.

For your first action in your flow, you need to parse waht you get from power apps and then add a row to your excel file. Not super, but it does what you want.

PS> Ignore the second Parse, you need only one. I took this from a production flow with different requirements.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tanthiamhuat ,

If the controls you are using are in a Form control, you could use the SubmitForm() function to save data from the Form to the data source.

SubmitForm(Form1)

https://powerusers.microsoft.com/t5/Building-Power-Apps/transferring-data/m-p/1651209#M420925

If the controls you are using are just on the screen, you could use the Patch() function to save data from the input controls to the data source.

Save Button -> OnSelect property:

Patch(datasource,Defaults(datasource), {choicecolumname:{Value:Dropdown1.Selected.Value},datecolumn:DatePicker1.SelectedDate,textcolumn1:TextInput1.Text,textcolumn2:TextInput2.Text,textcolumn3:TextInput3.Text})

https://powerusers.microsoft.com/t5/Building-Power-Apps/Having-Trouble-Patching-Email-Address-to-Excel/m-p/1532962#M395809

Best Regards,
Charlie Choi

Was this reply helpful? Yes No