This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'd like to make the "Title" column in a Sharepoint list to get dynamically the name of the attached file when I create a new item. Is this something possible?
I did searches on how to accomplish this by formatting the JSON of the column, but find nothing. Also, my knowledge of JSON is not good enough. If you have simple documentation or anything else that can help, it would be much appreciated.
Best regards
You mentioned JSON column formatting, so I'm going to assume you are using SharePoint Online. if that's the case then I would suggest using Power Automate.
You would use the When an item is created trigger, get the attachments, loop through the attachments (SharePoint enables you to add more than one) to get the name of the last attachment, and then update the Title field value if there was an attachment.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 1%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Hi anonymous user,
Are you using SharePoint online? Like RobWindsor said, you could use Power Automate flow to update Title column with attachment name dynamically if you are using SharePoint online. Here is a similar thread for reference if you are using SharePoint on-prem: How to show names of attachments from a list item in a column?.
Thank you Rob! I never thought of doing it with Power Automate. In fact, I've never used it. I will definitely look at your suggestion.
All those Microsoft Power Platform tools are very interesting. When I look at the screenshots you've attached, it almost looks like you can "design" programmation in Power Automate instead of writing code. Very interesting! Thanks again!
Hi anonymous user,
If RobWindsor's answer helpful to you, please remember to accept it. It will help others who meet the similar question in this forum. Thank you for your understanding.
Hi @CaseyYang-MSFT ,
I did try to find out how to accept an answer, but all I can do is to up vote it. I would definitely like to accept it, but how can I do so?
By the way, thank for you link in your response to RobWindsor's answer. It was also very helpful.
anonymous userBussire-1123 There should be an Accept answer button at the bottom of the answer that you can click. See Accepted answers for more information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 55.00000000000001%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Hi, thank you for the above, it worked but only for one attachment. Would you know what I’d need to amend or add to make sure it does it for every attachment uploaded with a new list entry?
Many thanks,
D
I addressed that in my answer, "You would use the When an item is created trigger, get the attachments, loop through the attachments (SharePoint enables you to add more than one) to get the name of the last attachment, and then update the Title field value if there was an attachment."
If you wanted a way to get the names of all of the attachments, you could create an array variable and then add the name of each attachment as you loop through them.
@CaseyYang-MSFT , @Rob Windsor
Sorry for the late response, but I still not able to see any "accept answer" button. I really would like to accept it and give you all the credit for your help on this.
The same thing just happened on another question I asked yesterday. I can't see any "accept answer".
I can't even rate star any comments, it says I don't have enough permissions. So, I think the reason might be related to my company Microsoft profile, because I logged with. I did try to merge it with my personnal outlook account, but it's not working.
I apologize for this.
Dave
@CaseyYang-MSFT , @Rob Windsor
Finally! Both of my accounts merged!
So, I was able to accept your answer. It was really because of my company account permissions I wasn't able to accept it.
Thanks again for your help!
Dave