Share
Report
21Hi 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
All responses (
Answers (
