Hi, thanks a lot for this example...very helpful... but it would be wonderful if you could put an example with "When a row is added, modified or deleted" trigger. I am afraid it won't work with this trigger due to you not getting consistent data using automate flow. Once you put data during instant trigger there is no doubt.
In this approach, I recommend importing the records initially without including the lookup values. Then, using the model-driven app, export the records, filtering them by created date ( so you only get these 600 records), for instance, and sorting them alphabetically. This export will include the records along with the lookup column represented as text values. Subsequently, by filtering these 600 records alphabetically, you can copy and paste the appropriate text values into the exported file for the lookup column. Finally, import this modified Excel file, and the system will correctly associate the records with their respective lookup values.
This is the best video I’ve seen on youtube on this hard topic👍. Thank’s a lot!
Thanks!
Hi, thanks a lot for this example...very helpful... but it would be wonderful if you could put an example with "When a row is added, modified or deleted" trigger. I am afraid it won't work with this trigger due to you not getting consistent data using automate flow. Once you put data during instant trigger there is no doubt.
I need to import 600 new rows to a table. What can I do to make it all once instead of one by one? Thanks for the video
In this approach, I recommend importing the records initially without including the lookup values. Then, using the model-driven app, export the records, filtering them by created date ( so you only get these 600 records), for instance, and sorting them alphabetically. This export will include the records along with the lookup column represented as text values. Subsequently, by filtering these 600 records alphabetically, you can copy and paste the appropriate text values into the exported file for the lookup column. Finally, import this modified Excel file, and the system will correctly associate the records with their respective lookup values.
Wow!!! What an amazing video! Your english is amazing, totally not stonecole english!!!
Promo*SM 💪