cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cardinalNight
Helper I
Helper I

How to show just modified fields when using Has Column Changed dynamic content

I have discovered the Has Column Changed dynamic "action" which is returned by using Get changes for an item or file (props only).

This I think, could be used to display only the fields/columns that were changed on an SPO list item, within an email.

The Has Column Changed returns a collection like so:

 

{"ID":false,"Title":false,"Status":true,"Model":false,"Requestedby":false,"RequestingPart":false,"Sponsor":false,"Date":false

 

Perhaps a HTML table could be used to display only the fields which are true? Would I start with a Select or HTML table action to achieve what I want?

4 REPLIES 4
abm
Super User
Super User

Hi @cardinalNight 

 

Since it dynamic try the HTML table

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi - getting an error:

BadRequest. The property 'columns' must be specified unless the 'from' property value is an array of objects.

Automatic doesn't work. I only want to show the fields that have been changed as well. So your solution won't work, but thanks.

 

Hi @cardinalNight 

 

Check the run history whether it returned as an array or not? Create HTML action step requires an array object to bind? Could you post a screenshot of run history data.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @cardinalNight 

 

Ok I checked that now. It won't return the changes in an array format so you won't be able to bind the values directly via HTML. Same for the SELECT action step as well. You may need a very custom implementation for this.  I am thinking you could check the has column changed property to check all the fields and append the values in a custom HTML string and finally bind the HTML in an email. Downside is you will end up having too many IF conditions.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,177)