Finding a file name of a document I currently have open

(0) Share

Report

Posted on by swilko44

Hi,

I am new to Forms and Power Automate and have a specific problem I would like some advice on.

I have a Microsoft Form embedded in a PowerPoint slide that has a user feedback text box.

I currently have a flow set up in Power Automate that sends my Microsoft Teams Group an email once the form is submitted. The name of the user is automatically populated in the email with the text box information that was input by the user. This is all working at the moment.

What I would like to have happen, is the name of the PowerPoint presentation that the form in embedded in, automatically populate in email as well.

I have not been able to find a function in Power Automate that can do this.

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Hi, You want to rename the PowerPoint File name, right ? Is it unique foreach user ? If yes :
you have two options :
You can use REST API to rename the file. Refrence here : Solved: Renaming SharePoint file using REST API with Power... - Power Platform Community (microsoft.com)
Create a new file with a new name and same content and delete the last one.
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
swilko44 5 on at

Like (0)

Report

Hello abouchaalaBAIT,

Do not want to rename the file. Want to do is able to extract the name of the powerpoint file that my form is embedded in, and use in an automated email I generate in Power Automate.

I will explain further below;

Here is the PowerPoint file with my form inserted on the last page of the presentation. The filename of the PowerPoint is "Powerpoint 123" and is stored in a work SharePoint account that I have access to. But there are over 200 PowerPoint files that I will be loading my form into and these are spread over many different folders in the SharePoint account.

Currently the user who is will be giving the presentation and logged in under there own account, manually inputs the name of the file into question 1 below.

I then use the input of question 1 in the Send email function below.

What I would like to do is somehow extract the name of the powerpoint (The one the user current has open). In this case "Powerpoint 123", and somehow extract the filename without user input and use this in my email function below. (similar to how I have used the "responders email address" to automatically populate their name

So is there a way I can use Power Automate to extract the filename and have this variable used in the email I am sending out, instead of the user having to type in the filename manually.

Hope this clarifies what I am trying to do.

Thanks in advance.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (1)

Report

I better understand now and the answer is no
It would be possible if Forms allow to pre populate parameters. Here is a user voice that you can vote : Pre-populate fields in Microsoft Forms via URL parameter · Community
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Barret 652 Most Valuable Professional on at

Like (0)

Report

You cannot do what you're looking for (at least by default). The data passed into a flow from the form only contains information about the form itself, and it doesn't include any information about the file it's embedded in. The only alternative I can think of off hand is that when you create the form in the PowerPoint, add a "dummy" field that includes the filename of the PowerPoint. Of course, that's a manual process and if someone changes the name of the PP file, it won't update the form data.

Was this reply helpful? Yes No
swilko44 5 on at

Like (0)

Report

Thanks for all your responses.

Was this reply helpful? Yes No