Hi,
Ok, so let me make sure I am clear. You want to take a set of Urls and in Real-Time convert them the File Path (aka the HTTPS file path) correct?
Hmm well not knowing in what scenarios and or where/what type of app or automation is going to need to use this.
1. Create a SharePoint list
2. Add a Text Column, lets call it FullPath
3. Add another Text Column called, Alias, where Alias will be these other urls
*Note you may need to use a multiline text field to fit your entire Urls, and do not use the Url field its too short
Ok now this is where I am a list stuck as there are options and I have to know how is calling and how to get the details.
1. Create a Cloud Flow, with a trigger that accepts a single string as input
2. Use that string to do a Get Items from the SharePoint list, filtering on the Alias column
3. If you get a row back, send the user back the proper fullpath that you have in that Column
now this could be made to be callable from other flows.
If you want to call this from different places.
1.Then create a cloud flow that uses the HTTPS Trigger (it is an API hosted endpoint essentially)
Let them pass the String in the body
2. Take the string from the body and again do your Get Items with the filter for Alias they sent in
3. pass back an HTTP Response to them with the value they need.
Need more info to tell you more.