hello I made the same thing but borders in the table didn't turn into 1px solid black, it is shown in PAD as with transparent borders. Could you please check it ?
hello . i tried the same and i am getting error as my column name is this (LOB's,Firts Name's ,Last Name's) I tired the same syntax which you have mnetioned : %CurrentItem['LOB's] but i am getting error that :There is no column found . .Can you help me in telling what should i update while creating list in add item in table body as its not taking syntax like ['Lob's']? Thanks ,
@@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 - LOB’s End Add item to list Add item to list %Currentitem[‘LOB\’s’] Can you check and tell what is wrong and why it’s giving me this error
Hi There..Can you try to Create a video on "Converting Number Values into Percentage into Power Automate Dekstop" Like: We have excel data with Columns: Name Marks Rank XYZ 90% 1 Ash 35% 2 Bharati 20% 3 We want to copy the same data with same format within table into Email body . Right now what is happening when i am copying the data through flow in HTML body its take Percentage as a Number and pasting them as a Number in Email body Result I am getting when i am pasting the data into email body is : Name Marks Rank XYZ 0.9000 1 Ash 0.3500 2 Bharati 0.200 3 Expected result : Name Marks Rank XYZ 90% 1 Ash 35% 2 Bharati 20% 3 Can you help me in creating one video if its possible in Power Automate Dekstop? Thanks .
hello I made the same thing but borders in the table didn't turn into 1px solid black, it is shown in PAD as with transparent borders. Could you please check it ?
very good!
Thank you
Hi sir make a video on how we can map two different column without loop perform vlookup and remove vlookup formulae in power automate desktip
You can apply vlookup
hello . i tried the same and i am getting error as my column name is this (LOB's,Firts Name's ,Last Name's)
I tired the same syntax which you have mnetioned :
%CurrentItem['LOB's]
but i am getting error that :There is no column found .
.Can you help me in telling what should i update while creating list in add item in table body as its not taking syntax like ['Lob's']?
Thanks ,
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 - LOB’s
End
Add item to list
Add item to list
%Currentitem[‘LOB\’s’]
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: $'''IDLOB\'s''' List: List
LOOP FOREACH CurrentItem IN ExcelData
Variables.AddItemToList Item: $'''%CurrentItem['ID']%%CurrentItem['LOB\'s']%''' List: List
END
Variables.AddItemToList Item: $'''''' List: List
Text.JoinText.JoinWithDelimiter List: List StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> JoinedText
Text.CreateHTMLContent HtmlEditor: $'''%JoinedText%''' HtmlContent=> HtmlContent
please check this. it is working
@@technicaltrainingsolutions should I paste whole this whole code ??
Hi sir make a video on convert excel to xml data in power automate desktop
Will try
Hi There..Can you try to Create a video on "Converting Number Values into Percentage into Power Automate Dekstop"
Like:
We have excel data with Columns:
Name Marks Rank
XYZ 90% 1
Ash 35% 2
Bharati 20% 3
We want to copy the same data with same format within table into Email body . Right now what is happening when i am copying the data through flow in HTML body its take Percentage as a Number and pasting them as a Number in Email body
Result I am getting when i am pasting the data into email body is :
Name Marks Rank
XYZ 0.9000 1
Ash 0.3500 2
Bharati 0.200 3
Expected result :
Name Marks Rank
XYZ 90% 1
Ash 35% 2
Bharati 20% 3
Can you help me in creating one video if its possible in Power Automate Dekstop?
Thanks .
Sure, i will check on it
@@technicaltrainingsolutions i will be waiting for the same soon :)