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.
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.
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.