วีดีโอ

Can you share more details? You are using create file with attachment name and attachment content correct? Are you using new designer or old designer?

You can use condition to check length after split. Like if length is 0 then skip.

When you do split based <table then depending upon table you will get more than two values. Let's say there are 2 tables then first split will return 3 values. So instead of using last function you need to give index. For example if i want to get second table then i will use expression split()[2] in this [2] will return third value which is basically second table. Let me know after trying

@@biteasier ...Wow...Many thanks ... 😃

Hi There. I hope you are doing great. What you mean by Test? Do you mean you want to extract Test :? Kindly explain in more details

السلام علیکم Ap Kiwi Browser Next try kar lain. Google sa download ho ga github sa. Mena try nae kia q ka mera pas device nae abi

Can you explain in more details or share examples

@@biteasier ...Lets say we receive the same data in a table format which has 3 columns - Name, Address and Phone and below that we get information for 1 or multiple people. So if it is for 1 people then we will have a single row with his relevant information. If multiple then we will have multiple rows wherein each row would have information for 1 people. I wish I could attach a screenshot but Comment section doesn't allow that. I hope I have been able to explain? The number of columns may be more as well i.e. instead of 3 we may have more. Just looking for something dynamic.

Ok so basically table like excel created using html in mail and each row contains data correct?

@@biteasier .. Correct. Mail containing HTML table and we need to extract data row by row. The same mail may have some texts apart from the table but we should only refer the HTML table.

Ok i understand. I will try to create tutorial if possible and upload it

Always Welcome (:

Hello checking in! If you are able, let me know if you think this is possible.

Update If I have a folder with sub folders labeled 1 to 100000. How do I do this? Receive email. Click forward email. Delete subject line. Write “8976” in subject. Send to general mailbox I set up for this to receive the email. Then the ai tool takes the attachments of that email and uploads them to the sub folder named “8976”. Note, The main folder with the sub folders needs to be on a team in teams that everyone has access to. Thank you thank you thank you please

Hi There. I will let you know after testing

Thank you for your help

For your first comment you want folder to be created based on number in subject? You want this to happen in SharePoint or onedrive?

Glad it helped! If you have any ideas or issues that's face. Like you want tutorial for something in power automate kindly let me know and i will create next tutorial based on that

Hi There. I hope you are doing great. Can you share screenshot or Body of email and tell me what exactly you want to extract from it? I need data to understand it and test it in my environment.

​@biteasier this is the body of the email. The wording doesn't make sense yet because I've not refined my process. But I need to extract the user ID and the keep access answer From: removed for privacy Sent: removed for privacy To: removed for privacy Subject: removed for privacy Hi You currently have access to resource: Test: Resource 1 Link: Test Link Keep Access: Yes User ID: 1 If you need access to remain please reply to this email using the reply button. Add yes or no to the subject line and send. If you don't do this your access may be removed. Many thanks

Can you try this trim(first(split(last(split(output s('Html_to_text')?['body'],'User ID:')),' ')))

After testing. Let me know what output you get

I get this output ​@biteasier it starts at the number 1. 1 If you need access to remain please reply to this email using the reply button. Add yes or no to the subject line and send. If you don't do this your access may be removed. Many thanks

Hi There. I hope you are doing great. Kindly provide few samples if possible

Hi there. i added expression in description and posting it here as well if you still get error kindly share error details and expression you are using. trim(first(split(last(split(outputs('Html_to_text')?['body'],'Name:')),' ')))

​@@biteasier i fixed the first error, it was my lack of attention and i writed the expression in a wrong way. But now im not getting my desired result, i've put the expression like you did, but in the result that i got is all the text alongside with the first line with the right text

@@biteasier i got like this: Desired Text bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla

Can you share expression? That you are using? Or do this. In old designer click three dots on step where you are using expression. Copy to clipboard and share that code with me so i look at it directly

@@biteasier Thank you for yout help ! Im brazilian, so some pieces of the text are in Brazilian Portuguese: trim(first(split(last(split(outputs('Html_em_texto')?['body'],'Razão Social:')),' '))) trim(first(split(last(split(outputs('Html_em_texto')?['body'],'CNPJ:')),' '))) trim(first(split(last(split(outputs('Html_em_texto')?['body'],'E-mail:')),' '))) trim(first(split(last(split(outputs('Html_em_texto')?['body'],'Telefone:')),' '))) trim(first(split(last(split(outputs('Html_em_texto')?['body'],'Classificação:')),' '))) After i paid more atention in your expression i've fixed some of my errors, but now i got the line desired and the next one too

Glad it was helpful!

Glad it helped!

In parse json did you provided output of question to generate schema?

Yes it's possible. You can use expression to get folder name

Hi There. I hope you are doing great. What you mean by this?

Hi There. It is added automatically when you select name from parse json

Hi there. I hope you are doing well. Can you share flow screenshot? You can upload screenshot on any website and share link with me

@@biteasier i figured the email action that I am using won't allow multiple attachments.

Turn on roaming if internet stop working after some time. (mostly happen to me on jazz)

Hi There. I hope you are doing great. Can you explain in more details what exactly you mean?

Hi There. I hope you are doing great. Yes i will try to create script for both types of files and upload tutorial

Hi There. I hope you are doing great. Try disable new designer (top right corner) and try again. Let me know after testing

السلام علیکم Ok انشاءاللہ

Hi There. I hope you are doing great. What you mean? Can you explain in more details?

السلام علیکم Mujha koi idea nae. Abi tak to pta ka masla nae aia is me

السلام علیکم Error kia aa rha?