I am glad it helped you 😊

Sure, i will check on it

@@technicaltrainingsolutions i will be waiting for the same soon :)

You can write it like this ['Lob\'s']. It will work then

@@technicaltrainingsolutions Hi There I tried adding the same. But it’s giving same error “ Column or Property ‘LOB’s not found. Below is my code : Create new list For each currentitem to ExcelData Add item list - <table><tr><th>LOB’s</th><\tr> End Add item to list Add item to list <tr><td>%Currentitem[‘LOB\’s’]</td><\tr> Can you check and tell what is wrong and why it’s giving me this error

Excel.Attach DocumentName: $'''challenge.xlsx''' Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData Variables.CreateNewList List=> List Variables.AddItemToList Item: $'''<table><tr><th>ID</th><th>LOB\'s</th></tr>''' List: List LOOP FOREACH CurrentItem IN ExcelData Variables.AddItemToList Item: $'''<tr><td>%CurrentItem['ID']%</td><td>%CurrentItem['LOB\'s']%</td><tr>''' List: List END Variables.AddItemToList Item: $'''</table>''' List: List Text.JoinText.JoinWithDelimiter List: List StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> JoinedText Text.CreateHTMLContent HtmlEditor: $'''<p>%JoinedText%</p>''' HtmlContent=> HtmlContent

please check this. it is working

@@technicaltrainingsolutions should I paste whole this whole code ??

You can email me to technical.training25@gmail.com We can connect on Google meet

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4NiyLNO6YcU.html

I am glad it helped you

Before running the bot make sure your browser console is closed

If this method is not working try using C# code in .Net Script action of Power Automate Desktop. I have a video on my channel. That can give you some idea to which way to proceed

Glad it helped

Glad it helped

Alt+H+V+R

It turns out that this 'solution' only works if you're attempting to bulk insert the file from the same machine where the SQL Server is located. If you're trying to bulk insert from your personal PC into the SQL instance, it won't be possible

Thanks

Try .ToString() It's case sensitive

if you want to select all the data and then delete it....you can use {Control}({A}){Delete}

@@technicaltrainingsolutions thx chatgpt and copilot didnt help much and kept telling me to do {^a}

I have replied now.. please check it .. let me know if you need more help

Write it in a single pair of percentage sign

@@technicaltrainingsolutions I tried it gives a syntex error or not executed... Please gives a example who to do it.... Like first one %A% and second one %B% variable who to populate in url field in single syntax... Please🙏

Let's say you have two variables %var1% and %var2% and your URL is www.google.com. In this Url you want to include these two variables then you can write it www.google.com/%var1%%var2%

@@technicaltrainingsolutions sir I use this type of syntax first variable is exactly working and the 2nd variable gives an extra text populated before 2nd variable %0d%0a one thing I want 2 say that 2nd variable is only numbers ( 0-9 )

This is my url " admin-mkp.gem.gov.in/#!/catalog/new?bnid=home_elec_elec_powe_li30614140&gem_catalog_id=5116877-%0D%0A74504106570 Till 5116877- is my first variable 75404106570 is my second variable Sir Now you can understand better to solve my error.... Thank you