cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GregGregory
Regular Visitor

Power Automate, Sharepoint, Forms and Flow integration

Hi all,

 

I am attempting to set up a multi-step approval flow for a publishing workspace with the following provisos (which as far as I can tell, can't be done wholly within the Approvals app).

  • Form submittal triggers the flow. 
    The data required is input, however, one field is giving me headaches. In most cases a single URL is all that is needed, but we have the occassional approval that has several URLs. The related folders are all stored on the company Box drive and related links are obtained and pasted into the relevant fields in the form.
  • The Flow creates a Sharepoint list showing all the enterred fields, including the URLs.

This is where the flow comes unstuck. A link appears in the sharepoint list, however, it isn't connecting correctly. After some poking around I can see that each URL needs to be separated somehow, but I have no clue how to go about it.
Considering there may only be one URL, setting and appending a variable seemed to be the solution, but I get errors as each URL is originally a separate field in the Form, making it impossible to append different variables to the same output.
Do I need to change the Form format, or is there a method for the flow to differentiate between single or multipple URLs, but keep the same outcomes?

1 ACCEPTED SOLUTION

Accepted Solutions

Problem solved using the above coded variable, the URLs were dead due to my absent-mindedness in setting the variable...it was only initialised in the above example.

View solution in original post

4 REPLIES 4
Hardesh15
Super User
Super User

@GregGregory  are you storing multiple Urls in One SharePoint column? Kindly Share screens.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

 

Hi Hardesh15,

I am not able to store multiples at the moment, but am attempting to accomplish that.

Our editiorial team and the preson submitting an approval request need to be able to see the details for each approval, including the URL, or mutliple URLs, which contain work(s) under review for approval.
This field is the only one that may have only a single entry, or multiple entries.

I've just been informed that we can use multiple URLs in the chat message which is being generated as part of the automated flow. To accomodate this, I've created variables for up to 5 links (the same amount that can be input in the form) and composed them into one coded variable (see below)

GregGregory_0-1658884545416.png

This then gets output into the powerautomate chat with the relevant parties mentioned (using the below example)

GregGregory_1-1658884706426.png

When the chat comes through, the links appear correctly, but don't actually connect to anything (clicking them doesn't open the browser/path)

GregGregory_2-1658884919793.png

I know this is almost fixed, but have no clue what is missing in order to make those URLs live.

Problem solved using the above coded variable, the URLs were dead due to my absent-mindedness in setting the variable...it was only initialised in the above example.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,417)