Unanswered

Problem with updating an item

(0) Share

Report

Posted on by AndreAlves

Hi all

I'm pretty a beginner in Power Automate. Therefore I hope I can get some advice here.

Here is what I'm trying to do. We have a list with items on sharepoint. Each item of that list gets an automatic 'ID'. Everytime a new item is created, a folder is make with the same name _id_. For example, item '6' is created and automatically a folder is generated with name '6'. Until this part my flow works without any issue by using blocks 'When an item is created' and 'Create new folder'.

Furthermore, in an addtional column of that table I want to add a link to each folder 'ID'. For example, we have item '2' and in the column 'link' we can click to go to that folder. In order to achieve that I'm using the block 'Update Item' and I set the value of the column link with the variable 'full path' that the 'Create new folder block' outputs.

This is the error I'm getting on the last block 'Update Item':

The 'inputs.parameters' of workflow operation 'Atualizar_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/IssueSource' is required to be of type 'String/uri'. The runtime value '"Gedeelde documenten/6"' to be converted doesn't have the expected format 'String/uri'.

I would be grateful if you could help me with this.

Kind regards

André

Categories:

Building flows

flow.png

update item param...

I have the same question (0)

All responses (2)

Answers (0)

v-mengmli-msft on at

Like (0)

Report

Hi @AndreAlves ,

What is the type of LINK column?

If you want to update clicked link to SP list, I recommend you use Hyperlink column.

Here is my test for your reference.

1/Type of column

2/

Use 'Link to item' of Create new folder in Update item.

3/

Result of test.

Best regards,

Rimmon

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@AndreAlves

So you want to create a folder and link from a list item using flow. I think Atualizar_item is Portuguese for Update_Item.

Some of the issuse you are experincing with the ID is that this is a number and not text so that needs fixing first. I would sugest you add a column called folder name and convert the number to text, there is plenty online showing you how to do this. You can do this in the Update_Item. Then go and create_folder. Once the folder is created then get the folder information and populate the link in a further update item. So the flow becomes:

When an Item is created
Update Item
Get items
Create Folder
Get folder
Update Item

But look at the follwing:

https://www.youtube.com/watch?v=oQdilYDUCMk

Please note I have not view the above.

Regards,

Andrew

Was this reply helpful? Yes No