I am trying to customize Expense Report template using flow and PowerApps.
So I have created a page in PowerApps for users to create a report, take some pictures from their phones, and when they clicks on the save button the flow will start, update the picture to SharePoint list column called “Bills Photo” and trigger the report id that they wants to add the photos on.
Suppose that also the users want to take more than one photo to a report, how can i group the photos to show them in the column close to each others for example: Photo1,Photo2,Photo3…
I followed this amaizing tutorial on Youtube video but this flow in this video don't achieve my needs:
On save i want the flow to save the images URL's based on ReportID of the user.
So when the manager want to check for the bills photo's in SharePoint it will redirect him to the URL of the image that the user add it to the report.
Here is the list:
Here is the flow:
Here is the App:
So what is the actions i have to add in the flow to achieve it ? Please can you provide example of this flow ?
I would really appreciate your help.
Hi @Julien2 ,
You can add the ID of the item to end of the Filename, which is the textinput control in PowerApps. For example, use a formula that runs the flow like below:
Gallery1.Selected.ID is just an example to get the ID value of the item.
Hi @v-monli-msft ,
I have 2 different pages but each of this pages contain 2 Save buttons, i wanna merge both functions in only one function and one save button. The functions are below:
(Save & Add new line item Button) function:
(Save to SharePoint Library Button) function:
Set(FileLinkFromFlow, Powerapps.Run(TextInput2.Text & ".jpg", Dropdown1.Selected.Value, TakenPic).filelink)
So on save the flow will start and add the image to the library, at the same time a new item will be added to the LineItem list by checking the id of the report in the other list.
What will be the function for the Save button ?
Thanks in advance!
Hi, Even though you are storing your images on SharePoint, you may get some ideas on how to adapt the methods used in this excellent video which shows how to save multiple images to Azure Blob storage. The main concept here is to use an "intermediate table" that links the Expense report in this example to multiple images. This avoids using Flow to simplify things.
Hope this gives you another approach...
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!