Adding properties to a file in Sharepoint

(0) Share

Report

Posted on by CU14081108-3

I have created a canvas app in Power Apps based on Dataverse tables.

In the app it is possible to upload a file from the desktop to Sharepoint using Power Automate.

However - now I would like to add some properties to the file saved in Sharepoint (a reference to find the files relatede to a certain group).

On a "upload"-button in Power Apps I have this code in "onselect":

-------------
ForAll(
    DataCardValue226.Attachments;
    Upload_Produkt_Bilag.Run(
        {
            file: {
                contentBytes: ThisRecord.Value;
                name: ThisRecord.Name
            }
        }
    )
)
-------------

What should I do to paste eg. the value from gallery1.selected.productnumber in the column with the red circle?

I have tried several solutions, but none of them works for me... (it still loads the file to Sharepoint, but the "productnumber is not loaded to the column)

wkr Jørgen

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Infamous_Let 330 on at

Like (0)

Report
In Power Automate, open your flow (Upload_Produkt_Bilag) and in the Power Apps trigger, add a new Text input—call it something like ProductNumber. Then, after your "Create file" step, add an "Update file properties" action. Use the ID of the created file, and in the properties, map your custom SharePoint column to the ProductNumber input.

Back in Power Apps, just tweak your formula like this:

ForAll( DataCardValue226.Attachments, Upload_Produkt_Bilag.Run( { file: { contentBytes: ThisRecord.Value, name: ThisRecord.Name } }, Gallery1.Selected.ProductNumber ) )

This way, Power Apps sends the product number along with the file, and Power Automate updates the metadata in SharePoint.

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 3,893 Super User 2025 Season 2 on at

Like (0)

Report
In Power Automate—Edit your flow

Open your flow (Upload_Produkt_Bilag).

Step A: Receive file and metadata

Right now you are only passing:

{ file: { contentBytes: ..., name: ... } }

You also want to pass the ProduktNummer.

Add an extra input parameter in your flow:

ProduktNummer (Text)

Step B: Create File

Keep your Create File action as you have it:

Folder Path: where you save the file

File Name: name

File Content: contentBytes

After this action, you get an Identifier or ItemId output.

Step C: Update File Properties

Add a new action:

SharePoint – Update file properties

Site Address: same site

Library Name: same library

Id:

Use Identifier from Create File (dynamic content)

ProduktNummer:

Use the ProduktNummer input parameter you just added

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
CU14081108-3 14 on at

Like (0)

Report

I have now added this parameter to my flow:

I have added this action (update file properties):

In the app I have added this yellow part to the onselect...

As you can see there is something wrong... But what is it...? (it works fine, when testing the flow in Power Automate, so it must be something with in the command...

Wkr Jørgen

Was this reply helpful? Yes No