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

All responses (3)

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Lee5150 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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