I have a Flow which creates a task in Planner whenever a new row is added to an SQL database. It's been working for over a year, but a month ago it broke because the 'Update task details' action has a 'resource link' which contains a URL that has a # in it.
I've tried replacing the # with %23, which works, but browsers won't replace the %23 with a hash in the resulting task attachment.
This is what used to work:
And the error I'm getting is as follows:
"message": "The request is invalid:\r\nEncountered a metadata reference property 'https://omg.sharepoint.com/sites/a-site/SitePages/home.aspx#/details/1436' in a scope other than an entry. In OData, a property name with a '#' character indicates a reference into the metadata and is only supported for describing operations bound to an entry."
Solved! Go to Solution.
Sorry, that didn't work, @Anonymous, the %23 in the URL was failing to change to a hash unfortunately.
I ended up using the bit.ly connector to create a URL without a #, then passed that into the Planner connector.
Hi @adampope
Try Expression function encodeUriComponent.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThank you, @abm I had tried that and the DecodeURIComponent. This does convert the URL as an input:
@adampope i'm pretty sure you've solved it by now but wouldn't this work?:
'https://omg.sharepoint.com/sites/a-site/SitePages/home.aspx%23/details/1436'
Sorry, that didn't work, @Anonymous, the %23 in the URL was failing to change to a hash unfortunately.
I ended up using the bit.ly connector to create a URL without a #, then passed that into the Planner connector.
Could you try using a expression?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
22 |
User | Count |
---|---|
60 | |
45 | |
44 | |
29 | |
29 |