Power Platform Community Forum Thread Details

I have a Recurring Flow that opens in the mornings and I want it to get message details/attachment in Teams when an Approval Status changes to Approved. Initially, I have a macro that uploads the file into teams/sharepoint and includes fileproperties for a field named MessageID. Which is simply the file name of the file. However, when a user creates an approval within Teams they enter this same data as the subject of the message and add the link attachment to the approval request.

So after the initial trigger it gets file properties from where the files are stored in Teams/Sharepoint where ApprovalStatus eq 'null' (So it only reviews files without approvals yet).

Next action is to Get Message Details where the MessageID eq 'Message Subject in Teams'.

Then check if the status is Approved if it is not then move on through each of the files.

If it does show status as approved then input the Approved status in the fileproperties named ApprovalStatus.

Then I want it to open the Excel file that is in Sharepoint/Teams, open a file on my network, copy the data from the file into the file that is on my network.

Any Ideas. I am really hoping for some responses as most of the time I never receive any. I think most just answer the quick and easy ones just to bolster their scores.

Anyone up for a challenge, here you go.

Categories:

Building flows