Patching after upload on SharePoint Library

(0) Share

Report

Posted on by Jmnavi

Hello

I have an App where the users have to upload one or more files in a Sharepoint Library after checking and commented it.

All info related to the file shall be patched on this library after uploading the files. The info shall be the same for all files uploaded at the same time.

I'm using the following formula to upload and path the info of the uploaded doc:

ForAll(
 Attacher.Attachments;
 UploadSharepointFlujo2.Run(
 {
 file: {
 contentBytes: Value;
 name: Name
 }
 }
 )
);;
Set(
 LastItem;
 First(
 Sort(
 '001 - Flujo de aprobación';
 ID;
 SortOrder.Descending
 )
 )
);;
Patch(
 '001 - Flujo de aprobación';
 LookUp(
 '001 - Flujo de aprobación';
 ID = LastItem.ID
 );
 {
 Revisión: {Value: Label1_130};
 'Situación del flujo': "CONTESTADA"
 }
)

So far, so good. It works. However I have some questions which I'd appreciate if someone can help me.

1 - I have an additional column on this library that must be patched as well but this column is a lookup from a SharePoint list. I tried some tutorials posted here but it didn't work.

2 - I'm not sure if using the formula above, in case some user upload more than one file, it will patch all the lines corresponding to the files since it uses the last ID to patch.

Thanks in advance.

Rgds,

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jmnavi ,

A bit hard to answer without seeing your Flow - you are sending a number of attachment files off to (I assume) a SharePoint Library with a file created for each. You are probably better sending the required data as additional parameter/s and then using Update file properties in the Flow to write it to the relevant record/s.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Jmnavi 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Thanks for your reply.
Idea is the following:
On the App, the user looks for one commented file with status open and click to check its main data. Then he has the alternative to upload a file to answer for the comments. As long, it upload the file, it shall patch all info of this file in the new uploaded file. Please see the prints below:
Screen to select the file:
Screen to upload the file
I must patch all the values found on DATOS DEL DOCUMENTO (Main data) in the recent uploaded file because they must have the same data of the chosen file. In other words, this upload have information to clear or reponde to the comments made on the chosen file.
However, the first one, Codigo del documento is a lookup column on my library. The values come from other list and this one I'm not suceeding to patch.
Regarding your observation regarding my flow, it has a Updated File Properties Action. I'm not too much familiar to Power Automate but I'm not sure those specific value of the lookup column can be set according to the file selected on App. I'm pasting my flow as well here.
So, that's it.
Last but not least, the information about uploading more than one file is no longer being requeted. The files are going to be upload one by one.
Jmnavi 51 on at

Like
a
(0)

Report
Copy link

Link copied!

hI @WarrenBelz ,

Just to update, I think I was over complicating because I'd like to have one sharepoint library full of dependencies and option fields. But since the purpose of this app is not let the people work on sharepoint I don't see any reason for that sharepoint configuration. So, I turned it much simplier since I get the records from a list and just patch as text where I need. Thank anyway for your reply!!