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!😍
Hi abm - This is great! Thank you so much. Question - for the Compose where you created the body.Row field (10:52 duration in video), how did you make it dynamic? I typed output('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] but it doesnt turn into the green square like yours. It just looks like a string of text
Hi Macy Thanks for watching the video. Place your cursor under the Compose Action step. Then on the right hand side you can see Dynamic and Expression. Click Expression. Type the output('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] then click ok. Let me know if you need further help. Thanks
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 :)
Thanks for this video! I am having trouble at the filter array step. I followed the tutorial, but am receiving error: the from property value in the query action inputs is of type String. The value must be an array.
Hi Looks like your mapping is not quite right. I need to see your flow. I could offer a screenshare to help. Check my channel about section and connect me via teams. Thanks
Thanks for a great tutorial! In the last step, however, I get an incorrect output which is probably due to the fact that I have the Swedish version. Input from agg sum is 13,00 but output is 1300. Is there any way to ensure that the number is formatted in Swedish with comma, as the input?
that amazing, thank u but i have 1 problem is that the value i have in the order header contains spaces ,so when i run the flow i got blank body in the filter array. COULD U HELP ME WITH THIS
Hi Bishara Thanks for the watching the video. So for the spaces you need _x0020_. Please see my video duration 9:38 it shows the JSON data and I have spaces in my header. Order Header will be shown as Order_x0020_Header.
Hi abm- great video by the way. I'm having issue with the HTTP output to show the "ORD100" on mine.. its showing up with weird symbols so its not matching up with my compose output. is there something I'm missing?
Hi abm, When using this flow it will sometimes return no value for the Order Header Value in the first Compose step, even when there is a value in the list. Would you know why this problem exists?
Hi abm- Amazing video. I keep getting this error message at the sum aggregate stage, (Unable to process template language expressions in action 'Sum_Agg' inputs at line '0' and column '0': 'The template language expression 'body('Filter_array')[0]?['Hours.Sum.agg']' cannot be evaluated because array index '0' cannot be selected from empty array.) Any suggestions?
Thanks for the vedio. I have a problem in send an http request action. The render list data as stream have an output of 30 row limit. So I i search for an item located after 30 rows can't be fetched. How could I fetch all the data from list?
Hi Arijeet Could you please explain bit more about how to getting the data? Are you looking to get all the list data from SharePoint? Please explain more about 30 row limit? Thanks
Hi abm, Please can you help me, I added under Expression. outputs('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] then clicked ok. I am not getting the green square, I get the Output as expression.
@@abm4975 I was adding outputs('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] in the expression tab. Also my flow runs fine till Send an HTTP after that I noticed in the output "the project number Project.singleurlencoded": "4295%2E00000000000", is this causing issue ?
in the filter array my values are not matching and in the output the array body is this [] empty. I think the reason is the value is "Month.singleurlencoded": "string%3B%23May" is this
Hello, I reproduced your flow and it was working perfectly until today. I didn't make any changes to it... I took a look at the lookup field I use for filtering and the JSON result has changed. Before it was _x0052_ef1.singleurlencoded: "232308593", now weird digits are added: _x0052_ef1.singleurlencoded: "6%3B%232308593". The filter step fails because it can't match anything with the other list. Any ideas? Thank you
Хобби
Thank you for the wonderful tutorial and the detail explanation of each and every step involved in their.
You're very welcome!
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!😍
Thanks for the support. I don't think you can have two groupings at the same time.
This a wonderful tutorial!! Thank you for explaining everything so well.
Hi Stephanie
You are so welcome!
Thanks
Thank you for the time over teams and assist to resolve the Filter related issue.
No worries. Glad that all working as expected.
Excellent Video - Very easy to follow.
Hi Lynnlynnin
Thanks a lot for the support. Glad it was helpful.
That's amazing! Thanks for sharing keep it up!
Thanks for watching!
This is great, thanks a lot brother
No worries
Hi abm - This is great! Thank you so much. Question - for the Compose where you created the body.Row field (10:52 duration in video), how did you make it dynamic? I typed output('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] but it doesnt turn into the green square like yours. It just looks like a string of text
Hi Macy
Thanks for watching the video. Place your cursor under the Compose Action step. Then on the right hand side you can see Dynamic and Expression. Click Expression. Type the output('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] then click ok. Let me know if you need further help.
Thanks
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 :)
Thanks for this video! I am having trouble at the filter array step. I followed the tutorial, but am receiving error: the from property value in the query action inputs is of type String. The value must be an array.
Hi
Looks like your mapping is not quite right. I need to see your flow. I could offer a screenshare to help. Check my channel about section and connect me via teams.
Thanks
Thanks for a great tutorial! In the last step, however, I get an incorrect output which is probably due to the fact that I have the Swedish version. Input from agg sum is 13,00 but output is 1300. Is there any way to ensure that the number is formatted in Swedish with comma, as the input?
Please have a look
powerautomate.microsoft.com/en-us/blog/simplified-number-formatting/
that amazing, thank u
but i have 1 problem is that the value i have in the order header contains spaces ,so when i run the flow i got blank body in the filter array.
COULD U HELP ME WITH THIS
Hi Bishara
Thanks for the watching the video. So for the spaces you need _x0020_. Please see my video duration 9:38 it shows the JSON data and I have spaces in my header. Order Header will be shown as Order_x0020_Header.
Hi abm- great video by the way. I'm having issue with the HTTP output to show the "ORD100" on mine.. its showing up with weird symbols so its not matching up with my compose output. is there something I'm missing?
Hi
I need to check your flow. Check my channel about section and connect me via email. I will arrange a screenshare and have a look.
Thanks
Hi abm, When using this flow it will sometimes return no value for the Order Header Value in the first Compose step, even when there is a value in the list. Would you know why this problem exists?
Hi Iachlan
Is this for newly created records? Check the cache of SharePoint. That could be the issue.
Hi abm- Amazing video. I keep getting this error message at the sum aggregate stage, (Unable to process template language expressions in action 'Sum_Agg' inputs at line '0' and column '0': 'The template language expression 'body('Filter_array')[0]?['Hours.Sum.agg']' cannot be evaluated because array index '0' cannot be selected from empty array.) Any suggestions?
That is because you don't have any values. If you don't want to throw that error then tyy this
body('Filter_array')[0]?['Hours.Sum.agg']
7:27 hello. I am new to this and when o I follow the example I receive and error 404 - cannot find resources. I am not sure what o could have missed
Hi
I need to see your flow to determine what's going on. Check my channel about section and contact via teams.
For step 'Send_an_HTTP_request_to_Sharepoint' return only 30 rows. May set up url to pull decending modified rows?
Apologies for the late reply. I been away for a family emergency. If you still need help in this please let me know.
Thanks
Is possible to have the info of more than only 30 rows? Thank you for your support 😊
Yes you can
Thanks for the vedio. I have a problem in send an http request action. The render list data as stream have an output of 30 row limit. So I i search for an item located after 30 rows can't be fetched. How could I fetch all the data from list?
Hi Arijeet
Could you please explain bit more about how to getting the data? Are you looking to get all the list data from SharePoint? Please explain more about 30 row limit?
Thanks
@@abm4975 The http request outputs only the first 30 rows in the list. Is there a way it can output more?
Try the following:
List settings > Edit the SharePoint view > Expand Item Limit > Change the default 30 to the number you want.
Hi Arijeet
Try the following:
List settings > Edit the SharePoint view > Expand Item Limit > Change the default 30 to the number you want.
@@abm4975 Thank you sir
Hi abm, Please can you help me, I added under Expression. outputs('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] then clicked ok. I am not getting the green square, I get the Output as expression.
Hi
Believe you adding that as a plain text? Have a look at my video carefully. Expressions are placed under the expression tab.
@@abm4975 I was adding outputs('Send_an_HTTP_request_to_Sharepoint')?['body']?['Row'] in the expression tab. Also my flow runs fine till Send an HTTP after that I noticed in the output "the project number Project.singleurlencoded": "4295%2E00000000000", is this causing issue ?
Hi
Not sure about that. Could you connect via Teams. Check my channel about contact section. I will have a look.
Thanks
@@abm4975 I managed to fix that but now different issue, the filter array output returns 0.
@@abm4975 have posted it under the MS Power Automate community "Filter Array returns Zero"
in the filter array my values are not matching and in the output the array body is this [] empty. I think the reason is the value is "Month.singleurlencoded": "string%3B%23May" is this
Hello, I reproduced your flow and it was working perfectly until today. I didn't make any changes to it... I took a look at the lookup field I use for filtering and the JSON result has changed. Before it was _x0052_ef1.singleurlencoded: "232308593", now weird digits are added: _x0052_ef1.singleurlencoded: "6%3B%232308593". The filter step fails because it can't match anything with the other list. Any ideas? Thank you
Hi
Thanks for the support and question. If you still need help check my channel about section. I could look this into via screenshare.
Thanks
Hello@@abm4975 , thank you for your response. I changed the field and directly went on the lookup value instead. Thank you