In this example I am using Select action to simplify the complex content extracted from SharePoint list. If that looks too complex to you, consider apply to each and make your own array of objects.
I know Im asking randomly but does anybody know of a way to get back into an instagram account..? I somehow forgot my account password. I would appreciate any assistance you can give me.
@Keith Abel thanks so much for your reply. I found the site through google and Im in the hacking process atm. Looks like it's gonna take quite some time so I will reply here later with my results.
It's possible to call 2 different list items in one flow then email those 2 different list item into 1 html email.. example : I had "Master" list item and "details" list item. The Master list item it contains the name of approval and ID and The Details list item it contains list of some item and price.. Do you have any idea? Thankyou
Thanks for the great video.. However I would like to know if it is possible to print this table to a newly generated word document in sharepoint library
Many Thanks Ali, for sharing this knowledge wih us. The concepts you shown here are very well covered in your course of 'Flow Expressions'. This video is just a real life scenario to be more precise. Thanks a lot again!!
Thank you very much. But how can I create a table just for one record? instead of using Get ItemS using Get Item. The flow is triggered for a particular record in the list. I haven't been able to get the body / value from that record and display it as a table. Thanks!
hi this is srikanth from india ur good, in the same i need to know the same method with two to three SharePoint list items as a one to many relationship ID, thank you with your good reference
Sure. Either user "Filter Array" and filter out items you don't need or the better way it to use OData and filter the items at "Get Items" level. This video shows you how to do it with OData th-cam.com/video/G6VsL5zVYtc/w-d-xo.html
Alireza, is there a way to go through an excel sheet and weave out rows from a conditional statements and set it into an HTML table? For some reason, I am getting three times the input.
thank you Mr. Alizera.. may I ask,, what if what I want is not all categories but only electronics and books? please give me advice. thanks very much. God bless you
Thanks for the detailed Demo ,it came handy when i was looking for a similar solution . Looking to group the value based on the author name , can you please show me how to use group by
@alireza : Hi Sir , why did not we applied apply to each to traverse each item in the list . This is super amazing but not i need some insight to better understand the concept . We were creating a variable to club all list data in one email , we did not do that here . Kindly explain
Alireza, I love this video and made a flow that sends me a table of all the meetings I need to schedule. However, I cant figure out how to get a list of displaynames (person 1 name, person 2 name) into the html table. I am able to make the name string using select and join but can't get it into the table! I was thinking of creating a calculated column where it contains the string and then I could do item(). there but do you have any ideas or tips!?
I really liked the video, but I have a question, I cannot add a column in the html table that contains the absoluteuri of an element that I have obtained from the "Get Attachment" component, how could I do it?
Hi I was following this but can you please tell me if I just want one line into a table what should be done ? I dont want the whole list. When a new entry is created i want it to be displayed in a table (just the new entry). Please help
Thank you for sharing the video. I tried it and it's working. But i don't see the json format for the output in the Get Items section.It's showing click to downloads not the json format. Could you please help me out?
Excellent video, easy to follow. Just been trying to figure out wow would you go about only returning the last item created in a SharePoint list and put that into a HTML table with an email. Currently I can only get it show all list items in the html table. I started the flow with a SharePoint "When a new item is created" and then constructed the flow as per your video. I am sure its straight forward, any chance could you point me in the right direction please?
Hello! Thanks for you gratfull video. Is it possible to do the reverse process? I mean, transform a HTML table that is inside of a body email, and bring it to a excel table or a sharepoint list. Thanks!
Hi Sir, Very Nice video.... and i have one requirement that number of rows in excel sheet with mail ids and want to send each row based on each mail id in HTML format .. Is that possible how to do it?
Hi is there a way to map a excel table into email using flow. I have a file which is getting updated via form submissions. a table within the file is getting updated based on the input. the intention is to copy and paste the table into the email body and sent to the recipients
That was an amazing example of how to use various functionalities in PA - simple ,straightforward and to the point - a pure beauty. I just went straight into your course on Udemy which i purchased 2 weeks ago but so far have been going through another course of different author which is far less useful than your video. Big Thanks Question: what would be an action to use Get Items from SQL server database similar to Get Item from sharepoint (to get the json schema)?
Hi, you have explained a great process to automate an email with list items from share point. Could you please do an video on sharing newly added list items instead of all items. It would be great if you can do the same. Thank you!
Thank you sir. Have a question, can we get the table out of excel instead of SharePoint item? I have a use case that I need to send an email to department owners with the list of items that they own from excel report.
This was extremely helpful sir! I learned it so easily! Keep it up. I am facing a problem though - My json code does not start from value. It starts from StatusCode then headers then body and only then do i see value. I believe the from property of th select step will need to change right?
Hi Ali, Thanks for the wonderful video. I just finished your 2 hrs course yesterday. Iwas trying to create a test flow by reading data from excel and sending by email in table format. But, it was not working. I will try the HTML option now. Hopefully it works
Awesome. How would you create an HTML table for the Responses Array when the Approval condition is waiting for all to respond and you have multiple approvers.
Many thanks for this video - it covers 90% of what I need. here is question for the remaining 10%. one of the data from share point list is enhanced rich text. when I added it to html table as you described in the video - tags are not interpreted, tags appear along with the actual text. can you tell me how to fix the issue? thanks in advance.
I am in need of sending a table with a multiline column. Is that possible? I am having issues with it either sending a single line instead of multi. SharePoint list column is set as plain text and powerapp datacard is set as rich text.
Alireza, do you know why I'm not getting "Value" as a dynamic option? I have a flow trigger, and I have "Get Item," but when I look through my available "Get Item" dynamic options, "Value" is not an option. If you could help with this, I would be very grateful.
Hi Alireza, Thank you for this very useful video, However, could you please tell me how to send email with embed images, I have tried send an email (V2) connector also and I have tried so many things but these are not working.
If you were creating the table for multiple stores in a share point, is there a way to make a table for a store and the products that store needs only instead of all the products from all stores?
We want to send mail to a Single email id (it is a distribution group email id) by combining all names of employees who has birthday today. Could you help to achieve this.
@@AlirezaAliabadi Thank you, this was very helpful. I do have another challenge. I am pulling Date/Time from the SharePoint list and would like to convert it to a different format for the email message. I tried in the mapped field of the Select to create an expression: formatdatetime(triggerBody()['StartDateTime'],'MM-dd-yyyy HH:mm') It keeps telling me that I can not use StartDateTime.
Also , in this example , if i would want to apply filter on Person email and share the respective rows belonging to a person , and not the complete data , how do i do that ? e.g 3 rows belongs to John , send data to John and 2 rows belongs to Pooja , send those data to Pooja , how do we apply that filter and share it >
Really neat solution. I would love to know if there's a way to strip HTML formatting from items that I select e.g. I have values such as this "To define and document best practices for the creation of user stories" What I need to select out would be "To define and document best practices for the creation of user stories"
I am getting this error. Can you please help ? The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "Title": "@item()['Title']", "JRA #": "@item()['Status']['Value']", "Test": "@item()['group1']['Value']" }' failed: 'The template language expression 'item()['group1']['Value']' cannot be evaluated because property 'Value' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'.
Hi Sir, this is really nice tutorial, but i hope it is not too much if i ask some help. How to make the several columns in Sharepoint turn to rows. Its more on approval, and want to summarize and send to email as HTML. Example. Sharepoint list columns such as HR department, Finance Department & IT department turn into HTML like this format: Department Status HR approved Finance approved IT approved. I tried it, but got the result of all 'in one line' or one row when the HTML result received in email, where in the expected result has multiple rows. Thanks so much Sir.
My columns has space in naming and it's not accepting space. Please suggest how to fix example:item().Employe Name. I am getting error,I am capturing output using Excel online, not SharePoint
Hi Alireza, is there a way to format a number with an expression instead of the Format Number action? It is forcing for an apply to each on an SQL Query. Thank!
@@AlirezaAliabadi I'm exceuting a SQL query but the HTML table does not recognize thousands/currency format. So can I = excute query -- Create HTML table and on each field select query items and convert them to currency through a flow expression? Thanks!
@@cristoballoscher4297 That's the way to go. Inside the "Select" action is where you use formatting expressions and convert the numbers to the format that you want.
I know this is an old video but while trying it a get an error on columns that are choice but can have multiple selections. What should I do in that case since item().ColumnName.Value gives me an error
In this example I am using Select action to simplify the complex content extracted from SharePoint list. If that looks too complex to you, consider apply to each and make your own array of objects.
How to send a formatted link using Create table action
I know Im asking randomly but does anybody know of a way to get back into an instagram account..?
I somehow forgot my account password. I would appreciate any assistance you can give me.
@Griffin Talon instablaster ;)
@Keith Abel thanks so much for your reply. I found the site through google and Im in the hacking process atm.
Looks like it's gonna take quite some time so I will reply here later with my results.
@Keith Abel it did the trick and I actually got access to my account again. Im so happy:D
Thanks so much you really help me out!
Really appreciate your content. Keep up the great work, sir.
UGH THANK YOU. I've been struggling with this for a weeks! It's all running perfectly now! you are a life saver
Such a wonderful video. Thank you!!!
I am glad it helped :)
Hello Alireza, thanks for the video.
wow :) most clear tutorial ever . Thank you thank you
from VietNam thank you so much. so if i just want to send the item latest create what should i do?
It's possible to call 2 different list items in one flow then email those 2 different list item into 1 html email.. example : I had "Master" list item and "details" list item. The Master list item it contains the name of approval and ID and The Details list item it contains list of some item and price.. Do you have any idea? Thankyou
Great tutorial. Very easy to follow.
Alireza you're a legend! Thanks a lot, this was very helpful in outputting only the values from a sharepoint data field with multiple tickboxes.
Thank you very much Alireza! Truly appreciate your sharing.. :)
This was very helpful and I appreciate your explanation regarding Select. Will look to your course on Udemy. Thanks
Awesome Tutorial. Flow finally makes sense :D
Thank you for making simple
Thak you! this simplifies my life!!! Excellent tutorial
Thanks for the great video! How can we calculate sum of a column in this table?
Hello Alireza, Please do a video if I want to send only the ones that are of "Electronics" category from your list. Thank you!
Thanks for the great video.. However I would like to know if it is possible to print this table to a newly generated word document in sharepoint library
what a Explanation.
So helpful, thanks! It’s so simple but I struggled with it for so long before lol. I also added in a filter array step before select
Thank you, it is helpful for me
Many Thanks Ali, for sharing this knowledge wih us. The concepts you shown here are very well covered in your course of 'Flow Expressions'. This video is just a real life scenario to be more precise. Thanks a lot again!!
Hi Alireza. is there anyway to transpose the table?
Excelent!
Hi Alireza, how can we modify the output, as you can see the headers are miss-aligned with the rows below it?
Wonderful video as always. How can we select the value for multi select field items?
Thank you very much. But how can I create a table just for one record? instead of using Get ItemS using Get Item. The flow is triggered for a particular record in the list. I haven't been able to get the body / value from that record and display it as a table. Thanks!
hi this is srikanth from india ur good, in the same i need to know the same method with two to three SharePoint list items as a one to many relationship ID, thank you with your good reference
Excelent! , Is possible to filter any field before send email ? like filter only Floppy Disk product ? How can I do that ?
Tks
Sure. Either user "Filter Array" and filter out items you don't need or the better way it to use OData and filter the items at "Get Items" level.
This video shows you how to do it with OData
th-cam.com/video/G6VsL5zVYtc/w-d-xo.html
Alireza, is there a way to go through an excel sheet and weave out rows from a conditional statements and set it into an HTML table? For some reason, I am getting three times the input.
A day before I was thinking of a way to send an html table constructed in the workflow to email. I am one step closer. Thank you!
Hi, i created a manually trigger a flow then get items, but in get items i can find the body column where the jason is written. What should i do?
Thanks. How do you add the clickable, links ?
what if we get a object instead of array in json? select doesnt work on object so whats the alternative?
thank you Mr. Alizera.. may I ask,, what if what I want is not all categories but only electronics and books? please give me advice. thanks very much. God bless you
Watch this video
th-cam.com/video/G6VsL5zVYtc/w-d-xo.html
@@AlirezaAliabadi thank you sir
Thanks for the detailed Demo ,it came handy when i was looking for a similar solution . Looking to group the value based on the author name , can you please show me how to use group by
@alireza : Hi Sir , why did not we applied apply to each to traverse each item in the list . This is super amazing but not i need some insight to better understand the concept . We were creating a variable to club all list data in one email , we did not do that here . Kindly explain
Alireza, I love this video and made a flow that sends me a table of all the meetings I need to schedule. However, I cant figure out how to get a list of displaynames (person 1 name, person 2 name) into the html table. I am able to make the name string using select and join but can't get it into the table! I was thinking of creating a calculated column where it contains the string and then I could do item(). there but do you have any ideas or tips!?
you found a solution to this?
I really liked the video, but I have a question, I cannot add a column in the html table that contains the absoluteuri of an element that I have obtained from the "Get Attachment" component, how could I do it?
Hi I was following this but can you please tell me if I just want one line into a table what should be done ? I dont want the whole list. When a new entry is created i want it to be displayed in a table (just the new entry). Please help
Thank you for sharing the video. I tried it and it's working. But i don't see the json format for the output in the Get Items section.It's showing click to downloads not the json format. Could you please help me out?
Excellent video, easy to follow.
Just been trying to figure out wow would you go about only returning the last item created in a SharePoint list and put that into a HTML table with an email. Currently I can only get it show all list items in the html table. I started the flow with a SharePoint "When a new item is created" and then constructed the flow as per your video. I am sure its straight forward, any chance could you point me in the right direction please?
Hello! Thanks for you gratfull video.
Is it possible to do the reverse process? I mean, transform a HTML table that is inside of a body email, and bring it to a excel table or a sharepoint list.
Thanks!
After adding the Create HTML table step, my only option from the Select Output says "Current Item"? I don't see where I can choose "Output" instead?
Perfect!! Thank you very much , this is working perfectly with me
Que buen tutorial, gracias por compartir tu conocimiento
Saludos desde Chile
Hi Sir, Very Nice video.... and i have one requirement that number of rows in excel sheet with mail ids and want to send each row based on each mail id in HTML format .. Is that possible how to do it?
Hi is there a way to map a excel table into email using flow. I have a file which is getting updated via form submissions. a table within the file is getting updated based on the input. the intention is to copy and paste the table into the email body and sent to the recipients
Great. Can this table also be used in approval? Don't think so as it uses HTML markdown?
th-cam.com/video/ohSyBtu-QYY/w-d-xo.html
That was an amazing example of how to use various functionalities in PA - simple ,straightforward and to the point - a pure beauty.
I just went straight into your course on Udemy which i purchased 2 weeks ago but so far have been going through another course of different author which is far less useful than your video. Big Thanks
Question: what would be an action to use Get Items from SQL server database similar to Get Item from sharepoint (to get the json schema)?
Hi, you have explained a great process to automate an email with list items from share point. Could you please do an video on sharing newly added list items instead of all items. It would be great if you can do the same. Thank you!
I'm looking for the same - but instead of a table with the headers along the top, I'd prefer them vertically.
Thank you sir. Have a question, can we get the table out of excel instead of SharePoint item?
I have a use case that I need to send an email to department owners with the list of items that they own from excel report.
Just forget about Power Automate. Mail merge in Microsoft word can do a much better job.
@@AlirezaAliabadi Please create a video on how to do this.
This was extremely helpful sir!
I learned it so easily! Keep it up.
I am facing a problem though -
My json code does not start from value. It starts from StatusCode then headers then body and only then do i see value. I believe the from property of th select step will need to change right?
It doesn't really matter how the data is structured. You can always parse the JSON to your desired schema using "Parse JSON" or "Select" actions.
Can you help me on how to add a table from excel (Saved on local disk) to email body using power automate. Appreciate your response.thanks
Hi Ali,
Thanks for the wonderful video.
I just finished your 2 hrs course yesterday. Iwas trying to create a test flow by reading data from excel and sending by email in table format. But, it was not working.
I will try the HTML option now. Hopefully it works
Awesome. How would you create an HTML table for the Responses Array when the Approval condition is waiting for all to respond and you have multiple approvers.
Thank you so much Teacher
Many thanks for this video - it covers 90% of what I need. here is question for the remaining 10%.
one of the data from share point list is enhanced rich text. when I added it to html table as you described in the video - tags are not interpreted, tags appear along with the actual text. can you tell me how to fix the issue? thanks in advance.
I am in need of sending a table with a multiline column. Is that possible? I am having issues with it either sending a single line instead of multi. SharePoint list column is set as plain text and powerapp datacard is set as rich text.
Yes it is possible. Simply replace the new line in the string with and you are good to go :)
Awesome tutorial it really helped me, thank you. Is there any way to add borders to our table ?
Yes, wait till Monday and my next video is about styling the table :)
Thank you so much 🙌🙌
I assume, you were waiting for this one :)
th-cam.com/video/K46Msjqnap4/w-d-xo.html
Impressive! Can this also be applied to data from an Excel file?
Enjoyed the video. But these never seem to address handling multi-line list columns.
Alireza, do you know why I'm not getting "Value" as a dynamic option? I have a flow trigger, and I have "Get Item," but when I look through my available "Get Item" dynamic options, "Value" is not an option. If you could help with this, I would be very grateful.
I was using "Get Item" not "Get Items" could you please tell me how to do the same thing with "Get Item?"
Hi Alireza, Thank you for this very useful video, However, could you please tell me how to send email with embed images, I have tried send an email (V2) connector also and I have tried so many things but these are not working.
If you were creating the table for multiple stores in a share point, is there a way to make a table for a store and the products that store needs only instead of all the products from all stores?
Yes, use OData in "Get Items" filter and get only the items you need.
th-cam.com/video/G6VsL5zVYtc/w-d-xo.html
Have you solved aggregating information by a column that is the person's email address and then emailing that user the table?
ótimo assisti em inglês mesmo , estava precisando pegar uma planilha de excel então usei o select para o json e deu tudo certo
Thank you so much lods
Nice! How about attachment? Or the link to them? Have tried for hours now :( Thanks
We want to send mail to a Single email id (it is a distribution group email id) by combining all names of employees who has birthday today. Could you help to achieve this.
How would you do it if you only wanted to list Men's wear from the list?
This is an old video, but should answer your question
th-cam.com/video/G6VsL5zVYtc/w-d-xo.html
@@AlirezaAliabadi Thank you, this was very helpful. I do have another challenge. I am pulling Date/Time from the SharePoint list and would like to convert it to a different format for the email message. I tried in the mapped field of the Select to create an expression: formatdatetime(triggerBody()['StartDateTime'],'MM-dd-yyyy HH:mm') It keeps telling me that I can not use StartDateTime.
Also , in this example , if i would want to apply filter on Person email and share the respective rows belonging to a person , and not the complete data , how do i do that ? e.g 3 rows belongs to John , send data to John and 2 rows belongs to Pooja , send those data to Pooja , how do we apply that filter and share it >
Can you show how to send only one of those rows of data?
Really neat solution. I would love to know if there's a way to strip HTML formatting from items that I select e.g. I have values such as this
"To define and document best practices for the creation of user stories"
What I need to select out would be "To define and document best practices for the creation of user stories"
I am getting this error. Can you please help ?
The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{
"Title": "@item()['Title']",
"JRA #": "@item()['Status']['Value']",
"Test": "@item()['group1']['Value']"
}' failed: 'The template language expression 'item()['group1']['Value']' cannot be evaluated because property 'Value' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'.
Hi Sir, this is really nice tutorial, but i hope it is not too much if i ask some help.
How to make the several columns in Sharepoint turn to rows. Its more on approval, and want to summarize and send to email as HTML.
Example. Sharepoint list columns such as HR department, Finance Department & IT department turn into
HTML
like this format:
Department Status
HR approved
Finance approved
IT approved.
I tried it, but got the result of all 'in one line' or one row when the HTML result received in email, where in the expected result has multiple rows.
Thanks so much Sir.
Looking for the same!
how to do it from excel..? please help
Muito obrigado! Ajudou muito minha vida 😁
Hi, How we can fetch data from sharepoint rest api and crate table in ms flow
Have you watched this video?
th-cam.com/video/l2JGbiNqGgc/w-d-xo.html
Looks good Ali. Waiting to see more complicated scenario. Don't want to offense anyone but that this one is too basic (IMHO) 😊 Thanks!
That's what I thought. If you understand expressions, you find your way in Power Automate, no matter what you do.
Hello Sir, how can I insert borders in the table body. Please can you tell some steps.
You mean this one ;)
th-cam.com/video/K46Msjqnap4/w-d-xo.html
Alireza Aliabadi Thanks 🙂😇
My columns has space in naming and it's not accepting space. Please suggest how to fix example:item().Employe Name. I am getting error,I am capturing output using Excel online, not SharePoint
Ali sir, is there a way to send HTML table in "Approval" email notification?
This is all you can do in Approval email.
th-cam.com/video/ohSyBtu-QYY/w-d-xo.html
Thank you much appreciated
Thank you!
Thank you
Hi Alireza, is there a way to format a number with an expression instead of the Format Number action? It is forcing for an apply to each on an SQL Query. Thank!
Give me specific example.
@@AlirezaAliabadi I'm exceuting a SQL query but the HTML table does not recognize thousands/currency format. So can I = excute query -- Create HTML table and on each field select query items and convert them to currency through a flow expression? Thanks!
@@cristoballoscher4297 That's the way to go. Inside the "Select" action is where you use formatting expressions and convert the numbers to the format that you want.
BTW Coupon has expired
I just updated all the coupons. Sorry for the inconvenience.
I know this is an old video but while trying it a get an error on columns that are choice but can have multiple selections. What should I do in that case since item().ColumnName.Value gives me an error