Hi,
I have the formula to update a text and photo to Sharepoint.
I can choose if I would like to update a text, a photo, or a text with a photo. If I update the text, everything is ok. If I update a photo, nothing happens. If I update a text and a photo at the same time, both text and photo do not upload to SharePoint.
The photo is stored in my collection called 'Photos'.
Here is my code on the button select:
If(ValFlygtBalls = 1, Patch(Main,First(Filter(Main, Title = ValFacility.Title)), {FInstall: "DONE BY " & ValName & " - " & TextInput1.Text, FInstallPic: First(Photos).Url}),
If(ValFlygtBalls = 2, Patch(Main,First(Filter(Main, Title = ValFacility.Title)), {FRaiseOrLower: "DONE BY " & ValName & " - " & TextInput1.Text, FInstallPic: First(Photos).Url}),
If(ValFlygtBalls = 3, Patch(Main,First(Filter(Main, Title = ValFacility.Title)), {FModify: "DONE BY " & ValName & " - " & TextInput1.Text, FInstallPic: First(Photos).Url}),
If(ValFlygtBalls = 4, Patch(Main,First(Filter(Main, Title = ValFacility.Title)), {FInstallIS: "DONE BY " & ValName & " - " & TextInput1.Text, FInstallPic: First(Photos).Url}),
If(ValFlygtBalls = 5, Patch(Main,First(Filter(Main, Title = ValFacility.Title)), {FFixIS: "DONE BY " & ValName & " - " & TextInput1.Text, FlygtBalls: "DONE", FInstallPic: First(Photos).Url}))))));
Reset(TextInput1);
UpdateContext({ValFlygtBalls: ValFlygtBalls + 1});
If(ValFlygtBalls = 6, Navigate(SuccessfulSubmit,ScreenTransition.Cover,{ValFacility:ValFacility, ValSubmit: "FlygtBalls", ValName: ValName}));
My SharePoint database is attached. Every column with 'Pic' in name is marked as a picture in SharePoint.
Thank you for your time!
