Unanswered

Update sharepoint list item when ID is not known ?

(0) Share

Report

Posted on by DV-20111455-0

Hi everyone,

I’ve build a flow in Power Automate Desktop that automates the process of a send in mail with an invoice, its extracts fields from that invoice and then makes a new item in a sharepoint list filled with the extracted fields and generates a unique ID number. So far so good.
There is a status field in that item which needs to be updated if the invoice is paid for example which happens in another flow, in this flow I have used the ‘get items’ with a filter query ( ordernr eq ‘12345678’ for example ) gives me a GetItemsResponse of a single row with data in return, the row that needs updating.
When I want to update one value of a colum in that row with ‘Update item’ I only need the ID number of that row.
How do I get the ID as a variable to put in here ?

Thanks for your braintime

Danny

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Update sharepoint list item when ID is not known ?

Hi,

if you check the dynamic content of Get Items action - there is ID Dynamic content which can be used in ID field in update item action.

Thanks & Regards,

Nived N

Was this reply helpful? Yes No
DV-20111455-0 4 on at

Like (0)

Report

Update sharepoint list item when ID is not known ?

Hi Nived,

When I check the dynamic contact of te get items response I don't see the different collumn fields as Dynamic content.

Only .value

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Update sharepoint list item when ID is not known ?

Hi @DV-20111455-0

I don't think dynamic content for columns appears in Power Automate desktop as in cloud flows.

If you need to select required column value - you have to write expression like this

%GetItemsResponse['value'][0]['ID']%

The above expression helps to get ID attribute of first list item obtained via get items action.

Hope this helps !

Thanks & Regards,

Nived N

Was this reply helpful? Yes No