uploading collection contents online

[AOZ]

Dear all,
I have to upload the images (and also some form values) into sharepoint.
The ColItemsToKeep are correctly synchronised to the sharepoint list. Even if i have 2 records in the collection, sharepoint is correctly updated with 2 records.

However for the ColImage, sharepoint is updating my site with only the last record.
Both collections however contains all records and photos.

The above are used only when working offline. Items are saved in 2 collections and then via power automate, the items are synchronised to list and sharepoint site.
When online, everything works fine - all records and images are correctly created.

Here is the code:

ForAll(ColItemsToKeep,Patch('Take5 V1',Defaults('Take5 V1'),
{
Title: Order_No,
Covid_Choice: Covid_Choice,
Je_Respecte_Les_Regles: Je_Respecte,
EPI_ND: EPI_ND,
Je_Dois_Acceder_a_la_Machine: Acces_cabine,
'Sanitize Cabin': Sanitize_cabin,
'Sanitize Keys': Sanitize_Keys,
'Air Vehicle': Sanitize_vehicle,
'Sanitize Knobs': Sanitize_knobs,
'Sanitize Interior': Sanitize_int_ext,
'Sanitize all other': Sanitize_others,

Compétences: Compétences,
Manuels_Techniques: Manuels_Techniques,
Instructions: Instructions,
Outils: Outils,
EPI_Pas_Disponible: EPI_Pas_Dispo,
Sortie_De_Secours: Sortie_secours,
Places: Places,
Environnement_pas_securisé: Environnement,
Machine_pas_propre: Machine_pas_propre,
Autres_Moyens: Autres,

'Des Machines': Des_Machines,
'Dautres Personnes': Dautres_Personnes,
'De lElectricité': De_Lelectricite,
'Des Bruits': Des_Bruits,
'Des charges lourdes': Des_charges,
'Des Produits Chimiques': Produits_chimiques,
'Des Véhicules': des_vehicules,
'La Hauteur': la_hauteur,
'Autre(s) Risque(s)': Autres_risques,

'I Plan': Je_Planifie,
I_Plan_Comments: Je_Planifie_Comment,

SAFE: Je_Realise,
'General Comments': Autres_Commentaires
}
));

ForAll(ColImage,
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3.Text,DataCardValue36.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_1.Text,DataCardValue36_1.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_2.Text,DataCardValue36_2.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_3.Text,DataCardValue36_3.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_4.Text,DataCardValue36_4.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_5.Text,DataCardValue36_5.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_6.Text,DataCardValue36_6.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_7.Text,DataCardValue36_7.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_8.Text,DataCardValue36_8.Image),false);
If(Label8.Text= "Connected",UploadaphototoSharePointfromPowerApps_1.Run(TextInput3_9.Text,DataCardValue36_9.Image),false);
)

[AOZ]

@RandyHayes 

The images do not need to be linked to the list - they just need to be uploaded in a library.

To be able to know which images are related to which "service order" (which is inserted in the form), i concatenate the Order number and the checkbox name section. 

The flow then copies the file in the library like this:

[RandyHayes]

@AOZ 

Okay. So you're using the name as the identifier to the service order.  You can, if you ever want, also have this in a column of the library also.

We're getting there!  Now, an additional question on your screen.  You have what appears like a Title, a toggle, a TextInput and two images.

I assume that the Title is something like the section of the image that you are getting.  The Toggle determines if it should be included, and the TextInput has the Default formula set to something that puts the name together with the service order and the "section".

I am assuming that you have a pre-set amount of "sections" - "Instructions", "Manuels Tech", "Sortie Sec", etc...if so, what is that "section" list of titles?

Am I in the right ballpark?

[AOZ]

@RandyHayes 

Yes we are getting at it.

It's exactly as you described.

In fact i have around 12 toggles and only some of them need to be activated - when one is activated, then the camera appears and it allows the user to take a photo and this photo is stored in the box next to the camera.

Same thing for the other toggles. You don't worry about the other toggles and section...if one or 2 toggles work, i will be able to make it for the others.

However, i may be repeating myself, but for some toggles, the image box still contains the old images (maybe taken some hours back) - and this toggle is not activated by the user...so he does not see that there is a previous image inside...

I just need a way to "reset" all image boxes when the form loads...or even a button which does that.

I saw below which is similar to what i am looking for.

https://www.powerappsug.com/communities/community-home/digestviewer/viewthread?GroupId=2243&MessageK...

[RandyHayes]

@AOZ 

Yeah, we're getting to the resetting.  But first, let's get you a cleaner way to go about this that will make your app much easier to maintain and is more "PowerApp like".

In that better scenario, we will make one toggle/image combination work and it will then work for everything.

So, again, what is that "section" list of titles for each image?

[AOZ]

@RandyHayes 

OK chef 🙂

Here is the list of sections:

• Competences
• Manuels_Tech
• Instructions
• Outils
• EPI
• Sortie_Sec
• Places
• Env
• machine_prop
• Autres

[RandyHayes]

@AOZ 

Perfect!!

Now (sorry should have asked this early on) - you are using a camera control for your items.  Have you considered using the Add Media control instead?  I mention this because for field techs, we have found in the many times we have done this, that they prefer the add media option instead of the camera control.  Primary reason is that they may have taken a picture with the regular phone camera and it is in their picture gallery of the phone.  They don't want to go back to take another picture through the camera control.  Using the Add media control gives them the option to either use the camera to take the photo or use one that they might have already taken that is in the photo gallery.

Is this something to consider for you?  OR, is it perhaps that you ARE already using this and just referring to it as a camera control?

Also, you have two images in each section - what is the purpose of the two images?  I'm a little confused as to what you have going on with the images, camera control and the toggle.  Can you explain that a little more?

[AOZ]

@RandyHayes 

I already have the add attachment in case they wish to add photos from their mobile gallery.

Else, they will all use the camera to take photos when on site.

The left side image is the live camera...the right one is the image captured when i click on the live image.

The toggle indicates that maybe there is a problem on site and so, a photo needs to be taken.

When there is no problem, all the toggles will remain green.

[RandyHayes]

@AOZ 

Yes, the attachment control is going to be something completely different - it will not go into the library.  In this case I am referring more to having the Add Media (which on a mobile device is BOTH camera and upload) in the list of photos you need.

But, you've now mentioned something new...you are "pre-setting" the toggles.  What are you using to do that?

Yes, I had assumed that there was live cam and snap image.  Just wanted to be clear on it.

Still - nice pen! 😂

[AOZ]

@RandyHayes 

Am using the default property to set it to True or false...

P.s: I know you like the pen 😁

[RandyHayes · Accepted solution]

@AOZ 

It's a classy pen!! 😁

Yes, I know you would use the Default to set it, but where is the fact that it is true or false coming from?  This would imply that there is some record of information that it is getting that from.

So without knowing that bit of information, I will proceed with some options for you.

Keeping the Camera control option.

1 - Place a blank Flexible Height Gallery on your screen.

2 - Set the Items property to:

Table(
    {Name:"Competences", Missing:true},
    {Name:"Manuels_Tech", Missing:false},
    {Name:"Instructions", Missing:false},
    {Name:"Outils", Missing:true},
    {Name:"EPI", Missing:false},
    {Name:"Sortie_Sec", Missing:false},
    {Name:"Places", Missing:false},
    {Name:"Env", Missing:false},
    {Name:"machine_prop", Missing:false},
    {Name:"Autres", Missing:false}
)

Again, not clear how you get the true or false for if it is missing, but we would just need to substitute that into the above.

3 - Add a Label (lblTitle) to the Gallery and set its Text property to: ThisItem.Name

4 - Add a Toggle (tglMissing) to the Gallery and set its Default to : ThisItem.Missing  also adjust true and false text as well as colors as desired.

5 - Add a Label (lblFileName) to the gallery and set the:

    Text property to : yourForm.Updates.serviceOrderColumn & "-" & ThisItem.Name

    Visible property to: tglMissing.Value

6 - Add a Camera control (camImage) to the Gallery.  Set the OnSelect action formula to:

If(ThisItem.Name in ColImage.Name,
   UpdateIf(ColImage, Name=ThisItem.Name && SO=yourForm.Updates.ServiceOrderColumn, {File:Self.Photo}),
   Collect(ColImage, {Name:ThisItem.Name, SO:yourForm.Updates.ServiceOrderColumn, File: Self.Photo})
)

Set the Visible property to : tglMissing.Value

7 - Add an Image control (imgCapture) to the Gallery. 

   Set the Image property to:    

        LookUp(ColImage, Name=ThisItem.Name &&  SO=yourForm.Updates.ServiceOrderColumn, File)

   Set the Visible property to : tglMissing.Value

That is it...you now will have a functioning gallery where you can take photos as you were before, but now, you have only 6 controls and all the rest will build itself.

Now...back to where you submit this when connected...

Your formula would be:   

If(Label8.Text="Connected",
    ForAll(ColImage,
        UploadaphototoSharePointfromPowerApps_1.Run(Name,File));        
    );
    Clear(ColImage)
)

This should give you what you are looking for.  Hopefully I have not left anything out.  Here is what it looks like in action.

Now, if you find that you want to switch it to the AddMedia control it can be done easily as well.  You would just be utilizing the OnChange action of that control to put the image into the collection.