Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Update and create new record in excel automatically

Posted on 22 Nov 2024 03:44:08 by 10
HI 
I have an excel the path is static in onedrive. when user modified the existing record or created new record then the data automatically should be updated on the destination excel which is there in sharePoint. I have created a flow. but it is working for only when the existing records are modified. It is not working for when a new record is created.
  • Inogic Profile Picture
    Inogic 830 on 22 Nov 2024 at 09:57:41
    Update and create new record in excel automatically
    Hi,
     
    Try the below step to update and create an Excel record.
    To handle both updating existing records and creating new ones in your flow when working with Excel files, follow these steps:
    Use a Filter Array to compare the unique identifier from the source and destination rows. For example, If the unique column in the source is ID: then below is the expression
    equals(items('Apply_to_each')?['ID'], item()?['ID'])
    To verify the created or updated record for the Filter Array step use the expression:- empty(body('Filter_array'))
    If true (record does not exist), add a new row.
    If false (record exists), update the row.
     
    Hope this helps.
     
    Inogic Professional Services: Power Platform/Dynamics 365 CRM
    An expert technical extension for your techno-functional business needs
    Drop an email at crm@inogic.com 
    Service: https://www.inogic.com/services/ 
    Tips and Tricks: https://www.inogic.com/blog/ 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,081

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard