This is amazing! I have been looking for a way to request multiple documents from external users and organize them by user, since this is not possible from Msft Forms. Thank you so much.
I'm currently learning JavaScript syntax and how to use its schemas. Can you describe how you got your schema beyond "sample payload -> schema" or if it was written completely manually? And may I ask that you send/post the schema so I know how it works? Thank you!
The process of taking the demonstrative payload and converting it to a generalized schema is an automated one in this context. You can achieve the same simply by taking an action output and using the JSON in this process. Ultimately, the schema just describes the output you get in a way that makes it readily useable in the flow.
@@brightideasagency I use the "sample payload to generate schema" button but it does not create a "URL" property and the schema generated looks much more barebones than the one in the video.
The auto generated schema is entirely dictated by the sample response you input. If certain fields are not pulling through to the schema then they weren’t in your response, meaning there is a problem with your flow or your underlying data. Ultimately processing the JSON response using a defined scheme is just a nice to have feature that makes usability further down your flow easier. The most important thing to learn is to get the flow right to expose the right data for whatever your project need is.
This is excellent. Im looking for soemthing like this to work alongside ms form for internals and external contractor .. file upload not being possible in ms form for externals.
Would we be able do the same flow in onedrive? I am guessing not, "create new folder" is not an action that is available for onedrive. understandably, onedrive is not designed for sharing.
I believe so, though I think some of the steps require HTTP requests from memory. I'm working on a follow-up to this video to deploy a practical use case for creating these links at scale, so I'll try to remember to look at the corresponding steps in OneDrive too. Thanks for watching.
I am so close! But the last step, Compose, does not have Url as an option. If I select Body I can see the URL within the results when I test run. I have no idea what I am doing wrong.
I made some progress by using "generate from sample" on Parse JSON to expose the Url. Now I can select it in the Compose step, but it doesn't capture the Url when I test. If I substitute with Body I can see the Url in the results. Still stuck, but an inch closer.
It sounds like the issue is the output of your Parse JSON action rather than a Compose action. Ensure the URL you are trying to get out is described in the schema for your Parse JSON action - if it is in the schema but that dynamic field is then not present, the input you are passing to your Parse JSON action may not be right - follow the variable you are looking for through your flow to find where the problem sits.
There are a number of ways of approaching this. Perhaps create a request directory per client and then total up the number of files in each directory, sending a reminder if there are not enough? You could do all this in Power Automate. You could even add in AI Builder to analyze some of the content and check the files are what you are expecting.
Thanks for watching. Sure. Anything you can do in Power Automate can be automated to be recurring, you'd just need to work out the logic of exactly what it is you're recurring for different folders etc.
How do you use the Request Files feature in SharePoint or OneDrive? Is automation with Power Automate useful to your business need?
Just what I was looking for. Perfectly explained and demoed. Interesting how Microsoft haven’t added a specific action for this yet
Thanks for watching!
This is amazing! I have been looking for a way to request multiple documents from external users and organize them by user, since this is not possible from Msft Forms. Thank you so much.
Thanks for watching. This is a very useful feature for those sorts of scenarios.
I'm currently learning JavaScript syntax and how to use its schemas. Can you describe how you got your schema beyond "sample payload -> schema" or if it was written completely manually? And may I ask that you send/post the schema so I know how it works? Thank you!
The process of taking the demonstrative payload and converting it to a generalized schema is an automated one in this context. You can achieve the same simply by taking an action output and using the JSON in this process. Ultimately, the schema just describes the output you get in a way that makes it readily useable in the flow.
@@brightideasagency I use the "sample payload to generate schema" button but it does not create a "URL" property and the schema generated looks much more barebones than the one in the video.
The auto generated schema is entirely dictated by the sample response you input. If certain fields are not pulling through to the schema then they weren’t in your response, meaning there is a problem with your flow or your underlying data. Ultimately processing the JSON response using a defined scheme is just a nice to have feature that makes usability further down your flow easier. The most important thing to learn is to get the flow right to expose the right data for whatever your project need is.
This is excellent. Im looking for soemthing like this to work alongside ms form for internals and external contractor .. file upload not being possible in ms form for externals.
That is a good use case for this approach. Thanks for watching.
Brilliant Idea!!!!!
Thanks for watching.
Would we be able do the same flow in onedrive? I am guessing not, "create new folder" is not an action that is available for onedrive. understandably, onedrive is not designed for sharing.
I believe so, though I think some of the steps require HTTP requests from memory. I'm working on a follow-up to this video to deploy a practical use case for creating these links at scale, so I'll try to remember to look at the corresponding steps in OneDrive too. Thanks for watching.
@@brightideasagency How would I 'create new folder ' in onedrive? 🙏
I am so close! But the last step, Compose, does not have Url as an option. If I select Body I can see the URL within the results when I test run. I have no idea what I am doing wrong.
I made some progress by using "generate from sample" on Parse JSON to expose the Url. Now I can select it in the Compose step, but it doesn't capture the Url when I test. If I substitute with Body I can see the Url in the results. Still stuck, but an inch closer.
It sounds like the issue is the output of your Parse JSON action rather than a Compose action. Ensure the URL you are trying to get out is described in the schema for your Parse JSON action - if it is in the schema but that dynamic field is then not present, the input you are passing to your Parse JSON action may not be right - follow the variable you are looking for through your flow to find where the problem sits.
did you find a solution ?
Our need is that the we have a monthly recurring list of documents per client and we need to track each document request. They will send 2 and not 4.
There are a number of ways of approaching this. Perhaps create a request directory per client and then total up the number of files in each directory, sending a reminder if there are not enough? You could do all this in Power Automate. You could even add in AI Builder to analyze some of the content and check the files are what you are expecting.
Hello , how can i get the Parse Json , sorry for the question. i am not used to api's and stuff
found it =)
Thanks for watching. Glad you worked it out.
Can you make this a recurring automatic function? like every Friday at 3pm?
Thanks for watching. Sure. Anything you can do in Power Automate can be automated to be recurring, you'd just need to work out the logic of exactly what it is you're recurring for different folders etc.
Does this still work?
As far as I know.