The serveruri does exist just for some reason power automate isn't generating it correctly. Here is the schema for the Imagefile column, incase Power Automate doesn't generate for you. { "$schema": "json-schema.org/draft-07/schema#", "type": "object", "properties": { "fileName": { "type": "string", "description": "The name of the file." }, "serverRelativeUrl": { "type": "string", "description": "The server relative URL of the file." }, "id": { "type": "string", "format": "uuid", "description": "The unique identifier of the file." }, "serverUrl": { "type": "string", "format": "uri", "description": "The server URL." }, "fieldName": { "type": "string", "description": "The name of the field." }, "type": { "type": "string", "description": "The type of the file." }, "fieldId": { "type": "string", "format": "uuid", "description": "The unique identifier of the field." } }, "required": [ "fileName", "serverRelativeUrl", "id", "serverUrl", "fieldName", "type", "fieldId" ], "additionalProperties": false }
@gerardoojeda8089
2 ай бұрын
Hello Andre, I hope you're doing great! I had an issue when parsing the image JSON using the reference you pinned in the comments, "message": "Required properties are missing from object: serverRelativeUrl, id, serverUrl, fieldName, type, fieldId.", I dont know if powerautomate removed them, but i cant make it work. do you have any ideas what could it be ?
@andrewhess123
2 ай бұрын
Take output and ask ChatGPT to parse it or another AI tool, itll parse it for you. There was some change that happened and it wasn't parsing correctly .
@diegoalejandropenalozamayo5997
11 ай бұрын
Hi Andrew, thank you very much for the video, I have a question, I don't know why in the JSON of the image I don't have a serverdirecturl property: "Col_Imagen": "{\"fileName\":\"Reserved_ImageAttachment_[10]_[Col_Imagen][36]_[379a27d3-5d94-4935-a3e5-4cb7022b607a][1]_[1].png\"}" , I hope you can help me Thank you so much
@andrewhess123
10 ай бұрын
Hi Diego, there must be something wrong with the JSON that is being input. I would retry the JSON, using Compose to get the output, and if that doesn't work maybe reaching out to Chat GPT.
@JohnDrogado69
7 ай бұрын
I have the same issue. The GET only gets the fileName, nothing else.
@ZeretLopez
7 ай бұрын
Hi @@andrewhess123 I did follow step by step and in the "Get file content" - File Identifier I'm not able to obtain the "ServerUrl". Checking options possibles, I can see that Compose output section the ServerUrl appears as "null". What do you recommend? Thanks a lot!
@MariamPortraits
5 ай бұрын
Exactly, there is no serveruri property it seems there is an update can you please check and help
@pedrohenriquefontesleitao9750
3 ай бұрын
@@andrewhess123, it seems to get only fileName from Image Column, even changing the JSON... all other properties get NULL
@zeeeeeek4415
27 күн бұрын
Andrew, excellent video. Thank you. I do have a question. My situation is that my sharepoint list has attachments such as jpegs. How could one embed those images on a html table email automation?
@luisalvarado9061
2 ай бұрын
Hello! I have an issue, in the first JSON when I save my flow it returns this error: Encountered internal server error. Diagnostic information: timestamp: "###########" , subscription id '################' , tracking id '#############' , request correlation id: '####################' How can I fix ths pls help
@stevedubrava2776
6 ай бұрын
NEED HELP, get to 2nd JSON for 2nd Schema and get stuck. Can you reach out.
@kanishkajaiswal9039
6 ай бұрын
Same issue
@andrewhess123
3 ай бұрын
{ "$schema": "json-schema.org/draft-07/schema#", "type": "object", "properties": { "fileName": { "type": "string", "description": "The name of the file." }, "serverRelativeUrl": { "type": "string", "description": "The server relative URL of the file." }, "id": { "type": "string", "format": "uuid", "description": "The unique identifier of the file." }, "serverUrl": { "type": "string", "format": "uri", "description": "The server URL." }, "fieldName": { "type": "string", "description": "The name of the field." }, "type": { "type": "string", "description": "The type of the file." }, "fieldId": { "type": "string", "format": "uuid", "description": "The unique identifier of the field." } }, "required": [ "fileName", "serverRelativeUrl", "id", "serverUrl", "fieldName", "type", "fieldId" ], "additionalProperties": false }
@claudiotassone371
5 ай бұрын
Hello Andrew and first of all thank you. Your tutorial seems to be the only one around that can help me. I have one problem in the sequence: when I test the parse HTTP JSON I get the following error in the schema [ { "message": "Invalid type. Expected String but got Null.", "lineNumber": 0, "linePosition": 0, "path": "d.IssueVisual", "schemaId": "#/properties/d/properties/IssueVisual", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Integer but got Null.", "lineNumber": 0, "linePosition": 0, "path": "d.Issue_CodeId", "schemaId": "#/properties/d/properties/Issue_CodeId", "errorType": "type", "childErrors": [] } ] My image column on sharepoint is called "IssueVisual". Now, I made the "string, null" workaround that you have suggested... { "type": "object", "properties": { "d": { "type": "object", "properties": { "__metadata": { "type": "object", "properties": { "id": { "type": ["string", null] }, "uri": { "type": ["string", null] }, "etag": { "type": ["string", null] }, "type": { "type": ["string", null] } } }, .... etc. ..... ...but I am not even able to save the flow anymore! I get this message on top red banner: "'The schema definition for action 'Analizza_HTTP_JSON' is not valid. Error details: 'Unexpected token when reading schema: EndArray. Path 'properties.d.properties.__metadata.properties.id.type', line 1, position 138.'.'." What's goin on in your opinion? For sure I am wrong somewhere. Thanks for your help
@andrewhess123
5 ай бұрын
Try using double quotes on Null, "type": ["string", "null"] stackoverflow.com/questions/16241333/specify-a-value-can-be-a-string-or-null-with-json-schema
@claudiotassone371
5 ай бұрын
@@andrewhess123 thanks for your reply. In the meantime I had catched this correction but once applied (also in Parse Image JSON otherwise I could not even save the flow) now I get this error: InvalidTemplate. Unable to process template language expressions in action 'Parse_Image_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'. I append here also my PrsImgJson schema: { "type": "object", "properties": { "fileName": { "type": [ "string", "null" ] } } with into the content field my "imagecolumn" (issuevisual) from 'html json parse' block So sorry to bother... Thanks for your contribution!
@claudiotassone371
5 ай бұрын
@andrewhess123 Addendum: I have applied the change "string / null" also to the PrsImgJson schema. No results though
@preetimahawar2866
2 ай бұрын
Hello Andrew, this is not working for me. Is there anything else that works?
@andrewhess123
2 ай бұрын
Hi preetima, you could make a pdf document or word document instead of embedding in the email?
@zeeeeeek4415
26 күн бұрын
Andrew, great video. I do have one question. How would I be able to extract a jpeg file from attachments on sharepoint list and and inject onto an html table email with power automate?
@andrewhess123
26 күн бұрын
Hi Zeek, will be getting back to you with a better answer. Would maybe take a video to answer. But with attachments it can be tricky because you can have multiple attachments.
@andrewhess123
26 күн бұрын
Most likely you need to grab them in power automate then loop through them and create an HTML table.
@andrewhess123
26 күн бұрын
Currently at a conference
@narutostudio8264
6 ай бұрын
I have followed the parson image json step but only the .png file appears without the serverurl of the parse image json, how can I solve it?
@begumdost381
2 ай бұрын
why dont we close the with
@andrewhess123
2 ай бұрын
Most likely can, probably just a mistake I made
@NikhilRaj-vy1vh
5 ай бұрын
Image is not loading in outlook after this succesful flow. Can you please help here?
@tourmakerofficial7059
9 ай бұрын
I am not able to get my image column from my share point list
@tourmakerofficial7059
9 ай бұрын
I am not getting column in compose
@andrewhess123
3 ай бұрын
{ "$schema": "json-schema.org/draft-07/schema#", "type": "object", "properties": { "fileName": { "type": "string", "description": "The name of the file." }, "serverRelativeUrl": { "type": "string", "description": "The server relative URL of the file." }, "id": { "type": "string", "format": "uuid", "description": "The unique identifier of the file." }, "serverUrl": { "type": "string", "format": "uri", "description": "The server URL." }, "fieldName": { "type": "string", "description": "The name of the field." }, "type": { "type": "string", "description": "The type of the file." }, "fieldId": { "type": "string", "format": "uuid", "description": "The unique identifier of the field." } }, "required": [ "fileName", "serverRelativeUrl", "id", "serverUrl", "fieldName", "type", "fieldId" ], "additionalProperties": false }
@andrewhess123
3 ай бұрын
@@tourmakerofficial7059 in a comment below.
@NikhilRaj-vy1vh
5 ай бұрын
@andrewhess123 Image is not loading in outlook after this succesful flow. Can you please help here?
@nguyenmanhtuan1772
7 ай бұрын
Hello, i follow and it works perfect. But i have error that the flow work, email sent, table have information but the some picture are missing of the table. Some picture show and other dont. Could you please help. Thank you
@andrewhess123
7 ай бұрын
What's the difference, when they show and when they do not show? Is it picture type? Picture size?
@nguyenmanhtuan1772
7 ай бұрын
@@andrewhess123 Good morning from Vietnam Sir. I found the problem already, i built the flow to run after a SharePoint item was created by Power Apps, and when I used Camera control to take a picture, the flow worked well, but when using camera control to upload a picture instead of taking by Camera, I still can create SharePoint item, everything seems don't have the different, but when using the flow to send an email, all the picture I upload from my library by Camre control didn't display. So I switched to taking pictures by camera control 100% then the flow worked perfectly for me.
@andrewhess123
7 ай бұрын
Very interesting thanks for sharing Mạnh Tuấn@@nguyenmanhtuan1772
@nguyenmanhtuan1772
7 ай бұрын
@@andrewhess123 thank you a lot for your tutorial. It's fantastic
@ctran1767
Жыл бұрын
Not sure if this is the right place to ask this. I'm looking to create a colum in MS Lists which is a combination of 3 other fields to create a part # column. Ex: part 3: DELL-i7-Blue where DELL is a lookup column of manufacturers, i7 is a lookup column of CPU, and Blue is a lookup column of colors. I'm puzzle as how to create the part # column? Appreciate any help.
@andrewhess123
Жыл бұрын
Hi ctran, Sounds possible. What's the question though, you want a random number, you want an auto-ID? What should the part # look like? By default SharePoint actually will give every Row an ID Number you just have to make it visible, and MS Lists is actually just SharePoint with a pretty look.
@ctran1767
Жыл бұрын
@@andrewhess123 Sorry what I mean was the Part # column is a text field, literally is a combination of 3 other fields such as "DELL-i7-Blue" with a dash in between in the example above.
@andrewhess123
Жыл бұрын
@@ctran1767 Hi ctran, so you can concatenate those fields either in Power Apps or Power Automate. Or you could even create a calculated field in (MS Lists) SharePoint to concat them all. Just go into List settings of your List, and create a new calculated column. You have a few different options. Here's an example using just a calculated field in SharePoint: support.microsoft.com/en-au/office/concatenate-function-5b0392b2-94ef-49ea-8532-4fdd3a69d362
@ctran1767
Жыл бұрын
@@andrewhess123 That would works. Thanks so much.
@andrewhess123
Жыл бұрын
@@ctran1767 Thanks for watching ctran
@geralddahl9159
Жыл бұрын
This is great stuff - thx👏. Question - will the SharePoint image column present images as a square 'thumbnail' or will it represent relative size, for instance a 5X7" image would look a little taller and a little less wide than a square? And, if that's the case, is there a way to DYNAMICALLY adapt the 100 width 100 height adjustment you made when you saw that your headshot was too big so that non-square images get sized down to say 75 wide and 100 height so as to relatively maintain the original 5x7 portrait size proportions? Appreciate that you are branching into Power Automate - very helpful.
@andrewhess123
Жыл бұрын
Hi Gerald, Just gotta figure out the html to how you want it to be and configure it how you'd like, you can preserve the aspect ratio by doing things like width="600" height=auto, I haven't tried it in this instance but I know HTML can do it normally.
@geralddahl9159
Жыл бұрын
@@andrewhess123 nice to know, thank you
@nikelike1000
11 ай бұрын
Hi Andrew, I wanted the same only creating to be exported images in word file other all fields able to export can u please suggest
@andrewhess123
11 ай бұрын
Hi, if you want pictures I believe you need premium features of power automate. I believe the MS word connector can do this. There are other third party tools too. powerusers.microsoft.com/t5/Building-Power-Apps/Adding-image-to-MS-Word-with-Power-Automate/td-p/450894
@andrewhess123
11 ай бұрын
Another option would be use power apps to create PDFs, then print from power apps. Instead of automate printing. You could most likely do this with out of the box features.
@djstone5518
4 ай бұрын
@@andrewhess123 Many thanks, Andrew! I'm here because of the limitations in Word and I do use the premium connector. I have a couple of repeating section content controls which work beautifully when I am merely populating with plain text strings referenced in a Word document and populated with a For Each by way of Power Automate; however, because Microsoft does not support Picture Content Controls nested in Repeating Section Content Controls I began looking at how to do this via HTML. Would have been so much easier if Microsoft would figure out a way to support pictures in a repeating section but I think this may do the trick. On a side note, MS also does not support the Check Box Content Control so that created more work for me. Love your videos. Thanks again.
@andrewhess123
4 ай бұрын
Thanks for the kind words DJ Stone! Totally agree about he pictures not working in repeating sections, there are 3rd party tools which cost even more 😅 that can do those things like Plumsail... but yeah you're totally right sometimes going to HTML instead and then converting to Word may be the better option.@@djstone5518
@djstone5518
2 ай бұрын
@@andrewhess123 Yes I ended up going the route of 3rd party with Encodian. It is reasonably priced offering and they do a great job extending the functionality of Power Automate. Thanks again for the great videos!
@bujjibabukj9616
Жыл бұрын
Hi Andrew, Thanks for the helpful video! I've created a flow for daily birthday emails following your instructions, and it's working well. But on some days, when no one has a birthday, the email is sent empty. How can I avoid sending emails on those days? Appreciate your suggestions!
@andrewhess123
Жыл бұрын
Hi Bujjibabu, I would use a control condition and use something either a variable, or check if the JSON is blank, and then send the email or do nothing. You need some way to check if there's null or blanks and then email or not.
@bujjibabukj9616
Жыл бұрын
@@andrewhess123 Thank you for your response, Since I'm new to Power Automate, could you please assist me in accomplishing this task?
@andrewhess123
Жыл бұрын
@@bujjibabukj9616 Here is a good example: devoworx.net/power-automate-check-if-field-is-null-or-empty/
@abionweb
8 ай бұрын
Hi, Thank you for posting this video, i am not getting any input or output values for my second compose action. upto parse HTTP JASON everything works fine, but unable to generate the schema for the second parse Jason action, could you please post the Schema here.
@stevedubrava2776
6 ай бұрын
Same here - stopping point for me - stuck
@kanishkajaiswal9039
6 ай бұрын
Click on generate sample schema and then paste as done in video
@andrewhess123
Жыл бұрын
Trying to create a few Power Automate Tutorials here and there, just as important! 😀
@ylmazozturk06
Жыл бұрын
Hello, it was a useful video, thank you for your effort. Can you edit this as a video in the pictures attached to the sharepoint list?
@andrewhess123
Жыл бұрын
Hi Yılmaz, can you explain what you mean. Edit this as a video in the pictures? Do you mean there is a video file in the attachments of SharePoint? And you want a picture of it in an email?
@ylmazozturk06
Жыл бұрын
@@andrewhess123 I want to design for images in sharepoint attachment
@andrewhess123
Жыл бұрын
@@ylmazozturk06 I think attachments are much easier than the image columns.
@andrewhess123
Жыл бұрын
Just FYI, this wasn't added to the video, but in the JSON for your image column you may need to change it to allow null values. ["string", "null"]
@leewright6943
9 ай бұрын
Hi Andrew, excellent video and works perfectly unless null image as mentioned. Saw the comment but really struggling to understand how to implement the [“string”,null] and where?
@andrewhess123
9 ай бұрын
HI Lee, so this is done in the Parse JSON code at the column that could be null. I had reworked this for a coworker, took us a good bit to get it working correctly. Notice it says type: "string", change the column to type : ["string", "null"] for every column that could be null. You could also build control condition branches too, or make images required. There's a few work arounds@@leewright6943
@leewright6943
9 ай бұрын
@@andrewhess123 thanks for the quick response, I’ll do that first thing tomorrow. 👌🏻
@priyagujjeti854
5 ай бұрын
@@andrewhess123 Hi Andrew, I have done the same applied type:["string","null"] but I am getting this error message 'Unable to process template language expressions in action 'Parse_CheckPoint_Image_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.' If you could help me that would be great. Thanks!
@claudiotassone371
5 ай бұрын
@@priyagujjeti854same from me
@djstone5518
4 ай бұрын
Not sure if this will help anyone but with the ever changing Power Platform when I hit 8 minutes where I needed to add File Content from Get file content that was not an option under Dynamic content so I had to manually enter: base64(outputs('Get_file_content')?['body']) in the img src HTML Your videos are up there with Shane and Reza. Many thanks! kzitem.info/news/bejne/q3x32IZukYFeeGUsi=vWoekaUnXa__gKpj&t=481
@andrewhess123
4 ай бұрын
Thanks DJ Stone! Comparing me to Shane or Reza is an honor because I look up to them! Thanks so much and thanks for throwing in some extra help for other people!!! Totally appreciated.
Пікірлер: 84