Unanswered

Please help! - Comparing JSON rows with SharePoint List rows

(0) Share

Report

Posted on by Lee5150

Hi all,

I'm fairly new to PA and I'm having trouble creating a flow I need at work. It seems like a very simple process but I can't make it work.

All I need is PA to query a PBI dataset (Done), pull a SP list (Done), compare the two, remove rows that haven't changed, to give me a reduced size array that I will use to update the SP list with.

I had the flow working perfectly with just pulling info from PBI and updating relevant rows in the SP list, but the SP list is growing and growing. There are around 1300 rows and the flow times out before it completes. There may only be 10 rows that have updated since I last ran the flow but running the original flow will assess all 1300 rows every time.

I'm sure there's a simple way of doing this, I just can't figure it out!

Many thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

When you pull the SP list you can add an ODATA filter query (for example on the last modified date). You can also specify a (simpler) to pull fewer columns.

Was this reply helpful? Yes No
Lee5150 21 on at

Like (0)

Report

Thanks for your help. The SP list doesn’t get modified though. It’s the PBI data that does. I just need this to sync with sharepoint and display in a list.
Can I do something similar to the filter with the PBI data?

thanks

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

Like (0)

Report

Yes, in your DAX query you can use relative date filters too.

Was this reply helpful? Yes No