Unanswered

Pictures sent SharePoint and Time adjustment

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need to send the pictures from the App to a SharePoint list. I have seen how the URL can be sent and converted, but I have not been able to achieve this.

I also need to know how to adjust the time availability. I will be using the app to set up meetings and I can only setup them up between 8-5. The users who will be working with the app will be working around the clock, so they will need the flexibility.

Here is how I am sending data to SharePoint:

Collect('Mentor Mentee SCDP ',{Title:Text(Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss"),Mentee:Mentee.Text, Mentor:Mentor.Text, Manager:Manager.Text,District:District.Selected.Value, MeetingType: 'Type of Meeting'.Selected.Value, MeetingNumber: 'Meeting Number'.Selected.Value, Notes: Notes.Text,TaskAssignments: 'Task Assignments'.Text});Patch('Mentor Mentee SCDP ',Defaults('Mentor Mentee SCDP '),{Image:First(myPics).pic});

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
///// CAMERA CODE BELOW IS IN THE ON SELECT OF TEH CAMERA //COLLECTS THE IMAGE DATA FOR SHAREPOINT SUBMISSION LATER Collect( SupportImage, { Name: "Example"&examplenumber&".jpg", ContentBytes: MyCamera.Photo, '@odata.type': "", URL:MyCamera.Photo }); UpdateContext({examplenumber:examplenumber+1}); //COLLECTS THE IMAGES TO BE VIEWED IN MY GALLERY ON THE ITEMS SUBMIT PAGE(THIS APP ALLOWS MULTIPLE IMAGES FOR EACH SUBMISSION Collect(LocalImage, MyCamera.Photo) ////////////////////////////////////////////////////////////////////////////////////////////////// /////SUBMIT BUTTON BELOW TAKES THE IMAGES YOU HAVE STORED, PREPARES THEM FOR COLLECTION, THEN SUBMITS THEM TO SHAREPOINT (MY APP DOES IT IN MULTIPLE STEPS FOR A REASON THAT IS SPECIFIC TO THE APP //COMBINES MULTIPLE IMAGES IN CASE THERE ARE MORE THAN ONE RELATED TO THE ITEM Set(imagedump,Concat(SupportImage, URL & "|")); //COLLECTS THE DATA ON THE ITEM, AND ADDS THE PHOTO URL INFO ClearCollect( workorder, { PRIMARY: PRIMARY.Text, SUB1: SUB1.Text, SUB2: SUB2.Text, SUB3: SUB3.Text, DESCRIPTION: DESCRIPTION.Text, DATE:Now(), IMAGES:imagedump }); //PASSES THE COLLECTION ON INTO SHAREPOINT ForAll(workorder,Patch(WorkOrders,{Title:PRIMARY,OData__x0053_UB1:SUB1,OData__x0053_UB2:SUB2,OData__x0053_UB3:SUB3,DESCRIPTION:DESCRIPTION,DATE:DATE,IMAGES:IMAGES,CLOSED:false})) /////////////////////////////////////////////////////////////////////// ///// LATER ON IN THE TOOL USED TO VIEW PREVIOUS SUBMISSIONS I CAN PULL ALL THE DATA ON THE ITEM SELECTED //BELOW IS ATTACHED TO THE SELECTION BUTTON IN A GALLERY OF THE OPEN ITEMS, LAST LINE RETRIEVES, AND SPLITS THE URL INFO FOR ATTACHED IMAGES Select(Parent); Set(hidedate,false); Set(descriptionlookup,ThisItem.DESCRIPTION); Set(lookupselectedarea,ThisItem.Title); Set(lookupsub1,ThisItem.OData__x0053_UB1); Set(lookupsub2,ThisItem.OData__x0053_UB2); Set(lookupsub3,ThisItem.OData__x0053_UB3); Set(lookupworkorder,ThisItem.WORKORDER); Set(lookupdate,ThisItem.DATE); Set(lookupID,ThisItem.ID); ClearCollect(SplitImages,Split(Text(ThisItem.IMAGES),"|")) /////AND THE CODE BELOW IS IN THE IMAGE GALLERY OF PULLED UP ITEM TO DISPLAY THE IMAGES WE PULLED //Gallery Source ITEMS = SplitImages //Insert an image in the gallery and make its items ThisItem.Result
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

In regards to the time set up part, not sure exactly what you are asking.
If you are using your own controls you should be able to put anytime you want into powerapps, and transfer to sharepoint.
If you are using a scheduling based office say the office365users connection, then available hours should automatically be pulled from office based on whichever user is using the app so that should autoadjust to each user
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The time is pulling from my Outlook calendar. I just need to know how to expand the range.
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

To change your O365 availability

Go to Office 365 Portal, then select Outlook
Click on the Calendar symbol to go to the Outlook calendar
Select the Gear to go to your Settings, then Calendar Appearance
From here, you can change the work week and working hours to match your work schedule
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Here is what I have written. The SharePoint list page is 'Mentor Mentee SCDP', I am only using one picture per meeting. how would that be written?

Collect('Mentor Mentee SCDP ',{Title:Text(Now(),"[$-en-US]mm/dd/yyyy hh:mm:ss"),Mentee:Mentee.Text, Mentor:Mentor.Text, Manager:Manager.Text,District:District.Selected.Value, MeetingType: 'Type of Meeting'.Selected.Value, MeetingNumber: 'Meeting Number'.Selected.Value, Notes: Notes.Text,TaskAssignments: 'Task Assignments'.Text});

Set(_emailRecipientString,Concat(MyPeople,Mail&";"));
If(IsEmpty(myPics),
     Office365Outlook.SendEmail(_emailRecipientString,TextEmailSubject1.Text,"Mentee: "&Mentee&"
Mentor: "&Mentor&"
Manager: "&Manager&"
District: " & District.Selected.Value &"
Type of Meeting: "&'Type of Meeting'.Selected.Value&"
Meeting Number: "&'Meeting Number'.Selected.Value&"
Notes:
"&Notes&"
Task Assignments:
"&'Task Assignments'),
       Office365Outlook.SendEmail(_emailRecipientString,TextEmailSubject1.Text,"Mentee: "&Mentee&"
Mentor: "&Mentor&"
Manager: "&Manager&"
District: " &District.Selected.Value &"
Type of Meeting: "&'Type of Meeting'.Selected.Value&"
Meeting Number: "&'Meeting Number'.Selected.Value&"
Notes:
"&Notes&"
Task Assignments:
"&'Task Assignments',{Attachments:Table({Name:"Mentor Picture.jpg",ContentBytes:First(myPics).pic, '@odata.type':""})}));
Clear(myPics);