Unanswered

Only the columns that have been modified please!

(0) Share

Report

Posted on by psadd2

133

Hi, I'm only just getting into using PA in anger, previously I've done some simple flows but this latest one is making my ears bleed...hope you can help.

I am creating a Change Log. I have an SP list and I'm populating another list, same columns etc., whenever a new item is added or and existing item is modified. Neither of these has posed an issue until my client asked, in regards to the modified part, if we could only populate the Change Log columns only where the item has been modified. So essentially I may only want to write one piece of data back to one column in the Log....or I may want to write to multiple columns.

I have a Conditions that looks at [Created]=[Modified] which, if true, takes it down the 'new' item path and writes the lot to the Log. If it's false it takes it down the 'modified' path.....and that's where I can't figure out how to just write the edited bits.

By the way I have 25+ columns in the list.

Any ideas?

Thanks

All responses (4)

Answers (0)

psadd2 133 on at

Like (0)

Report

Re: Only the columns that have been modified please!

Hi...thanks again for the quick response.
Here's a quick screen shot of what I have so far....the left hand route works fine. It pulls back everything as the item is 'new'. The right hand route is the issue. I will take a look at the output again and see if I can work out some IF statement.

Regards
Expiscornovus 32,131 Most Valuable Professional on at

Like (0)

Report

Re: Only the columns that have been modified please!

Hi @psadd2,

That action should give you boolean values which columns actually have changed since the last item/file version. Below is an example output of that action where only my Name column has changed.

Based true flag you should be able to retrieve the correct columns with their updated values. You have to use another action for that. However, with 25 columns that can be a challenge.

I will try and create an example for this.
psadd2 133 on at

Like (0)

Report

Re: Only the columns that have been modified please!

Hi,
Many thanks for the quick response!
Yes, I've tried using this feature and I get what it's trying to do but it seems to identify the item/row has changed and then wants to output the entire line. I can't figure out how to get it to write only those columns that have changed in the item back into my change log.
e.g. If I have a Product line with various pieces of info about the product and the Cost Price is modified I only want the new Cost Price to be written to my Change Log....I don't need the rest of the info.
Thanks
Expiscornovus 32,131 Most Valuable Professional on at

Like (0)

Report

Re: Only the columns that have been modified please!

Hi @psadd2,

Maybe you can try and use the Get changes for an item or a file (properties only) action

https://docs.microsoft.com/en-us/connectors/sharepointonline/#get-changes-for-an-item-or-a-file-(properties-only) to only retrieve the changes in the SP list?

Let us know if you need any help setting this up?