cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sromley
Frequent Visitor

Format updated fields from SharePoint List to excel

I'd like to highlight specific cells in an excel row based on whether the cell changed in SharePoint List.

I'm currently able to push changes from a SharePoint list to excel using "get changes for an item or a file".  

 

Here is an example of what I'm trying to do:

2022-12-01_15-58-50.jpg

 

 

 

 

It's really important because the team is looking through about 20 different columns.  We determined the highlighting stuff that changed would really save a lot of time.

2 REPLIES 2
sromley
Frequent Visitor

😧I just figured out I already asked this question.  Opps!  I was reading somewhere that power automate can include formatting in the expressions.  All I could find was for date formatting, nothing about font color, etc.

grantjenkins
Community Champion
Community Champion

I'm not sure if this is possible with Power Automate. However, within Excel itself you can show changes, and when you click on any of the changes it will highlight the cell that changed - this might be another option you and your team can explore.

 

grantjenkins_0-1669962296904.png

 

grantjenkins_1-1669962360958.png

 



----------------------------------------------------------------------

If I've answered your question, please mark the post as Solved.

If you like my response, please consider giving it a Thumbs Up.

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,342)