Пікірлер
@davidferrick
@davidferrick 23 сағат бұрын
Does this work with a Shared Inbox? I cannot seem to get it to work.
@AnthonyLewis-f2c
@AnthonyLewis-f2c 3 күн бұрын
Hi, Great content. Do you have any recommendations for searching an existing SharePoint List that has duplicates? I normally update my list is batches not one row at a time. Do you have any recommendations for that scenario?
@surbhidhillon6993
@surbhidhillon6993 5 күн бұрын
Hi Your videos are really helpful I am struglling to create flow for below data CNo Inv No Amount Email CC Due date Status 101 521 231 11.07.2024 X 101 522 232 11.07.2025 X 102 523 233 11.07.2026 X 103 524 234 11.07.2027 X 101 525 235 11.07.2028 X 103 526 236 11.07.2029 X 103 527 237 11.07.2030 X 104 528 238 11.07.2031 X 102 529 239 11.07.2032 X 101 530 240 11.07.2033 X I want to send email for overdue invoices to Customers such that invoice belonging to one CNO are sent in one email-to email listed in Email and CC column and then update Status to "followe up email" sent. Can you please help
@SamyukhthaPranethaa1984
@SamyukhthaPranethaa1984 10 күн бұрын
I created a flow based on your instruction. However the output is not reflected in the new excel files. Please help.
@mhmdzrik8579
@mhmdzrik8579 13 күн бұрын
hello, whenever i check my outputs it only showing the header and body , i dont get the questions separately for me to copy and paste it in the json
@Dlhlaptop
@Dlhlaptop 14 күн бұрын
Thank you Very Much!! Works Great! You > Chat GPT
@abm4975
@abm4975 13 күн бұрын
You're welcome!
@kirtichopra2551
@kirtichopra2551 14 күн бұрын
Can you please create a video showing how to select 1 file from document library containing multiple files and send it on an email.
@SreeramSashankChundi
@SreeramSashankChundi 14 күн бұрын
i have created a flow where when ever we receive an email(v3) the automation will copy the body and paste it in an excel sheet . but when i receive 2 emails at exact same time the flow is unable to trigger both the emails but only one some times none can you help me with this
@reshmapatel101
@reshmapatel101 14 күн бұрын
Hi, thank you for this excellent tutorial! I was able to get this workflow to work on a sharepoint list I created manually but not on a sharepoint list I created by uploading a csv file with over 15,000 rows. Any ideas on why this workflow wouldn't work in the latter case?
@shathike4079
@shathike4079 15 күн бұрын
Thanks for good informatic video, When a file is deleted approval workflow is required whether approve / reject
@17avskadoo
@17avskadoo 16 күн бұрын
Can we do this exercise on system defined tables like 'Microsoft Entra ID' table? Please make video on that
@jonaskoniger3337
@jonaskoniger3337 20 күн бұрын
can someone help me? I am still getting the corrupted files only. I have a trigger comming from a powerapp getting the file The code in the body is: binary(triggerBody()?['file']?['contentBytes']) base64 is set to yes. Can anyone help me?
@abdelhamedmohammedali6143
@abdelhamedmohammedali6143 20 күн бұрын
Hello, thanks for your video's i need to contact with u so, may i know your mail or WhatsApp no:
@abm4975
@abm4975 17 күн бұрын
Thanks for the support. Check my channel about section. Send me an email.
@marconeabdala8793
@marconeabdala8793 20 күн бұрын
Thanks for this!
@abm4975
@abm4975 17 күн бұрын
Thanks for the support
@user-um1dj4th3u
@user-um1dj4th3u 21 күн бұрын
Thank you @abm4975
@abm4975
@abm4975 17 күн бұрын
Thanks for the support
@abm4975
@abm4975 23 күн бұрын
This http connector is not working anymore. So I found another work around. More details in this thread. powerusers.microsoft.com/t5/Building-Flows/Email-Classification/m-p/2809734/highlight/true#M315588
@user-bn4cs7bk8h
@user-bn4cs7bk8h 23 күн бұрын
Thank you very much for your detailed explanation
@abm4975
@abm4975 22 күн бұрын
You are welcome
@bc67
@bc67 24 күн бұрын
Thank you for sharing. Throughout the hierarchy, I have 2 sub-folders with the same name. How would I modify this Flow to delete all the files in only one of the sub-folders?
@abm4975
@abm4975 17 күн бұрын
Get folder meta data using path to find the id. Then try to use the delete item using the id from the meta data. I haven't tested this but have a go. Always try this in a test folder or something. Then makes sure all ok. Thanks
@RakhibMohammad
@RakhibMohammad 25 күн бұрын
With the extracted text from the mail body, how can we create a folder in share point with this extracted text name? It will be helpful if anyone helps me
@himanshupaghdal
@himanshupaghdal 25 күн бұрын
hello, can ypu see here my recent post for power automate? my Id is hpatel95. I appriciate if you help me..
@abm4975
@abm4975 25 күн бұрын
Believe I replied
@himanshupaghdal
@himanshupaghdal 26 күн бұрын
Is this condition can be use to trigger only specific column right?
@abm4975
@abm4975 25 күн бұрын
Yes that's correct but you can extend this for multiple fields too.
@CliveMMorgan
@CliveMMorgan 27 күн бұрын
Hello, that is a very helpful video, thank you. Do you have a video doing the same thing but creating a PDF file from a SQL VarBinary field instead?
@abm4975
@abm4975 25 күн бұрын
Hi Clive Believe you already asked this question in Power Automate community. I did responded. Please have a look. Thanks
@CliveMMorgan
@CliveMMorgan 23 күн бұрын
@@abm4975 Thanks
@JoeAtWork-gy4wh
@JoeAtWork-gy4wh 28 күн бұрын
Hi abm Is it possible to use a version of this flow to migrate a SPO classic List to a SPO Modern List in the same tenant? I have a few lists to move but I only need to retain the created data from the SPO Classic from the metadata.
@abm4975
@abm4975 28 күн бұрын
Hi Joe Believe it should be possible. I can't see any difference other than the UI changes between classic and modern. So Power Automate should connect the classic list.
@JoeAtWork-gy4wh
@JoeAtWork-gy4wh 28 күн бұрын
@@abm4975 Thank you for your quick reply :) ShareGate charge $4999 a year for that ability so it would be a game changer if it could be done via a flow.
@abm4975
@abm4975 28 күн бұрын
Interesting. Could you connect me via email. Check my Channel about section. I want to see the classic list. I could have a go and see whether I can make it work or not. Thanks
@sruthi116
@sruthi116 28 күн бұрын
Hi, I am getting this error while I try to convert the date format: The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(formatDateTime(item()?['Next Re-Assessment [Date]'], 'MM'), 01)' failed: 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Could anyone please help?
@abm4975
@abm4975 28 күн бұрын
Hi The reason you are getting is you have some of date fields are blank. You can prevent this error by adding an IF condition to check whether the value is null or not.
@komailbutt2998
@komailbutt2998 28 күн бұрын
I have multi line text field separated by |. For example, Are you there? | How are you? I want to create two separate rows in the Sharepoint list with other same fields. I followed the same approach as you. In the Apply for each, I provide the split array. Then use item in the compose and then use create item in which i make that particular column= output of compose but I am getting one extra row along with the two splitted row. The extra row contain full text without splitted. Please how to remove or skip this extra row.
@abm4975
@abm4975 28 күн бұрын
Thanks for the question. What's the delimiter for the split() you using?
@komailbutt2998
@komailbutt2998 28 күн бұрын
@@abm4975 | I am using.
@komailbutt2998
@komailbutt2998 28 күн бұрын
@abm4975 My full looks like: 1Get form details: 2Initialized String variable (Value = Multi line text field) 3Compose: split (string variable, "|") 4 Initialized Array variable Value = compose output Apply for each: Value = Arrayvaribale Compose2: Item() Create Item: Desired column= Compose2 output
@komailbutt2998
@komailbutt2998 28 күн бұрын
@abm4975 I have also observed that whether or not the Apply for each running, the extra row containing Desired field = Full multiple line text comes.
@fatima-ezzahraerraji5352
@fatima-ezzahraerraji5352 29 күн бұрын
Thank you very much. Very good video, but the files are not filling up.
@abm4975
@abm4975 29 күн бұрын
Hi Thanks for the comment. Could you please explain what you trying to filter? What's the data type of the column?
@fatima-ezzahraerraji5352
@fatima-ezzahraerraji5352 27 күн бұрын
Hey. Thanks for your answer. So the first column contains the names of my students, and I want to filter based on that
@flaviaaa
@flaviaaa Ай бұрын
Is there a way to send one mail to two email recipients (two columns of email instead of one in the excel file)? Please, i'd appreciate it :)
@abm4975
@abm4975 Ай бұрын
Yes you can. What you meant by two columns of email?
@flaviaaa
@flaviaaa 14 күн бұрын
@@abm4975 Hi! I meant that I have an Excel table with N columns, 2 of them are called Email1 and Email2 and each column contains two different emails per row. I want to send them both one single mail containing the info. I don't care if one email it's CC or so, I'll take the easiest way :)
@TheKobe125
@TheKobe125 Ай бұрын
Hi, Is it possible to find out how many responses are selected so that when I add the outputs to my rows it does not create additional rows for outputs that have no value?
@abm4975
@abm4975 Ай бұрын
Not sure what you meant by additional rows for outputs that have no value? When user submits there must be some value. Hope you have some mandatory fields. If not add an IF condition to determine whether the response of each question is empty or not? Thanks
@TheKobe125
@TheKobe125 29 күн бұрын
So essentially, I have extracted the values from my Microsoft forms multi-choice field. I have a currency multi-choice field that users can select multiple currencies; I want to add a new row if the outputs from my compose steps are not empty. Essentially, I only want to create a new row if the currency has been listed in compose outputs. If they are empty to ignore them. Is there a way to test for this based on your solution above?
@abm4975
@abm4975 29 күн бұрын
Yes check the compose output under the IF condition.
@MohammadAw-eh2gn
@MohammadAw-eh2gn Ай бұрын
Thank you very much sir for your help, video trex explanatory and instructive
@abm4975
@abm4975 Ай бұрын
Thanks Mohammad. Glad that its helpful.
@janosdora8666
@janosdora8666 Ай бұрын
Many thanks for your help! Everything is so helpful.
@abm4975
@abm4975 Ай бұрын
Glad to hear that! Thanks for the wonderful support.
@markjavier4349
@markjavier4349 Ай бұрын
can you do it also for more than one entry? ie multiple ID?
@abm4975
@abm4975 Ай бұрын
Yes you can. Change the trigger step to Get Items. Then pretty much follow the same steps.
@cindy26131
@cindy26131 Ай бұрын
Thank you so much for this wonderful tutorial. I have been searching for a solution to prepare a summary list from another SharePoint list for a very long time, and you saved my life! I have a follow-up question: Is it possible to have two groupings at the same time, for example, by number and status (Open & Close)? If so, could you please explain how to do it? Many thanks!😍
@abm4975
@abm4975 Ай бұрын
Thanks for the support. I don't think you can have two groupings at the same time.
@NatalyaWilmaRias-bk1ik
@NatalyaWilmaRias-bk1ik Ай бұрын
how about attachment in PDF is there a way to read it?
@abm4975
@abm4975 Ай бұрын
Hi, Unfortunately not. You need to look into Open AI API to read the PDF contents. Also have a look on other third party connector in Power Automate. Microsoft don't have anything out of the box to read the PDF contents. Thanks
@no.more.official
@no.more.official Ай бұрын
Thank you
@abm4975
@abm4975 Ай бұрын
You're welcome
@gcooper642
@gcooper642 Ай бұрын
You're a star. Straight to the point. It's taken me hours to find this.
@abm4975
@abm4975 Ай бұрын
Thanks a lot
@AkmalFarid-nc8hp
@AkmalFarid-nc8hp Ай бұрын
Hellow i had to group the files. so i had 2 files that had the same first name, but i wanted to group them together. With your flow it got stuck cause there will be second folder that had a same name.
@abm4975
@abm4975 Ай бұрын
I need to see your flow. Could you connect me and have a screenshare to find a solution. Thanks
@nurulfatihah1475
@nurulfatihah1475 Ай бұрын
Thank you for making great video! Appreciate if you could advise on how can we add into Power Automate if we have more than 1 question that need to sum up the total?
@abm4975
@abm4975 Ай бұрын
Declare a int variable. Then check the answer under the IF condition. Here increment the score using add expression
@comehuevosviajeros
@comehuevosviajeros Ай бұрын
My friend you are amazing thanks!
@abm4975
@abm4975 Ай бұрын
Thank you too!
@guntipruthvi6538
@guntipruthvi6538 Ай бұрын
Hi sir. Just a small doubt in the expression you have mentioned in the description. What is that specific date ‘1899-12-30’ you written in the expression. Why do you write that. Your reply will be appreciated. Thanks
@abm4975
@abm4975 Ай бұрын
Read this pls forum.openoffice.org/en/forum/viewtopic.php?t=108820#:~:text=For%20date%20values%20to%20correspond,entries%20between%20Excel%20and%20Calc.
@lindasteel8874
@lindasteel8874 Ай бұрын
Thanks that helped me a lot! :)
@abm4975
@abm4975 Ай бұрын
Glad it helped!
@MarcusCrutchfield
@MarcusCrutchfield Ай бұрын
How do you write/export the version history data to a CSV ?
@abm4975
@abm4975 Ай бұрын
Good question. This I haven't tried yet. Have a look on API documentation of SharePoint. That might offer something.
@roxasdracun8661
@roxasdracun8661 Ай бұрын
Kinda similar to what I wan to do ,but I want to assign the category to the even itself. Example: New event arrives, person accepts _> GREEN category or person declines _> RED Category
@abm4975
@abm4975 Ай бұрын
I haven't tried that. Looks like its possible. Have a look on API.
@roxasdracun8661
@roxasdracun8661 Ай бұрын
@@abm4975 I been trying on it
@bhargovtamuly6812
@bhargovtamuly6812 Ай бұрын
I tried this for ms forms responses but it doesn't work
@abm4975
@abm4975 Ай бұрын
There is a fix I applied. See my description in my video.
@LeandroCarvalho-hn4ti
@LeandroCarvalho-hn4ti Ай бұрын
This is frustrating... I spent a few hours researching this, thank you. I think I am going to debug in old designer and try stick to that for now.
@abm4975
@abm4975 Ай бұрын
Glad I could help!
@ma.teresatabaco5398
@ma.teresatabaco5398 Ай бұрын
Hi, thank you for sharing this video. It is very helpful, however, is it also working for calculated columns? I want to auto-update my second SP list with the sum of a calculated column of my first SP list. I have searched around online I can't find anything. Could you please help me on this? Your reply will be highly appreciated :)
@user-xn6mh2tq5m
@user-xn6mh2tq5m Ай бұрын
I, like many of the other commenters am grateful to have found this video, and can confirm as of today it's still an issue. Classic mode: works, New Designer Mode: error.
@abm4975
@abm4975 Ай бұрын
You're welcome!
@shwetaupadhyay1597
@shwetaupadhyay1597 Ай бұрын
Thanks a lot. This was really helpful
@abm4975
@abm4975 Ай бұрын
Glad it helped!
@benjaminfoley919
@benjaminfoley919 Ай бұрын
The enter key part doesn't seem to work for me
@abm4975
@abm4975 Ай бұрын
So that means in your email each lines are not recognized as enter keys. Is that email generated by other systems?
@benjaminfoley919
@benjaminfoley919 Ай бұрын
@@abm4975 Its an automated email generated by a failing machine. But its structured when the email arrives.
@abm4975
@abm4975 Ай бұрын
I need to see your flow. If you ok for a screenshare then see my About section. Send me an email. Thanks
@anumanjusha7481
@anumanjusha7481 Ай бұрын
Hi, this is informative. I would like to ask you one doubt. I have a form input it is a string( selecting class from the drop down list eg 1 to 12) but it is taking the power automate as a string so how to convert it to number as i am using condition here using Control if else . This is my code (int(body('Get_response_details')?['r7155e3b91d8e4955b38a64f28fa2d6a1']) less than or equal 2 but this is not converting to int ).
@abm4975
@abm4975 Ай бұрын
What error are you getting?
@Grimuka_Gamer
@Grimuka_Gamer Ай бұрын
Hi thank for this amazing video, uri and headers are the same for windows microsoft forms?
@abm4975
@abm4975 Ай бұрын
Hi Not sure what you meant by that? Thanks
@Grimuka_Gamer
@Grimuka_Gamer Ай бұрын
​@@abm4975 I have tried to replicate your video in a similar flow, the difference is that the trigger is from Microsoft Forms, and just get broken files arrive in my azure board, in the same way I do not get the apply to each automatically when the attachment field is set. microsft forms :(, u can make a video for microsoft forms :D?
@abm4975
@abm4975 Ай бұрын
Good suggestion. Let me see. Thanks
@Grimuka_Gamer
@Grimuka_Gamer Ай бұрын
@@abm4975 I would really appreciate it
@abm4975
@abm4975 Ай бұрын
@Grimuka_Gamer, So what are the things you collect from MS Forms? Please explain a bit more about your requirement. Are you collecting image as well?