Answered

Power App to Sharepoint

(0) Share

Report

Posted on by JaredB

I am really confused here, I have built an IT requirements App where users input the information for onboarding after filling in all fields they input an email address and click submit and the information from the fields in the app are copied and sent to the email address the user inputs. I want to create and approval flow and see that I need to store the information from the app in SharePoint. This is great for two reasons one it will show a record of what each user has been given hardware and software wise so when a user leaves I can reference this list and determine everything that the user had access to and what hardware I should expect back. The second reason is then I can build the approval flow so that the appropriate people are notified and can approve/deny the request. The problem that Im having right now is that I'v built the app, iv built the share point list and have all of my fields in the last match what is in the app, I have connected the app to the sharepoint list, however when I submit from the app the email still sends but no information is being passed to the sharepoint list. What am I doing wrong? Below is the code i'm use and a snapshot of the sharepoint list.

Office365Outlook.SendEmailV2(
HS_txtinp_Email.Text,
"IT Requirements Request",
"<h1 style=font-size:20px;>Employee Information</h1>" &
"Employee Name: " & HS_txtinp_EmployeeName.Text &
" Department: " & HS_txtinp_Department.Text &
" Job Title: " & HS_txtinp_JobTitle.Text &
" Start Date: " & HS_dp_StartDate &
" Cost Center: " & HS_dd_CostCenter.Selected.Value &
" Location: " & HS_dd_Location.Selected.Value &
" " &
"<h1 style=font-size:20px;>Equipment</h1>" &
If(
!HS_cb_NoEquipmentNeeded.Value,
"Headset: " & HS_dd_Headset.Selected.Value &
" Desktop/Laptop: " & HS_dd_WorkstationSetup.Selected.Value &
" VPN Access: " & HS_dd_VPNAccess.Selected.Value &
" Phone: " & HS_dd_Phone.Selected.Value &
" Keys: " & HS_txtinp_Keys.Text &
" File Share Access: " & IFS_txtinp_FileShareAccess.Text &
" E-Mail Groups: " & IFS_txtinp_EmailGroups.Text &
" Printer Address Books: " & IFS_txtinp_PrinterAddressBooks.Text &
" Additional Requirements: " & IFS_txtinp_AdditonalRequirements.Text
) &
" " &
"<h1 style=font-size:20px;>Applications Access/Licenses</h1>"
& If(HS_CB50.Value, " Option")
& If(HS_CB49.Value, " Option")
& If(HS_CB48.Value, " Option")
& If(HS_CB47.Value, " Option")
& If(HS_CB46.Value, " Option")
& If(HS_CB45.Value, " Option")
& If(HS_CB44.Value, " Option")
& If(HS_CB43.Value, " Option")
& If(HS_CB42.Value, " TrainTrack (Access)")
& If(HS_CB41.Value, " SQL Server Standard Core Edition")
& If(HS_CB40.Value, " Sky Kick")
& If(HS_CB39.Value, " Revitt")
& If(HS_CB38.Value, " Procal")
& If(HS_CB37.Value, " Power Bi")
& If(HS_CB36.Value, " PI")
& If(HS_CB35.Value, " Oanda API Basic")
& If(HS_CB34.Value, " Navisworks")
& If(HS_CB33.Value, " MiniTab")
& If(HS_CB32.Value, " Microsoft Visio")
& If(HS_CB31.Value, " Microsoft Sharepoint")
& If(HS_CB30.Value, " Microsoft Project")
& If(HS_CB29.Value, " Manager Plus")
& If(HS_CB28.Value, " Intranet")
& If(HS_CB27.Value, " ETQ")
& If(HS_CB26.Value, " Empower")
& If(HS_CB25.Value, " DWG Trueview")
& If(HS_CB24.Value, " Docuware")
& If(HS_CB23.Value, " D365")
& If(HS_CB22.Value, " Clarity")
& If(HS_CB21.Value, " Chemstation")
& If(HS_CB20.Value, " Chemdoodle")
& If(HS_CB19.Value, " BloomBerg Fixed Assets")
& If(HS_CB18.Value, " AutoCAD")
& If(HS_CB17.Value, " Atlas")
& If(HS_CB16.Value, " Adobe Pro")
& If(HS_CB15.Value, " Option")
& If(HS_CB14.Value, " Option")
& If(HS_CB13.Value, " Option")
& If(HS_CB12.Value, " LinkedIn")
& If(HS_CB11.Value, " Galaxy")
& If(HS_CB10.Value, " Network Servers")
& If(HS_CB9.Value, " Galaxy")
& If(HS_CB8.Value, " VM Ware")
& If(HS_CB7.Value, " Duo-Access")
& If(HS_CB6.Value, " Ipswitch Whatsup Gold/Netmon")
& If(HS_CB5.Value, " Cisco FirePOWER")
& If(HS_CB4.Value, " Treesize Pro")
& If(HS_CB3.Value, " Checkpoint")
& If(HS_CB2.Value, " Microsoft Visual Studio")
& If(HS_CB1.Value, " Avaya")
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Michael_Scott 106 on at

Like (0)

Report
Copy link

Link copied!

I dont see a Patch statement in this code. You will need to patch or collect your data to your sharepoint list somewhere in the code in order to see it show up in your list.

Patch(ListName, ID = TextInput1.Text && etc, {Data1: "value1", Data2: "value2"});

This will write to table/list called ListName where the ID matches the text field and etc is also satisfied and will overwrite the values in columns Data1, Data2, and Data3 with their respective values. If this item does not exist then it will create a new entry with this data given that you are not missing some required field(s).

Hope this helps!

Was this reply helpful? Yes No
JaredB 71 on at

Like (0)

Report
Copy link

Link copied!

@Michael_Scott Perfect that seems to be carrying the data over now, however when I place it into my existing code its erroring the code out, I tested it on a stand alone button and it seems to work, however when I put it on the button that controls the entire app it doesn't let me put it at the end how do I input this into my code and not break the entire thing.

iv but a comma at the end of the existing code and an & and iv put a ; in there but that breaks the email part.

Was this reply helpful? Yes No
Michael_Scott 106 on at

Like (0)

Report
Copy link

Link copied!

what is the other code on the button and what does the error say? It could be a few issues. for example if you are doing something then navigating afterwards you cant put that code after the navigate call or it will be "unreachable code" essentially and give an error.

In powerapps if you want to do multiple statements you separate them with a ; like this for example...
Reset(TextInput1); Reset(TextInput1_1); Reset(TextInput1_2); etc.

You can also use this in line with other functions like this....
If(statement,Reset(TextInput1); Reset(TextInput1_1); Reset(TextInput1_2); , Reset(TextInput2));

The above statement will execute the first 3 resets if true and the reset for textinput2 if false.

Was this reply helpful? Yes No
JaredB 71 on at

Like (1)

Report
Copy link

Link copied!

@Michael_Scott I ended up figuring it out, it was resetting the form before it emailed so it would send the information from the app to the sharepoint list, then reset the form then grab the blank inform and put it into an email and send that, I removed the reset function of the app and placed it after the email portion of the code and that resolved the issue.

Was this reply helpful? Yes No
Michael_Scott 106 on at

Like (0)

Report
Copy link

Link copied!

If I had $1 for every time I overlooked something like that I would have maaaaany dollars xD glad you got it sorted out!

Was this reply helpful? Yes No