Answered

Updating records on a Sharepoint list using Patch

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone.

I am developing an app around collecting information on some areas where the internet isn't avaliable and update them in a sharepoint list.

I have been able to successfully store the form's information with the function Collect and after that displaying it. I am also capable sending some part of it using this:

Saving

If(Connection.Connected; SubmitForm(EditForm1); Collect(arrTemp; {tempNome: DataCardValue27.Text; tempLigacao: DataCardValue28.Text; tempHD: DataCardValue30.Text; tempLeitura: DataCardValue21.Text; tempOcoInf: DataCardValue6.Selected.Value; tempOcoImp: DataCardValue6.Selected.Value; tempObs: DataCardValue22.Text; TempFoto: DataCardValue23.SelectedItems; TempAnexo: DataCardValue24.Attachments}));; Back()

Updating

ForAll(arrTemp; Patch(LeiturasND; LookUp(LeiturasND; Title = tempLigacao); {LEITURA: tempLeitura; OBSERVAÇÃO: tempObs}));; Clear(arrTemp)

Altough, I'd like to also update other fields, like "Ocorrência Impeditiva", "Ocorrência Informativa", "Foto" and "Anexos", but they are in a diferent format (the three first ones are Choice Columns on my Sharepoint List -single choice- and Anexos is the Attachment).

How can I do that properly?

Screenshot for reference:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

You might want to consider an alternate approach to this. You cannot patch attachments to SharePoint currently, so there will be no way to patch those outside of the form.

Unfortunately if you are going to connected/disconnected apps, you either have to avoid the form, or at least not have a need for attachments.

An alternate approach that we use often is to, first not use attachments and instead a document library to hold the documents, then utilize PowerAutomate when connected to send the information to a flow and have the flow sort out the details of getting the file in the right place.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hey there, Randy.

Since that function is not currently available, I'll most likely try the approach you mentioned. For that to happen, I'll have to look up for some basics around PowerAutomate, 'cause I'm not really familiar with it.

Anyway, thanks for the lead!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Yes, there is plenty of material to view and read for uploading through PowerAutomate. In general, it will be a good learning experience and a pretty easy flow to create (really only two actions needed in the flow). If you get more fancy, then it can grow, but for simple...it should be fairly easy to achieve.

AND, of course, if you ever have any questions, just post on this forum and there are plenty of minds to help.

Was this reply helpful? Yes No
SteveBoling 31 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @Anonymous, I was struggling with a lookup patch to SharePoint but this thread helped.

Was this reply helpful? Yes No