question

ARS-2168 avatar image
0 Votes"
ARS-2168 asked SrikantRamabadran-8387 published

On Sharepoint online how to copy hyperlink direct from excel sheet

Hi ,

i want to import bulk excel sheet data with hyperlink column on sharepoint column but on copying data from excel to sharepoint online list hyperlink disappears with only text .

i want to copy hyperlink text from excel sheet as it is to sharepoint online list . please suggest

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT commented

Hello @ARS-2168 ,

Welcome to Q&A Forum!

Please following steps:

1.Create a excel file and format as table

96230-8.png

2.Upload this excel file to SharePoint library. In my testing, upload file to Documents library.

3.Create a new list to store data. Please create the corresponding columns in advance.

96301-9.png

4.Create the MS Flow

a)Add "Manually trigger a flow" trigger

b)Add "List rows present in a table" action.

  • Location: The group name corresponding to your site collection

c)Add "Apply to each" action, select value(from "List rows present in a table" action) as output

d)Then, add "Create item" action.

96273-10.png

5.Save and Test this Flow

96287-list.png

Thanks,
Echo Du
======================
If an Answer is helpful, please click "Accept Answer" and upvote it.
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.



8.png (88.7 KiB)
9.png (32.4 KiB)
10.png (61.7 KiB)
list.png (25.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ARS-2168 ,

Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

Thanks,
Echo Du

1 Vote 1 ·

Hi @ARS-2168 ,

Is there anything else I can help with regarding this issue?
You can comment us at any time and we will continue to follow up.

Thanks,
Echo Du

0 Votes 0 ·
SrikantRamabadran-8387 avatar image
0 Votes"
SrikantRamabadran-8387 answered SrikantRamabadran-8387 published

found it very useful . thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.