Update Item Share point list from powerBI query

(1) Share

Report

Posted on by marcomizz

Hello Team

I would like to update same column value of my share point list using power bi report.

I added two step in my flow, The first one is running a query against a dataset and the second one just to Parse Json

now I try to add step "update ITEM share point list " but in the dynamic content I dont see the step before "Parse Json"

How Should I determine the ID number to be used in order to update the columns?

kind regards

marco

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

In order to do what you want to do, the data set query would need to contain the ID value of the item in SharePoint you want to update. You would then use this value in the Id field. Depending on how this is stored in your data, you might need to convert the value to an integer first. Otherwise, you need to establish some type of relationship between your dataset and SharePoint to update the item.

Was this reply helpful? Yes No
marcomizz 25 on at

Like (0)

Report

The data set query contain the ID, it's and integer Number. I dont know How to select the valute id in the field ID in the step "update item". If i select the step "create item" I able to link the field with the value ID coming from the "parse JSON" why in the step "update item" is not possibile?

Was this reply helpful? Yes No
marcomizz 25 on at

Like (0)

Report

Hello,

I add this step to my flow:

with the first apply to each step I select the body of the previpus step "Parse JSON", the second one Apply to each step is selecting the unique sharepoint list "ID", the last one step is to update the list items selecting the ID number

of course the step fail, here the error message:

someone can guide me how to solve this problem?

thanks

marco

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

No need to "Parse JSON". Examine the payload that came back from Power BI. Iterate over "First Table Rows". Grab the ID column from your item() object.

Was this reply helpful? Yes No