Data Mesh - Overriding data on the target sheet

Andrea_Thompson · 05/14/24

When the lookup value is enter in the target sheet, the data values appear right away. However, if I override one of those data values, will data mesh run again to correct it? I tried testing it, but it seems to allow me to override the data value, and I don't see data mesh running again to revert back to what came from the source sheet.

Andrea_Thompson · 05/20/24

Thank you @Genevieve P. for your response. I have it set to immediately.

I did a test and found that it took about 10 minutes to make the update. I guess I was just too impatient!

Jason Tarpinian · 05/17/24

That's a configuration setting you can change as needed:

Andrea_Thompson · 05/18/24

@Jason Tarpinian

Thanks for your response! Yes, I have that setting correctly. If there is a different value on the target sheet, the data mesh will overwrite it initially. But if I then go to the target sheet again and change whatever data value that data mesh brought over, it doesn't seem to revert back.

Genevieve P. · 05/20/24

Hi @Andrea_Thompson

What do you have in your "Execution Frequency" set-up?

Changing values in the target sheet won't immediately trigger the DataMesh workflow to run. If you have it set for "1 hour" like the image above, then at the 1 hour mark that's when the target sheet will update again. Does this perhaps explain what you're seeing?

Andrea_Thompson · 05/20/24

Thank you @Genevieve P. for your response. I have it set to immediately.

I did a test and found that it took about 10 minutes to make the update. I guess I was just too impatient!

Add Ons and Integrations

Add Ons and Integrations

Data Mesh - Overriding data on the target sheet

Best Answer

Answers

Quick Links

Categories

Trending Posts

Bridge: Way to delete all rows in a sheet

Bridge | How to Find Rows With Status & Delete Them

Is Microsoft killing the Outlook Add-in?