Copy URL from Excel with Flow to SharePoint List

Question

Hi all, can you please help me with creating a formula in flow so it will correctly transport column with URLs to SharePoint List?

Flow Goal: when Excel is updated with new data - update SharePoint list.

What I have in Excel : Columns Title (of event) and URL (to register to event).

What I want to see in SharePoint:
Name of event as working link. So use as text 'Title' and as URL 'URL'.

Is it possible? Can someone help me out with formula? Thanks-

Answer 1

Hi @Anastasiia Zhy ,

Thanks for the post.

As a SharePoint tech support, it is available to create a flow that achieve your goal. You could create a trigger as 'When am item or a file is modified' and set the action as 'Update file properties'.

However, per my knowledge, the column value in your Excel 'Title' and 'URL' may not be updated to SharePoint list. It might not be able to get value from Excel columns when creating the flow.

If my understanding is right, we’d love to help you, since our community focus on general troubleshooting and built-in features in SharePoint Online environment, the question you mentioned is related to Power Automate, we’d suggest you go to Power Automate Community to post a new thread, which is specific channel to handle such situation. The engineers in related team will focus on your specific scenario and provide specific suggestions. They also have enough environment to help you test it.

If the scenario above is not consistent with yours, you can also post back and point that.
Thanks for your understanding and cooperation.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread