Power Platform Community Forum Thread Details

Hello! So im creating an app, and basicaly it needs to do the following: the user writes the name of project in the field "Nome do projeto" after that the user clicks on the Continue button, after that it runs a power automate flow that gather the name of the project info, create a copy of a excel fiel in a sharepoint from a folder to another folder in that same sharepoint, with the name of the project("Nome do projeto") + the actual date. What i need is after or in paralalel that copying and rename process, i also need to update some cells in that excel with some infos. For example, i need to write that name of the project in a specific cell on that new excel file, also in the next screen(3 image), the user needs to write the SOP for the project and also some infos. I need these infos in 3 diferent cells. For example, after the copying and renaming process, i need to write the SOP info, the scope info and the name of the project info, each one in a diferent cell in that fresh created excel file that i copy. But the deal is it need to be dinamic, every time the user uses my app, it needs to copy that file from a folder to another one with a new name(the one that the user writes on the "Nome do projeto" text box), and on the next screen, when the user writes the SOP for the project and the scope for it, i need a flow to write these 2 infos + the project name on 3 diferent cells on the new fresh created excel file, but i just cant work out a flow cause these new excel file needs to be already created, i need a flow to analyse and see if its already a excel file with the same name that the user writes on the "Nome do projeto" field, if the flow see that its already a file with the name that the user already put on the "Nome do projeto" field, it gather the "Name do projeto" info, SOP and scope and writes these 3 infos in 3 diferent cells.

i added the colums of the excel file that i need to put the 3 infos(SOP, name and scope) every zero its a cell that i need to write a info(SOP, name and scope).

Categories:

Building Power Apps

Power Automate Flow Setup:
- Step 1: Trigger the Flow from Power Apps
  - Add the PowerApps trigger in Power Automate.
  - Use the "Ask in PowerApps" function to accept inputs like the project name, SOP, and scope from Power Apps.
- Step 2: Copy the Excel File to a New Folder
  - Use the SharePoint "Get file content" action to get the file from the original folder.
  - Use SharePoint "Create file" action to copy the file to the new folder and set the file name as:
```
[ProjectName] + "_" + [Today's Date]
```
    Example: Nome do projeto_2024-09-26.xlsx
- Step 3: Check if the File Exists
  - Use the SharePoint "Get files (properties only)" action to check if a file with the same name already exists in the destination folder.
  - If a file exists, you can handle it by either:
    - Overwrite the file: Use the file you copied.
    - Skip or Fail: If the flow detects that the file already exists, you can decide what to do.
- Step 4: Update Excel File (with Project Name, SOP, and Scope)
  - Use Excel Online (Business) "Add a row into a table" action if the data you want to update is part of an Excel table. You can dynamically insert the values for project name, SOP, and scope in different columns.
  - Alternatively, if you need to update specific cells, use Excel Online (Business) "Update a row" or "Update a cell" action. Specify the target cells (e.g., "B2" for project name, "C2" for SOP, "D2" for scope).
  - You can retrieve these cell positions dynamically or hard-code them based on your needs.
- Step 5: Pass Data Back to Power Apps
  - If you need to send any data back to Power Apps, you can add the "Respond to PowerApps" action.
Back in Power Apps:
- Use PowerApps function to trigger the flow, passing in the inputs (e.g., "Nome do projeto", SOP, and scope).