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
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?
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
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?
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)?
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 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
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-G6VsL5zVYtc.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.
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
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
@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
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 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 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, 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!
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 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.
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?
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.
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 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.
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.
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.
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.
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
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 >
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
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"
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
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.
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.
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?
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.'.
@@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.
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