I am trying to work out if what I want to do is even poissble using Office 365.
1. Input - I want to give a user a choice to select between 2 or more products, this can be via powerapps, a sharepoint list or any other O365 feature.
2. Automation - Then based on the selection I want some automation (probably flow) to locate the matching product description from a sharepoint library e.g. if user selects product 4, 7 and 9, automation would locate the files in the SP library called product4.docx ,product7.docx and product9.docx
3. Output - Then automation would create a new document with all the selected descriptions within it and save to a a SP library
Is this possible using only native O365 featuires i.e, without buying a 3rd party tool\software\addin?
If yes, how?
Hi @g3xer ,
The step1 and step2 could be achieved with microsoft flow, however, for the step3 to create a new document with all the selected descriptions, I'm afraid that it is impossible to be achieved with microsoft flow.
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it think it could be done:
1: Definitely possible within the scope of PowerApps.
2: I would use PowerApps for this, too.
3: Call a flow from the PowerApp with parameters of the document IDs from the SharePoint library, then concatenate them with a compose action and use the SharePoint Create File action. This would work even better if you use a format like HTML, Rich Text, or Plain Text instead of DOCX.
@AVividLightcould you please expand on the steps in your point 3 below, I am new to flow and have little programing skills, but lots of determination.
I can change the DOCX files into any format required.
Here is a prototype that I made, please let me know if you want any details on a specific part of it.
Submit button clears collection, iterates through the gallery items and adds an item's ID if the checkbox was selected, and calls a flow with the flattened collection as a parameter:
Clear(Choices); ForAll(Gallery1.AllItems, If(Checkbox1.Value = true, Collect(Choices, Value(ID1.Text)))); 'Example-Concatproducts'.Run(Concat(Choices,Value & ";"))
I'm sure that there are ways to make this more efficient/better, please only consider this a proof of concept. It can be done, but the perfect implementation is up to you 😉
Please let me know if you have any quesitons!
@AVividLight Thanks you so so so much. I will be working throught the night trying to recreate the instructions you have kindly provided. If its ok with you I will come back to you with any queries. Thanks Leon (G3xer)
Hi @AVividLight , I have been beavering away for about 8 hours and I am making progress. I have most of the flow built and most of the powerapp built. However I am struggling with the button in the powerapp. You stated:
'Example-Concatproducts'.Run(Concat(Choices,Value & ";"))
Is 'Example-Concatproducts' refering to the name of the flow?
Here is my error:
Yes, Example-Concatproduct is the name of the flow, however to run a flow from PowerApps you need to connect to it first.
Click on your button, then click Action and Flows. Be advised that this will overwrite anything that you currently have in the OnSelect property of your button. Also, you need to have all of the parameter requirements set in the flow before connecting it; if you connect to a flow and then change the parameters that the flow is expecting, PowerApps will not update the flow and you'll have to remove and re-add the connection.
It's looking great so far! I'm happy to help with any other questions.
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!