Unanswered

Merging multiple datatables

(0) Share

Report

Posted on by GenAi

Hi,

I need to merge multiple specific datatables, which I have managed to do. However, there are times a table may not exist and if that happens I want it to leave the "blank" or table that doesn't exist and merge the other specified tables. In this particular case, DT7 didn't exist, but next month there may be a table for it but not a table for the other. How do I fix this in the Run.Net script action below, thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!

@GenAi

Try this approach:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @GenAi ,

But in new vesrion of PAD you have inbuilt action to merge the DataTables as shown in below image.
So i would it will be easy and better to use inbuilt action.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No