cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Add information in the attachment to a sharepoint file

Hello guys , I wonder if you guys can advise me for my case
 
I have users who send email to me to add tables in the database according to a list. The list is written in an excel file along with other information
 
I want for each email that I received from the user about getting new tables on the database, I will add the information ( minus header ) to my current excel file on SharePoint so that I can keep track of the information
 
My logic is on new email from xxx sender with xxx subject, I will use apply to each attachment, I will add the row in the attachment to the table in my SharePoint
 
So far this method does not work and I am not sure why
 
Please help advise me. Thank you very much

 

11 REPLIES 11
Highlighted
Microsoft
Microsoft

Re: Add information in the attachment to a sharepoint file

Could you please provide these information:

  1. What's the type/format of the attachment in your email?
  2. What error message did you get while running your flow?
Highlighted
Frequent Visitor

Re: Add information in the attachment to a sharepoint file

Hello @linxiao ,

 

Thanks for helping me 

 

My original issue was that I did not send an email to trigger the flow. However, once it is triggered I ran into a different issue 

The type of attachment is an excel file 

 

Here is my excel file output , there is the line with all weird text are the one that is added 
Here what the whole part that is added from the flow. From what I see that it was trying to add the whole excel file in the attachment instead of the content within the file

 

UEsDBBQABgAIAAAAIQAVd14gmQEAAKEHAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADElU1LAzEQhu+C/2HJVbppK4hItx78OGrBCl7jZtoNzReZaW3/vdm0FpG1teyClw27ybzvk8nsZHS7NjpbQUDlbMEGeZ9lYEsnlZ0X7HX62LtmGZKwUmhnoWAbQHY7Pj8bTTceMIvRFgtWEfkbzrGswAjMnQcbZ2YuGEHxNcy5F+VCzIEP+/0rXjpLYKlHtQYbj+5hJpaasod1/LwlCaCRZXfbhbVXwYT3WpWCIilfWfnDpbdzyGNkWoOV8ngRMRhvdKhnfjfYxT3H1AQlIZuIQE/CRAy+1vzDhcW7c4v8sEgDpZvNVAnSlUsTM5CjDyAkVgBkdJ7G3Ahlv7gP+KfFyNMw6Bik3l8SPpFj+E8cFOsOeHq2T0WSObJxpI0G7Pr4k+gx50oEkC8U4h/aOcB37SMcJN5jBngaui6/JHrIv1wiOfNmNFcEZhKcx/YMe9FaDwIp2LePpt+wgaF9+bdnuGxdlCcyxF6WDiB29QCnm3+17Tq65/+U+b1jvBFa7xbqO0eCPNV7m6WOkt1gztMFO/4EAAD//wMAUEsDBBQABgAIAAAAIQATXr5lAgEAAN8CAAALAAgCX3JlbHMvLnJlbHMgogQCKKAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArJJNSwMxEIbvgv8hzL072yoi0mwvRehNZP0BMZn9YDeZkKS6/fdGQXShth56nK93nnmZ9Wayo3ijEHt2EpZFCYKcZtO7VsJL/bi4BxGTckaN7EjCgSJsquur9TONKuWh2PU+iqziooQuJf+AGHVHVsWCPblcaThYlXIYWvRKD6olXJXlHYbfGlDNNMXOSAg7cwOiPvi8+bw2N02vact6b8mlIyuQpkTOkFn4kNlC6vM1olahpSTBsH7K6YjK+yJjAx4nWv2f6O9r0VJSRiWFmgOd5vnsOAW0vKRFcxN/3JlGfOcwvDIPp1huL8mi9zGxPWPOV883Es7esvoAAAD//wMAUEsDBBQABgAIAAAAIQCj5W3xHgMAAGsHAAAPAAAAeGwvd29ya2Jvb2sueG1spFXbbqMwEH1faf8B+Z2ACZCAmlS5FG2k7qrq9SVS5YATrILNGtOkqvrvO4aQS7NadVuUGOwxx2dmzgxn55s8M56pLJngA4Q7NjIoj0XC+GqA7m4js4+MUhGekExwOkAvtETnw+/fztZCPi2EeDIAgJcDlCpVhJZVxinNSdkRBeVgWQqZEwVTubLKQlKSlCmlKs8sx7Z9KyeMowYhlB/BEMsli+lUxFVOuWpAJM2IAvplyoqyRcvjj8DlRD5VhRmLvACIBcuYeqlBkZHH4WzFhSSLDNzeYM/YSPj58Mc2DE57EphOjspZLEUplqoD0FZD+sR/bFsYH4VgcxqDjyG5lqTPTOdwx0r6n2Tl77D8PRi2v4yGQVq1VkII3ifRvB03Bw3Pliyj9410DVIUv0iuM5UhIyOlukiYoskA9WAq1nS/4CJDVsW4YhlYHRw4AbKGOzlfSSOhS1Jl6haE3MJDZfh+4Hh6JwhjlCkqOVF0IrgCHW79+qrmauxJKkDhxjX9XTFJobBAX+ArjCQOyaK8Iio1KpkN0CSc35Xg/lxJkneKlOQcz6dizTMBZTY/0Cc5LYb/UCiJtdsW+N1wa57fxwAoyrBV4ZWSBjzPppeQiRvyDHmB7Cfbsp1B4HH3kccyxI+vHrYDN7BH5mjUw6bbjXwzcHHXnETdbn/sOT0/GL+BM9IPY0EqlW5TrqEHyIV0nph+kg1YPG3BdlixZE/j1d5epr6/G1rbm3ZYN7d7RtflXhx6amweGE/EGg4I4ISXdub4WuDr2vbAEpWCj163B1uatR+UrVIg3OvrNSgBzWuAjvhMGz4RXKYejvhYB4TqJgrE6rvBa+Er3akg6rVudHeExq17bR1t0Hyoj5OzBGvnDl+80bvwwW5obbvdTp379ryYZDFUiL7VsAG2nb7eQTfqslT1HcTJwK+x1x/b3cAx3QhHposD2xyPfdf0plHX6+Hp5MKLdFr11yPcaMTlJ5tC36rfpkRVUDC6Vup5qMdou7pbXDYL25gdVUF4PdWubN/+18bovo7KX8+xIBRQIW1ArPY7OfwDAAD//wMAUEsDBBQABgAIAAAAIQBBDDnIHgEAAPEEAAAaAAgBeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHMgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC8lE1rwzAMhu+D/Yfge+Mk3boy6vQyCr1uHexqHOWDxnaw1G359zOBNQsU7xJyMUjC7/sg2drtv3UbfYLDxhrB0jhhERhli8ZUgr2fDqsti5CkKWRrDQjWA7J9fn+3e4VWkr+EddNh5FUMClYTdc+co6pBS4xtB8ZXSuu0JB+6indSnWUFPEuSDXd/NVg+0YyOhWDuWHj/U9955/+1bVk2Cl6sumgwdMOCqwuS1R+69aLSVUCCxfGY5Q2BXscemfHbNOs5ach3CUaSIeTDmYYYnpbuSBaiyeak+bLujDUAjV25ppAPlSBMujBMcE6bpecUpHmckwZr6aB4I+fXBI6zmqRDj+ZhVhjqW7+Vrj8ah/jXnk8WVf4DAAD//wMAUEsDBBQABgAIAAAAIQC2a5rzzgQAAFYZAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1spJlrc6JIFIa/b9X+B4rvEfASo6VOzYQ72aqpvX5GbJUK0G53G5Pa2v++p0EhjeMR3amMEJ9z3m7O2y1yMvvynmfaG2E8pcVct3qmrpEioau02Mz1P353H550jYu4WMUZLchc/yBc/7L4+afZgbJXviVEaKBQ8Lm+FWI3NQyebEke8x7dkQLImrI8FvAr2xh8x0i8KpPyzOib5qORx2mhVwpT1kWDrtdpQmya7HNSiEqEkSwWMH++TXf8pJYnXeTymL3udw8JzXcgsUyzVHyUorqWJ9NgU1AWLzO47ndrGCfaO4OfPvwfnIYp3z8bKU8TRjldix4oG9Wczy9/YkyMOKmVzq+/k4w1NBh5S6WBjVT/vilZo1qr34gN7hR7rMVkudh0n67m+j/m8d8DHC35YjYvJ/avvpitUnBYXpXGyHquf7WmL5alG4tZuYD+TMmBfzrXRLz8jWQkEQQGsXRNrs8lpa8yMIC3TJDkZYCUjBORvpFnkmVz3YHZ8b/LQeAUBjDqET6fn0ZzyxX9nWkrso73mfiVHnySbrYChh3BdcqFMl192IQnsEJh4F5/JFUTmoEEvGp5KrcarLD4vZpquhJbOHvqjcbmwIJwLdlzQfO/juCYXiWCMWUiHA9H3u8N+6Px07VMuM4yE46nTJjc08gaPcoxl4QLN5WXgY4/PKrAsRm/njgXH3K7gERHORi4nNS4kRv0xpY5GYwB3SwHH1elHBxPs7Oast4sNznKwbG52KZkN+tZ8Pla2Q4nzQStoVlacLtevYzkkj8uh8n/qJ91Wl7y5Af+4q4a1SIv948di3gxY/SgwQcbzI7vYnmbsKZSWe6WAZTgx7sFtolM+gpZEMdh574tzJnxBtsxObJvn5mlsufPrK8yW86knE+tPFAjnPOIoRrhnkeM1AjvPOJRjfDPI8ZqRHAe8aRGhOcREzUiOo+wWoV8UQrZVNIA52r7wLE77IOsushWy4dvCmyV7xmDNgYdDLoY9DDoYzDAYIjBSNZ1rishrdX4UoUoJjXLUTFJ3sZu32OQddkkBbZNwqCNQXnDbcZsyboY9DDoYzDAYIjBSNb1iklVSBeT4K55h0mQddkkBbZNwqCNQQeDLgY9DPoYDDAYYjCSdb1iUhXSxST5xeP2nQRZl01SYNskDNoYdDDoYtDDoI/BAIMhBiNZ1ysmVSFdTHq8yyTIumySAtsmYdDGoINBF4MeBn0MBhgMMRjJul4xqQrpYhJ8q79jJ0HWZZMU2DYJgzYGHQy6GPQw6GMwwGCIwUjW9YpJVUgXk2SL5/aPO8i6bJIC2yZh0Magg0EXgx4GfQwGGAwxGMm6XjGpCuliEjyB3mESZF02SYFtkzBoY9DBoItBD4M+BgMMhhiMZF2vmFSFdDFJPt7f85wLaZdtkqIXvy4/o9RGqYNSF6UeSn2UBigNURqVJb5i2DGmk2PyCfmOzoSi3X62hT4l5hhGbTTXQamLUg+lPkoDlIYojSS9tsWOMahjVVu2aivt4g35JWabtOBaRtZlmxVueKzqw5o9efOkO9l8lV3EJRXQTT39toU/QhBoL5k9eGxbUypOv0CTFrrIGfkeM8G1hO5l+9aC7lP9rsamsofNglXZiTaacGhN1X8RWfwHAAD//wMAUEsDBBQABgAIAAAAIQDdteF0cwIAAKMHAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1snNVfb5swEADw90n7DsjvCX9CkgYBFU1TrQ+bpmnbu2MOYhUws52k1bTvvjNR3GyhElQKih2On+34zsS3z3XlHEAqLpqE+FOPONAwkfOmTMiP7w+TG+IoTZucVqKBhLyAIrfpxw/xUcgntQPQDgqNSshO6zZyXcV2UFM1FS00eKcQsqYau7J0VSuB5t1DdeUGnrdwa8obchIiOcQQRcEZ3Au2r6HRJ0RCRTXOX+14q85azYZwNZVP+3bCRN0iseUV1y8dSpyaRY9lIyTdVrjuZz+kzHmW+Anwmp2H6X6/GqnmTAolCj1F2T3N+Xr5K3flUmal6/UPYvzQlXDgZgNfqeB9U/Ln1gpesdk7sYXFzN8loz3PE/I7W2Z3XuhtJuvNbDYJ1w/zyepumWFruck2c7zthX9IGuccd9isypFQJCTzo8wPiJvGXQL95HBUF23H5ONWiCdz4xHH8ZBQUAEzmeFQ/DrAGqoqIWt/jjn9q1OxHX3BPrKudS/b5zEeujz+Kp0cCrqv9Ddx/AS83GksGuS6NIjyl3tQDPMSh58Gndqh91TTNJbi6OAe+zh4S03F+BG2+59MY2ZiMwxATOFaDqkXuwecGsMLKevhRg33MNh6fr+HezXcw2DrBf1eOMbDYOvN+j2zeYP/Pwy2XtjvLcZ4GGy9eb+3HONhsPUW/Z45gAevF4Ott+z3VmM8DLbeTb/n4ytjREJjtBVXb4jjSuSyRvw3igRPjjGT/KdM/q+T00FxqumWlvCZypI3yqmg6Aof91SeTgZvavZXtOY4WGIqboXWoj73dvgyBCxyb4pVVAihzx1zGNnXa/oXAAD//wMAUEsDBBQABgAIAAAAIQDBFxC+TgcAAMYgAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbOxZzYsbNxS/F/o/DHN3/DXjjyXe4M9sk90kZJ2UHLW27FFWMzKSvBsTAiU59VIopKWXQm89lNJAAw299I8JJLTpH9EnzdgjreUkm2xKWnYNi0f+vaen955+evN08dK9mHpHmAvCkpZfvlDyPZyM2Jgk05Z/azgoNHxPSJSMEWUJbvkLLPxL259+chFtyQjH2AP5RGyhlh9JOdsqFsUIhpG4wGY4gd8mjMdIwiOfFsccHYPemBYrpVKtGCOS+F6CYlB7fTIhI+wNlUp/e6m8T+ExkUINjCjfV6qxJaGx48OyQoiF6FLuHSHa8mGeMTse4nvS9ygSEn5o+SX95xe3LxbRViZE5QZZQ26g/zK5TGB8WNFz8unBatIgCINae6VfA6hcx/Xr/Vq/ttKnAWg0gpWmttg665VukGENUPrVobtX71XLFt7QX12zuR2qj4XXoFR/sIYfDLrgRQuvQSk+XMOHnWanZ+vXoBRfW8PXS+1eULf0a1BESXK4hi6FtWp3udoVZMLojhPeDINBvZIpz1GQDavsUlNMWCI35VqM7jI+AIACUiRJ4snFDE/QCLK4iyg54MTbJdMIEm+GEiZguFQpDUpV+K8+gf6mI4q2MDKklV1giVgbUvZ4YsTJTLb8K6DVNyAvnj17/vDp84e/PX/06PnDX7K5tSpLbgclU1Pu1Y9f//39F95fv/7w6vE36dQn8cLEv/z5y5e///E69bDi3BUvvn3y8umTF9999edPjx3a2xwdmPAhibHwruFj7yaLYYEO+/EBP53EMELEkkAR6Hao7svIAl5bIOrCdbDtwtscWMYFvDy/a9m6H/G5JI6Zr0axBdxjjHYYdzrgqprL8PBwnkzdk/O5ibuJ0JFr7i5KrAD35zOgV+JS2Y2wZeYNihKJpjjB0lO/sUOMHau7Q4jl1z0y4kywifTuEK+DiNMlQ3JgJVIutENiiMvCZSCE2vLN3m2vw6hr1T18ZCNhWyDqMH6IqeXGy2guUexSOUQxNR2+i2TkMnJ/wUcmri8kRHqKKfP6YyyES+Y6h/UaQb8KDOMO+x5dxDaSS3Lo0rmLGDORPXbYjVA8c9pMksjEfiYOIUWRd4NJF3yP2TtEPUMcULIx3LcJtsL9ZiK4BeRqmpQniPplzh2xvIyZvR8XdIKwi2XaPLbYtc2JMzs686mV2rsYU3SMxhh7tz5zWNBhM8vnudFXImCVHexKrCvIzlX1nGABZZKqa9YpcpcIK2X38ZRtsGdvcYJ4FiiJEd+k+RpE3UpdOOWcVHqdjg5N4DUC5R/ki9Mp1wXoMJK7v0nrjQhZZ5d6Fu58XXArfm+zx2Bf3j3tvgQZfGoZIPa39s0QUWuCPGGGCAoMF92CiBX+XESdq1ps7pSb2Js2DwMURla9E5PkjcXPibIn/HfKHncBcwYFj1vx+5Q6myhl50SBswn3Hyxremie3MBwkqxz1nlVc17V+P/7qmbTXj6vZc5rmfNaxvX29UFqmbx8gcom7/Lonk+8seUzIZTuywXFu0J3fQS80YwHMKjbUbonuWoBziL4mjWYLNyUIy3jcSY/JzLaj9AMWkNl3cCcikz1VHgzJqBjpId1KxWf0K37TvN4j43TTme5rLqaqQsFkvl4KVyNQ5dKpuhaPe/erdTrfuhUd1mXBijZ0xhhTGYbUXUYUV8OQhReZ4Re2ZlY0XRY0VDql6FaRnHlCjBtFRV45fbgRb3lh0HaQYZmHJTnYxWntJm8jK4KzplGepMzqZkBUGIvMyCPdFPZunF5anVpqr1FpC0jjHSzjTDSMIIX4Sw7zZb7Wca6mYfUMk+5YrkbcjPqjQ8Ra0UiJ7iBJiZT0MQ7bvm1agi3KiM0a/kT6BjD13gGuSPUWxeiU7h2GUmebvh3YZYZF7KHRJQ6XJNOygYxkZh7lMQtXy1/lQ000RyibStXgBA+WuOaQCsfm3EQdDvIeDLBI2mG3RhRnk4fgeFTrnD+qsXfHawk2RzCvR+Nj70DOuc3EaRYWC8rB46JgIuDcurNMYGbsBWR5fl34mDKaNe8itI5lI4jOotQdqKYZJ7CNYmuzNFPKx8YT9mawaHrLjyYqgP2vU/dNx/VynMGaeZnpsUq6tR0k+mHO+QNq/JD1LIqpW79Ti1yrmsuuQ4S1XlKvOHUfYsDwTAtn8wyTVm8TsOKs7NR27QzLAgMT9Q2+G11Rjg98a4nP8idzFp1QCzrSp34+srcvNVmB3eBPHpwfzinUuhQQm+XIyj60hvIlDZgi9yTWY0I37w5Jy3/filsB91K2C2UGmG/EFSDUqERtquFdhhWy/2wXOp1Kg/gYJFRXA7T6/oBXGHQRXZpr8fXLu7j5S3NhRGLi0xfzBe14frivlzZfHHvESCd+7XKoFltdmqFZrU9KAS9TqPQ7NY6hV6tW+8Net2w0Rw88L0jDQ7a1W5Q6zcKtXK3WwhqJWV+o1moB5VKO6i3G/2g/SArY2DlKX1kvgD3aru2/wEAAP//AwBQSwMEFAAGAAgAAAAhAN9Nz/2kAwAAGg8AAA0AAAB4bC9zdHlsZXMueG1s7Ffdb9s2EH8fsP+B4LtCSbE825BU1HGEFci6YvGAvdISZXPhh0BRqdyh/3uPlBUr69qu6atfbPJ0n7+745Hpq14K9MhMy7XKcHQVYsRUqSuu9hn+c1sEC4xaS1VFhVYsw0fW4lf5zz+lrT0Kdn9gzCJQodoMH6xtVoS05YFJ2l7phin4UmsjqYWt2ZO2MYxWrROSgsRhOCeScoUHDStZ/h8lkpqHrglKLRtq+Y4Lbo9eF0ayXL3ZK23oToCrfTSjJeqjuYlRb0YjnvqZHclLo1td2yvQS3Rd85J97u6SLAktz5pA88s0RQkJ42ex9+aFmmbEsEfu0ofztNbKtqjUnbIZjsFRB8HqQen3qnCfIMMnrjxtP6BHKoASYZKnpRbaIAupA+Q8RVHJBo4bKvjOcMdWU8nFcSDHjuCzfeKTHLB3ROL8GLzJ085xfcVW6CR+3Ji32YJRLsQEgoGQp1ArlhlVwFd0Wm+PDcSqoKwHn+HTN7n3hh6jOJkIEG8wT3faVNBGI/gO54GUp4LVFmI0fH9w/1Y38LvT1kKp5WnF6V4rKhxuo8RpAeGUTIh712p/1c+i6mukOllI+6bKMDStQ3xcQiCn5aBv2ID+LwlFIP/fQog2jTi+7eSOmcJ3srfmqQ7L827t4z/vXwu+V5K5QgT3vMA7oy0rrT9pfNbJNLoh1kmY1wDh94eJ+vqb8Tq8vhDvKD14PAnCJRT6YIgJvTe02bIegvO9Qvr6RegO1gB+j893WfPYAVqTEnlWIE/QItdbGf4Vqt0Irh7gVPAIgdVdx4XlyuG18IfAWGwnmbcu42IUANQmAv9KIPhR9ecShUPFE6aYHbThH6BM3aGzZ4oZpxpGj+WlIw0NgZEFWP/QFs52N5HA6BRrxFU11tTfXWt5fbyjrb3jbjYBb3swEOJWF3yoOzdvYJT97nrTMbgmAz8vvl1wu9TbpRfQ5Qy5nL3P5oKbDjDLrHtC+HvX01CF6VKxmnbCbp8+Zvi8/o1VvJNw6T5xveOP2noVGT6vB66lG0Qw5+5auCbDP+oMz/A/t+tflpvbIg4W4XoRzK5ZEiyT9SZIZjfrzaZYhnF483HykPmBZ4x/d8GdJZqtWgGPHXMK9uT8/ZmW4cnmzt1hhysPuD31fRnPw9dJFAbFdRgFszldBIv5dRIUSRRv5rP1bVIkE9+TFz53QhJFw8PJOZ+sLJcMbjVjrsYMTamQJNh+JQgyZoKcH7X5JwAAAP//AwBQSwMEFAAGAAgAAAAhAJe0qGo3AQAAXQIAABQAAAB4bC9zaGFyZWRTdHJpbmdzLnhtbGyS3UoDMRCF7wXfYci9m1ZKkbK7VSpFwZvW+gDT3bEJ5GfNzC727U1VEHa9zHc4k5MzKdef3sFAiW0MlZoXMwUUmtjacKrU22F7c6eABUOLLgaq1JlYrevrq5JZIHsDV8qIdCutuTHkkYvYUcjKe0weJR/TSXOXCFs2ROKdvp3NltqjDQqa2AfJ9y4WCvpgP3ra/JKlqku2dSn1I3WYxFOQUktd6gv9UQ54dDSGr98xJnT3Arue0nksbKLrfQCJYJDNWH3KDB7cKSYrxk+GUmArdrByBodHcv9laftpxj1Jfk6ufGzYWkfQoUyCvDElyPVaB9g0xAzO8qSQPeUGWWIaz30+jIkk9EVn0If5vYmemkStlWIYR7osecUdNnn5eYs5xkCqvrhhPBL/gM7fo/4CAAD//wMAUEsDBBQABgAIAAAAIQConPUAvAAAACUBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDEueG1sLnJlbHOEj8EKwjAQRO+C/xD2btJ6EJGmvYjQq+gHrOm2DbZJyEbRvzfgRUHwNOwO+2anah7zJO4U2XqnoZQFCHLGd9YNGs6nw2oLghO6DifvSMOTGJp6uaiONGHKRzzawCJTHGsYUwo7pdiMNCNLH8hlp/dxxpTHOKiA5ooDqXVRbFT8ZED9xRRtpyG2XQni9Aw5+T/b9701tPfmNpNLPyJUwstEGYhxoKRByveG31LK/CyoulJf5eoXAAAA//8DAFBLAwQUAAYACAAAACEAaRGWbMADAADNBwAAFAAAAHhsL3RhYmxlcy90YWJsZTEueG1snFXbbts4FHxfYP9B0DtjkeI1iFNQpIgGCBZo036AYtOxUF28Ip3GWPTfe2Q7trXxw2LfrCNzZjjnnNHdp7e2SV79EOq+m6f4JksT3y36Zd29zNPv3xySaRJi1S2rpu/8PN35kH66//OPu1g9Nz6B012Yp+sYN7ezWVisfVuFm37jO3iz6oe2ivA4vMzCZvDVMqy9j20zI1nGZ21Vd+kB4bZd/BeQthp+bDdo0bebKtbPdVPH3R4rTdrF7cNL1w+jqnn6NiRvQ/4O/jZ8AG/rxdCHfhVvAGzWr1b1wn/QiOls8K/1aM0ZKv+fWPyEBbrqJXgNmMPtdvz5D1fGFQ4zpKgoEMWcICmkQE5JzjnNMMb0V5p0VQuX+zbeEU4v67Bpqt1fk+LgV/NU49tHDP+Ifaya8LX/+bTuf0J7oblr6IIfoGTfVg+jCqgtq1gdH1V6f1dtY+/qJvohmaCd1BpHMq0sBqGaIFpwh7RkAuVOY8GxMTgzv9LZ/WFGTN9s2y4ki37bRSAkQLEfnsOLsxf50QzmFKeYlsgwrBHVmUXSKo5MTpTMS8lxRk5mWL+phtj6Lv6LcI9LRo/fcUunDZdSIceZQZQUFGlSYORMwYnNQTflU5OvQY5TdYLUDMvCSIwIptC3TGqkLZYIcyEslyxj2blvT/vtuIZJLzEVV5QWgOmwKBFVTiDJGUVGUsoFLjWz6iTz6ctj8mXrh92ki/IaCZt4YajkpbGAn4MXmc6QctYhC84zbHVGyNmLY6Nin6yrsJ4wiWtM/JLJGVGwQhWIlUUGE8MKGBZwHTtVwoW4ZbY8Xecz4Ce6eemHOq7bCRO/xiQumYiwLLOWIMELiahREF7O5Si3mEA/cAa7dTbOd6GO9SskSNJUz76ZkLFrZJCEl8NksBaKINgDWIS8xKgwmCIsswxGVFumYQeOGzt2frlt/ISDXuNQE+u4VEblORJknC7sOEwCtwgLV2LFSk6ZPXF89RGWYB9VF/ucXyMZd/58E0yUptrBqGnoDTWcwyhojGAOFWWCFJy5Ewvkgk8gfKdTQK6y7APuffmUcKDaQVwwLUa/KJI6Z4hZI7imlJb4vNTfA2QPfEnqJqkWCx9C0tQhTtwb8w9iy/imeYq7MfM/7zZ+aOrux1UxkySQRhLIMIOso7ACBaeokDaDuM14Dt8myBl8YezfWx9iP0z4s5FldpFj4ZhqezUP3aq/TOt98bF+WUfQHSCMXT2EeNirfSyPtcfqQ2mM7jjUGw/f2OPJw6FT9ULH/W8AAAD//wMAUEsDBBQABgAIAAAAIQB/i0PDwAAAACIBAAATACgAY3VzdG9tWG1sL2l0ZW0xLnhtbCCiJAAooCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACMzz9rw0AMh+GvYm7PyWmgLcZ2hq4JFLp0FWedfZCTjpNS5+O3Lv03dtPyPj/UH2/50rxR1SQ8uL1vXUMcZEo8D+5qcffojmNfulKlULVE2nwUrF0Z3GJWOgANC2VUn1OoohLNB8kgMaZAcNe295DJcEJD+FXcF3PT9AOt6+rXg5c6b9keXs+nl097l1gNOdB3VcL/1hNHKWjL5j3AM1Zjqk/CVuWibuwnCddMbGdknGm7YOzh77fjOwAAAP//AwBQSwMEFAAGAAgAAAAhAD/YhYYFAQAAqQEAABgAKABjdXN0b21YbWwvaXRlbVByb3BzMS54bWwgoiQAKKAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAApJBPa8MwDMXvg32H4HtiN1nXPzQpbUKgtzE22NU4cmOIrWArYzD23eesu3Q79iSehH7vSbv9hx2Sd/DBoCvZIhMsAaewM+5csteXNl2zJJB0nRzQQckcsn11f7frwraTJAOhhxOBTWLDxHpqSvYpRF60q2KZNkUr0gchVulmuajT9aZujse8OBza+osl0dpFTChZTzRuOQ+qBytDhiO4ONToraQo/Zmj1kZBg2qy4IjnQjxyNUV7+2YHVs15LtvPoMO1nKNN3vxzsUZ5DKgpU2h/DS5gCyTn6/joYxRPBgLjN0CN0zhK6mf6ij9JTw58jY48Dj9k/if+rK/eW30DAAD//wMAUEsDBBQABgAIAAAAIQC9hGIjkAAAANsAAAATACgAY3VzdG9tWG1sL2l0ZW0yLnhtbCCiJAAooCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABsjjsOwjAQBa+C0pMt6NDiNIEKUeUCxjiKpazX8i4f3x4HQYGUep5mHnYkvHUc1UcdSvKdwRNnGjyl2aqXzYvmKIdmUk17AHGTJystBZdZeNTWMYFMNvvEISo8dvC1abXBWF3SGOyDVF8xPbs71dQ5XLPNZUkh/CAeb0HXJx+CF/9cxwtA+Dtu3gAAAP//AwBQSwMEFAAGAAgAAAAhAM5d/bTzAAAATwEAABgAKABjdXN0b21YbWwvaXRlbVByb3BzMi54bWwgoiQAKKAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZJBBa4NAEIXvhfwH2buutbGJQQ2aNZBraaHXZR3jgrsjO2toKf3vXekp7Wl485j3PaY8fpgpuoEjjbZij0nKIrAKe22vFXt7Pcd7FpGXtpcTWqiYRXasNw9lT4deekkeHVw8mCgsdJgXUbGv3S7rRJcVcSfaJt62eRHvxTaL867J26w4NaI5f7MooG2IoYqN3s8HzkmNYCQlOIMN5oDOSB+ku3IcBq1AoFoMWM+zNH3magl4824mVq99fq9fYKB7uVZbnP5HMVo5JBx8otBwGqWDGXUIvz1xhdYHjv+cga81iPG65H8gq757Qv0DAAD//wMAUEsDBBQABgAIAAAAIQC6LqX0lwcAAIAlAAATACgAY3VzdG9tWG1sL2l0ZW0zLnhtbCCiJAAooCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADsWktv2zgQvhfofxC0Z1u2/JKNOkUSJ0CApg022cetoCjK1lavklTi/PsdihL1smxZye5hsc2hscwZDocz33wzyqfP+8DXngllXhSu9fFwpGskxJHjhdu1nnB3YOmfLz5hvsJRyEnIn15j8oh3JEAaPPy+1nUtQOr/0qKvKCBrfRPhJACxdFXp27vNWh/tR2P4GVnXt5eLm9FkfrW5vr2aLqybm+urqTW7MS/Ny/lkU5f9Pbd2Wv9mQximXszTs1xTgjjRkBaSF83J7BjWRR5xFIOd6ePMDcI2MncxmY8Wk4llIXuCrekUW3i5JMuFuUDY0TXwW8hWmK/1HefxyjBY6hU2DDxMIxa5fIijwIhc18PEMEejuREQjhzEkVFyRK4oQH0UxRSsp9wjLFV+yTn17IQTpl98/PBpz5yVtErjiG4JF3fCYoThwOcbXeyVOotGEZyd04SkH12P+A4TrsPuZD51EXGQNV7OrfmcmO7cnWLTsWYTPFrqWshMGTEhm8hfpDPBXmXYy8vL8GUyjOhW+G5s/Hn/RYZd7rA96742fut5pX1g91o3rZFt2jNzYC2JNZg6ljlAFrIGaGnPXOzgkTud5DbC+db6xHSd+cJdDGZoDgJkaQ6WUzwfjO35jNhkPrGmrrouL4gjyrWwuKhO+xn5dTflO22v5IlPRLqmBqz10pXnG0BMxz7ZCxhQIUZ+JoAZ6nNVR5559yhE21S5OuwBXcj3c7W5GkrctS5C5p44Hnok9BkS6j5LJYg9L/yGcUIhHEZ64xwHhW8R42cqmKwed4gS5w+P735jAEAdNy7LbcBmzz8oaYhUzc6e/l5zTfosc4jwT/qZlfzeXShFqVPo0C3IM4NuIxpsiIsSHwDhZ4J8D8BAIeQ/ltROUCDAaexthqHBIYbhNmRux7gbRnihG8WI7wQqLYwHRHlI6DXURhrB1banYWe8bTX0SI53UX7c8BYAaEk5tPJCh+zXugVg7vk+sn0oKaoWOB6LffQqGUCrip3nOAQ4hxLzgGDQEPkn5KCsO99C/zWTVKEM0OeTMi5RwqAcYsEGNBsxsBBCZvU14kTihEyiilg9z0RaVuGsfJwajiiviBJ3hlcaas7wTEP23/SOdGAnQOlUhbT/AeW/DijNKqqyZgytx6m0keKaqMIp66xCxiHlLflwgHpkjwSWAwNSLGQPn0RzVIIQQQDuodp5Bcs+SoHE+juoGzXOAI3TPqcuSWhHCWCqc4wclQt+E5k2Berqmqhtaz1tAAADw+0puiII51q/xBis4HdQvKUCAZip9fCkQrTqN9VSPzKFApW72fQGYlNnQyS/OUWYmjfchTY1PV3EWUHpijAenxXGWlVFuQIe3uY9AD4PbgjALyTc8p32jPwEAsCczUq1sVRAC9J5tF6eURFqnAX62BCYmAtcEnGW9n3QqP6AlqHRO1MyKPeiJ4oGynviCk1NwhJRtf0I/1AM9hfg4RkrbFDC/lb26nC90y3uwAsZR9B95UTWKYhsnFA/9aSDjcxLzBgPx0axFuKtRKPLAuk3amUEtPQEQc6x2IjsAsWa/Wh270dsk2T+S4SRHORkEk5i+x6MpihJz5RRfgMcy4yfcEIg5BNjNDVGpuHgIWRt0Q12siI/8Htsn+qq2lClkeIYD2p4k2Pj9dP32hcKV0sFK2vOm4vztG5roh28wmIoFtEjlWjc0kQ7OD2U1CDau2o9KNWydg0rDxg/F+3hmRbI8lQZmx3Z/lD1U/gMLAMGlpUWJSv5WlqmDo8QwHXc476YdZXnDeUSDrgPirPGSI4mK7s8pfKt6lli/0WwGJS2b9Aq7BSDz/MUSMf+IK8vEXXqo4na6RqcotUcH4XbBKC7jy2Q9WQb0dfjnj5tizxZNtJ9H2WUPHuCCp6pTaVlGEY8xbT8Sd7r5w+1ln9PO4/JEq1BfHnCRUzjO6KFSWATqkWuxtAzPIuolhvJhtoTrEBx7AsBwWBBCZT0OAI+Cw27BrVWS2IYSAM/BG1qC+RCpmsE4Z1SNvz44ZBpcg5VP4V8iiqnPd1Y+2IoB+8dxOzo6s23n879csgKMrW9wlG2A49wcUmv/Og02pM1R4bFm0b2x6c8pxrsDlzpPadl2eit0yQ/8021ij7AIBbSMfuu0dOtqg2TmuSkwRHjVaVjqsDuhYjhfH1t61y61Cz1lZV90XFpYUht0gvv4ipD+HZbJQge7AxXYjgGjeGxo7Z0hcKiM4WrHWB3cXgleMlYhD2APOcGuAN/7X3doCvT0F5jS314PQTqFwFeUPkCQAkvKSCk5AbqPVvmXbUuC6Vjcp1FHl8ZJ8FdRv/Flp1Fc5dCUWiTE6c9GWbFOWSk1E+viFj1wtvdUVdTDA3O03DANz1tqbuqo5oqThWR1xeqpGffBlhSRx4wvxKXUPHarlYVu0BfpskRlLfMVs+RNd8gCy9Ye+8rmHlfm2enZN8BrA/cdE52u8Nm61X3ViXuur8wXHZ/Ybjt/sJw3f2F4b7PF34SI5XeRUpId58Vn6pRnVC8ilXKgL5QJRSkVeX8PEv3ro8WGqDyDklW2NjvfosJ+REulNqp3o4Zh/6G6uJvAAAA//8DAFBLAwQUAAYACAAAACEADSd8hrsBAAB9BAAAGAAoAGN1c3RvbVhtbC9pdGVtUHJvcHMzLnhtbCCiJAAooCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC0lF9r2zAUxd8H+w5G77L8P3KpU9JkgcIKZWuhr7J0lZhZkpHkZWPsu092O0bblGxsezLX4p5z7/FPPr/4ovroM1jXGd2gNE5QBJob0eldg+5ut5iiyHmmBeuNhgZpgy6Wb9+cC3cmmGfOGwtXHlQUXnThebVp0Le0SNfVZkvxKilWuKB1jVfbRY2r9WW9fldWl/Um/46iYK2DjGvQ3vvhjBDH96CYi80AOhxKYxXzobQ7YqTsOGwMHxVoT7IkqQgfg726Vz1aTvM8dH8A6Z6W02ij7V64qI5b44z0MTfq0eBBWIFn03aEG+2D3e3XARD5Z6qDDQta34Ejk9PKe9u1owd3yuNwOMSHfM4jBJCS++v3H+fI/stwr4pmNGmztswwrYHiQtAMM8ooZnVbSi54Iov81eY8k6JayAUuWRWaoc5wXfAKp21VQgtVTgv59+uIR1CumWY7mJHx4SOeTPgngUfZ6LQ0A/P7CZIFuWHWa7DrgIg1/W8rH2F7YPxTmPIFexbwL1ROZTKMtp/JEJxAP6/sSBqn5E8aPVjlTnYcD6kLV8Vq1hPTismTPLuSU/3kl7H8AQAA//8DAFBLAwQUAAYACAAAACEApCkL5J8BAAApAwAAEQAIAWRvY1Byb3BzL2NvcmUueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAjFLLbtswELwXyD8IPLUHmZRtJAFhK0BT5NQEAeKkRW8suZHZiA+Q6yj6+1KiI9tFDr0I3J3Z0XC4q6s30xavEKJ2dk2qGSMFWOmUts2aPG5uyktSRBRWidZZWJMeIrmqzz6tpOfSBbgPzkNADbFISjZy6ddki+g5pVFuwYg4SwybwGcXjMBUhoZ6IV9EA3TO2Dk1gEIJFHQQLP2kSPaSSk6SfhfaUUBJCi0YsBhpNavogYsQTPxwYESOmEZj79Od9naPtZXM4MR+i3oidl036xajjeS/oj9vvz+MVy21HbKSQOqVkhw1tlCv6OGYTnH3+w9IzO2pSIAMINCFDExFivkF+s4FFRNyUqUZBVEG7TE9Xp47aSR2KyLeptd81qC+9vUmCFPcb9PnrnGy+Px092UU/Yc2PG6AVz0sRf7roVJyjDHbBVWkYHiO8R35sbj+trkh9ZzNWckuyvliw5Z8wfiS/RrCOJkfgsoNs7f5f4rVki/PObs8UnwXqMfdFAiNC322L6dqXFuLaW8eUOBuH6p0H7SOl7v+CwAA//8DAFBLAwQUAAYACAAAACEApFbfEKcBAABpAwAAEAAIAWRvY1Byb3BzL2FwcC54bWwgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACck8Fu2zAMhu8D9g6G7o2cbCiGQFaxpRt6WLEASbszK9OxUFnyJMZI9vSjbdR11sOA3Uj+xI+PpKRuTo3LOozJBl+I5SIXGXoTSusPhXjYf7v6JLJE4EtwwWMhzpjEjX7/Tm1jaDGSxZSxhU+FqInatZTJ1NhAWrDsWalCbIA4jQcZqsoavA3m2KAnucrza4knQl9iedVOhmJ0XHf0v6ZlMD1fetyfWwbW6nPbOmuAeEp9b00MKVSUfT0ZdErORcV0OzTHaOmscyXnqdoZcLhhY12BS6jka0HdIfRL24KNSauO1h0aCjFL9jevbSWyJ0jY4xSig2jBE2P1bWMyxK5NFPXPEJ9TjUhJSW4Yi0M4753H9qNeDQ0cXDb2BiMIC5eIe0sO049qC5H+RTwwjLwjDsGTwyzir6ON2B9zjjpB7/oplm+mGBbDPH8R3IOHA0YWpmgTmhb8mUtT9N365/TQ7sMtEL7c4bKodjVELPl0052mgrrjE0THJl/4Hv1SLvMpTZsa/AHLF4u3Qv+oHsefo5fXi/xDzu9lVlPy9Y/oPwAAAP//AwBQSwMEFAAGAAgAAAAhAMW6MEkPAQAAkgEAABMACAFkb2NQcm9wcy9jdXN0b20ueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAnNBNb4MwDAbg+6T9hyh3GhMKBQRUEEDabYdudwShRSIJIikrmvbfF7SP3nu0bD967eR4EyNa+KwHJVPs7gAjLlvVDfKc4rdT7YQYadPIrhmV5CleucbH7PkpeZ3VxGczcI0sIXWKL8ZMMSG6vXDR6J1tS9vp1SwaY8v5TFTfDy0vVXsVXBpCAQLSXrVRwpn+OfzjxYt5lOxUu6XT76d1snGz5BdfUS/M0KX4s/RZWfrgO7SKmOOCWziRFx0cCAFoQVkd5dUXRtM2TDGSjbCnMyWNjb2hL51VFxOP04c2cwY3sAZAyOr8UIEXFCWri/0hrCpW7EO/ojnNA69MyH0nIX+psoTcn5l9AwAA//8DAFBLAwQUAAYACAAAACEAdD85esIAAAAoAQAAHgAIAWN1c3RvbVhtbC9fcmVscy9pdGVtMS54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAITPwYoCMQwG4LvgO5Tcnc54EJHpeFkWvIm44LV0MjPFaVOaKPr2Fk8rLOwxCfn+pN0/wqzumNlTNNBUNSiMjnofRwM/5+/VFhSLjb2dKaKBJzLsu+WiPeFspSzx5BOrokQ2MImkndbsJgyWK0oYy2SgHKyUMo86WXe1I+p1XW90/m1A92GqQ28gH/oG1PmZSvL/Ng2Dd/hF7hYwyh8R2t1YKFzCfMyUuMg2jygGvGB4t5qq3Au6a/XHf90LAAD//wMAUEsDBBQABgAIAAAAIQBcliciwwAAACgBAAAeAAgBY3VzdG9tWG1sL19yZWxzL2l0ZW0yLnhtbC5yZWxzIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAhM/BasMwDAbge6HvYHRfnPYwSonTSxnkNkYLvRpHSUxjy1hKad9+pqcWBjtKQt8vNYd7mNUNM3uKBjZVDQqjo97H0cD59PWxA8ViY29nimjggQyHdr1qfnC2UpZ48olVUSIbmETSXmt2EwbLFSWMZTJQDlZKmUedrLvaEfW2rj91fjWgfTNV1xvIXb8BdXqkkvy/TcPgHR7JLQGj/BGh3cJC4RLm70yJi2zziGLAC4Zna1uVe0G3jX77r/0FAAD//wMAUEsDBBQABgAIAAAAIQB78wKjwwAAACgBAAAeAAgBY3VzdG9tWG1sL19yZWxzL2l0ZW0zLnhtbC5yZWxzIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAhM/BasMwDAbge2HvYHRfnHQwSonTyyjkNkYHuxpHccxiy1jqWN9+pqcWBj1KQt8v9YffuKofLBwoGeiaFhQmR1NI3sDn6fi8A8Vi02RXSmjgggyH4WnTf+BqpS7xEjKrqiQ2sIjkvdbsFoyWG8qY6mSmEq3Usnidrfu2HvW2bV91uTVguDPVOBko49SBOl1yTX5s0zwHh2/kzhGT/BOh3ZmF4ldc3wtlrrItHsVAEIzX1ktT7wU99Pruv+EPAAD//wMAUEsBAi0AFAAGAAgAAAAhABV3XiCZAQAAoQcAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAYACAAAACEAE16+ZQIBAADfAgAACwAAAAAAAAAAAAAAAADSAwAAX3JlbHMvLnJlbHNQSwECLQAUAAYACAAAACEAo+Vt8R4DAABrBwAADwAAAAAAAAAAAAAAAAAFBwAAeGwvd29ya2Jvb2sueG1sUEsBAi0AFAAGAAgAAAAhAEEMOcgeAQAA8QQAABoAAAAAAAAAAAAAAAAAUAoAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhALZrmvPOBAAAVhkAABgAAAAAAAAAAAAAAAAArgwAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLAQItABQABgAIAAAAIQDdteF0cwIAAKMHAAAYAAAAAAAAAAAAAAAAALIRAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWxQSwECLQAUAAYACAAAACEAwRcQvk4HAADGIAAAEwAAAAAAAAAAAAAAAABbFAAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQItABQABgAIAAAAIQDfTc/9pAMAABoPAAANAAAAAAAAAAAAAAAAANobAAB4bC9zdHlsZXMueG1sUEsBAi0AFAAGAAgAAAAhAJe0qGo3AQAAXQIAABQAAAAAAAAAAAAAAAAAqR8AAHhsL3NoYXJlZFN0cmluZ3MueG1sUEsBAi0AFAAGAAgAAAAhAKic9QC8AAAAJQEAACMAAAAAAAAAAAAAAAAAEiEAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQxLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAGkRlmzAAwAAzQcAABQAAAAAAAAAAAAAAAAADyIAAHhsL3RhYmxlcy90YWJsZTEueG1sUEsBAi0AFAAGAAgAAAAhAH+LQ8PAAAAAIgEAABMAAAAAAAAAAAAAAAAAASYAAGN1c3RvbVhtbC9pdGVtMS54bWxQSwECLQAUAAYACAAAACEAP9iFhgUBAACpAQAAGAAAAAAAAAAAAAAAAAAaJwAAY3VzdG9tWG1sL2l0ZW1Qcm9wczEueG1sUEsBAi0AFAAGAAgAAAAhAL2EYiOQAAAA2wAAABMAAAAAAAAAAAAAAAAAfSgAAGN1c3RvbVhtbC9pdGVtMi54bWxQSwECLQAUAAYACAAAACEAzl39tPMAAABPAQAAGAAAAAAAAAAAAAAAAABmKQAAY3VzdG9tWG1sL2l0ZW1Qcm9wczIueG1sUEsBAi0AFAAGAAgAAAAhALoupfSXBwAAgCUAABMAAAAAAAAAAAAAAAAAtyoAAGN1c3RvbVhtbC9pdGVtMy54bWxQSwECLQAUAAYACAAAACEADSd8hrsBAAB9BAAAGAAAAAAAAAAAAAAAAACnMgAAY3VzdG9tWG1sL2l0ZW1Qcm9wczMueG1sUEsBAi0AFAAGAAgAAAAhAKQpC+SfAQAAKQMAABEAAAAAAAAAAAAAAAAAwDQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAi0AFAAGAAgAAAAhAKRW3xCnAQAAaQMAABAAAAAAAAAAAAAAAAAAljcAAGRvY1Byb3BzL2FwcC54bWxQSwECLQAUAAYACAAAACEAxbowSQ8BAACSAQAAEwAAAAAAAAAAAAAAAABzOgAAZG9jUHJvcHMvY3VzdG9tLnhtbFBLAQItABQABgAIAAAAIQB0Pzl6wgAAACgBAAAeAAAAAAAAAAAAAAAAALs8AABjdXN0b21YbWwvX3JlbHMvaXRlbTEueG1sLnJlbHNQSwECLQAUAAYACAAAACEAXJYnIsMAAAAoAQAAHgAAAAAAAAAAAAAAAADBPgAAY3VzdG9tWG1sL19yZWxzL2l0ZW0yLnhtbC5yZWxzUEsBAi0AFAAGAAgAAAAhAHvzAqPDAAAAKAEAAB4AAAAAAAAAAAAAAAAAyEAAAGN1c3RvbVhtbC9fcmVscy9pdGVtMy54bWwucmVsc1BLBQYAAAAAFwAXABMGAADPQgAAAAA=

 

Please help advising me on this . Thank you 

Highlighted
Microsoft
Microsoft

Re: Add information in the attachment to a sharepoint file

Let me clarify your requirements, correct me if I'm wrong.

Basically, your flow is triggered by specific new email arrives. This email would have an Excel file attached.

Then your flow will get the data from that attached Excel file, and save into another Excel file which stored in SharePoint.

 

And the issue you encountered is the data you added into the SharePoint Excel file is not row data (readable data) but the whole bytes from the Excel (weird data you posted)?

Highlighted
Frequent Visitor

Re: Add information in the attachment to a sharepoint file

Hi @linxiao 

Yes it is correct 

 

When email arrive with

- title REQUEST_TABLE 

- from xxx@...

 

I would like the flow to get the data from the file and append the data to an excel file that I have in my group SharePoint

 

So for example the current table I have on Sharepoint is :

|| dwh_table_name || hash_agorithm || sensitive_content|| request_name||

||----it_supply------||----SHA-256---||birthdate,ssn------||-----jane  -----||

 

I want the extracted data from the Microsoft attachment and to continue to be appended to this table without adding extra header 

Highlighted
Microsoft
Microsoft

Re: Add information in the attachment to a sharepoint file

Thanks for your confirmation.

 

Normally, your requirement is make sense.

You know, in flow, any Excel related action require an existing Excel file. However, in your case, the Excel file (email attachment) is not existing during edit flow. Then the flow (Excel action) cannot know the data structure of that Excel because it can be anything.

 

One thing you can done is to use Convert Excel XLSX Spreadsheet to CSV action which is a premium connector action can helps you to convert an Excel file to CSV file dynamically.

 

Another workaround is to use csv file as attachment in your mail. That would be more easier and common.

Highlighted
Frequent Visitor

Re: Add information in the attachment to a sharepoint file

Hello @linxiao ,

 

Thank you so much for your suggestion

 

It works partly it seems to lump all of the data into one cell. Is there a way for me to fit the data according to its column name ?

janebraine_0-1595579875605.png

 

 

 

Highlighted
Microsoft
Microsoft

Re: Add information in the attachment to a sharepoint file

Would you please describe how did you get those results?

By taking look at your single screenshot I couldn't give you any suggestion.

Highlighted
Frequent Visitor

Re: Add information in the attachment to a sharepoint file

Hello @linxiao ,

 

Sorry for the missing information

 

I used the same flow , So basically I used On New Email trigger then Add row into a table but this time I used csv instead of xlsx 

 

I changed it a bit as the picture below but it still doesn't take each row but the whole file and write it in a cell

 

janebraine_0-1595604102349.png

 

Please help advise me if there is a way to append data from attachment to the excel file in my SharePoint

 

Thank you very much  

 

Highlighted
Microsoft
Microsoft

Re: Add information in the attachment to a sharepoint file

Then you can follow those steps:

1. Compose action (action name: raw_data)

input: your attachment

 

2. Compose action (action name: get_lines)

input: "@split(outputs('raw_data'),'\n')"

Type above formula directly into the input text box!!!

if '\n' doesn't work ,try '\r\n'

 

3. Apply to each action

select an output: skip(outputs('get_lines'),1)

 

4. Sub action in Apply to each: Add a row into a table

For each excel column, you can use: split(items('Apply_to_each'),',')[<index of column in raw csv>]

Replace the <index of column in raw csv> with real index, starts from 0

Highlighted
Frequent Visitor

Re: Add information in the attachment to a sharepoint file

Hello @linxiao 

 

Thank you for helping out , I passed the raw_data one as you suggested but I got stuck at get_line, I tried both @split(outputs('raw_data'),'\n')" and \r\n

 

janebraine_0-1595946998117.png

 

Here is the output of the raw_data

[
  {
    "@odata.etag": "",
    "ItemInternalId": "92e6e75f-4183-4b42-9a65-66e0c4e856f0",
    "Department": "a",
    "Table": "a",
    "Schema": "a",
    "SQL Query": "a",
    "Column to hash": "a",
    "Hash Algorithm": "a",
    "Sensitivity label": "a",
    "Schedule": "a",
    "Retention": "a",
    "File path": "a",
    "User email access list": "a",
    "Requestor": "a"
  },
  {
    "@odata.etag": "",
    "ItemInternalId": "3fff910e-e31a-4c2b-9026-d6520b6dbd52",
    "Department": "a",
    "Table": "a",
    "Schema": "a",
    "SQL Query": "a",
    "Column to hash": "a",
    "Hash Algorithm": "a",
    "Sensitivity label": "a",
    "Schedule": "a",
    "Retention": "a",
    "File path": "a",
    "User email access list": "a",
    "Requestor": "a"
  },
  {
    "@odata.etag": "",
    "ItemInternalId": "f6a84779-fda5-4a24-b111-c9667443f8dd",
    "Department": "a",
    "Table": "a",
    "Schema": "a",
    "SQL Query": "a",
    "Column to hash": "a",
    "Hash Algorithm": "a",
    "Sensitivity label": "a",
    "Schedule": "a",
    "Retention": "a",
    "File path": "a",
    "User email access list": "a",
    "Requestor": "a"
  },
  {
    "@odata.etag": "",
    "ItemInternalId": "415c5a24-0868-4a87-a137-8a4d40d1f9aa",
    "Department": "a",
    "Table": "a",
    "Schema": "a",
    "SQL Query": "a",
    "Column to hash": "a",
    "Hash Algorithm": "a",
    "Sensitivity label": "a",
    "Schedule": "a",
    "Retention": "a",
    "File path": "a",
    "User email access list": "a",
    "Requestor": "a"
  },
  {
    "@odata.etag": "",
    "ItemInternalId": "0d938bb1-503a-454d-88de-f47809a11957",
    "Department": "a",
    "Table": "a",
    "Schema": "a",
    "SQL Query": "a",
    "Column to hash": "a",
    "Hash Algorithm": "a",
    "Sensitivity label": "a",
    "Schedule": "a",
    "Retention": "a",
    "File path": "a",
    "User email access list": "a",
    "Requestor": "a"
  }
]

 

Highlighted
Microsoft
Microsoft

Re: Add information in the attachment to a sharepoint file

Then your raw_data is a JSON object, you need to convert it into a string:

"@split(outputs('raw_data'),'\n')"

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Users online (4,987)