Power automate : Edit table column text inside Web Form

[prashiss]

Hi Experts,

I have a requirement where I need to edit heaps of text using Power automate.
I have a webform and inside webform we have a Html table and inside table we have several rows and columns.
I need to update this webform values which is currently more than 30k in numbers.
UI selector won't work as i cannot register all participating td's.
Screenshot is attached for your reference.

Please advice.

[UshaJyothi20]

Use get details of the webpage and try to use populate text field on web page or send keys and iput the text you Wanted

Hope this helps

Usha

[prashiss]

Populate text field on webpage won't work as we have more than 30k cells which need to updated and we cannot use UI selector due to no of TD cells.

Send keys not working as keep giving me element not interactable error.
Only option left is to use "Run javascript on web page" action Execute script method
below sample code just for 1 td cell

function ExecuteScript()
{

document.querySelectorAll('#dg_rc_0_1')[0].innerText='1234567';
document.getElementById('dg_rc_0_1').setAttribute('idv','1234567');

}
After executing above code I can see value inside cell got updated with new whatever value we put but after hitting save values are flip back to it's orignal value.
So not sure how to deal with this kind of issue?

Any response is appreciated.

Thanks & Regards
Prashant

[Neil_ODonnell]

Did you ever solve this? i have a similar problem on a much smaller scale, trying to populate several fields on a web table,

[prashiss]

Hi Neil,

Apologise I was not very active from last few months. Yes I was able to achieve this by send keys.(Basically using send keys(using tab+text) inside for loop. let me know if you still need any help?

Thanks
Prashant

[UshaJyothi20]

Please try to copy the datatable before saving and write into another excel sheet.

May be the old sheet has some formulae.

Hope this helps

Usha