cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leolsdn
Helper I
Helper I

Insert text with hyperlink using PowerAutomate

Hello, I have a SharePoint list with a column of type "Hyperlink or Picture" that I'm trying to fill-in using a PowerAutomate Flow.

The final result should be: "Go to Site" and the hyperlink.

 

What should I put in the PowerAutomate flow to achieve this?

 

For now here is the logic I use, but I only get the URL, the flow doesn't accept any text.

 

URLText1.png

 

Thanks for any help or ideas you can provide me.

 

1 ACCEPTED SOLUTION

Accepted Solutions

OK, so I did it

 

First, I need to get the list data name:

1) run: https://andreir4040.sharepoint.com/sites/NTTDATA1/_api/web/lists/getbytitle('Site%20Index')

This will show the JSON body which is returned from your list, so then access and perform a find for “ListItemEntityTypeFullName”, then copy the value between the tags into your REST call body

2) get the info for the workspace column from here: https://andreir4040.sharepoint.com/sites/NTTDATA1/_api/web/lists/getbytitle('Site%20Index')/Items

 

Finally, here is the flow logic:

 

GO1.png

View solution in original post

4 REPLIES 4
Tom_Slosse
Memorable Member
Memorable Member

Hey @leolsdn 

 

 

I think you could make a string variable and set the variable to something like this:

<a href="<Workspace Link>">Go to site</a>

 and put that into the Create Item.

I'm not sure if this will work but it is worth a try.

 

Kind regards

 

Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Hi Tom,

Nope, doesn't work.

 

NOGO1.png

OK, so I did it

 

First, I need to get the list data name:

1) run: https://andreir4040.sharepoint.com/sites/NTTDATA1/_api/web/lists/getbytitle('Site%20Index')

This will show the JSON body which is returned from your list, so then access and perform a find for “ListItemEntityTypeFullName”, then copy the value between the tags into your REST call body

2) get the info for the workspace column from here: https://andreir4040.sharepoint.com/sites/NTTDATA1/_api/web/lists/getbytitle('Site%20Index')/Items

 

Finally, here is the flow logic:

 

GO1.png

View solution in original post

Hey @leolsdn 

 

 

That is great news!

Thank you for sharing your solution on this matter.

 

Please mark your post as solution so people can use your solution if they are facing the same problem.

 

Kind regards

 

Tom



If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (68,959)