cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Prompt users to fill metadata when they upload document in document library and use that metadata value in flow?

Hi,

 

I'm in office 365 environment. My requirement is to create a ms flow when new item is created in Document library. When ever there is a new item my flow works perfectly fine but the problem is, I need few column's value to work on during the flow execution. When I upload a document, my flow get started without prompting for metadata. If I mark any of the field as required, then I get trigger error message in the flow.

 

I remember in SP 2013 we get prompt to fill all the required fields after document upload. Is there any work around to prompt end user to fill all the necessary information before flow kicks off.

 

I can't use "Item created or modified" trigger action.

 

Thank you.

3 REPLIES 3
Super User
Super User

Hi @ss_bent 

You can enable the check-in and check-out features in the document library, and in your flow, you can check the document checked-in status and continue with the business logic only when the file is checked-in. Obviously in a document library, if some of the metadata are made mandatory, users will be forced to fill in the metadata before check-in the file.

Try to refer the below URL, where its clearly explained on how to check the check-in status.

How to refer the check-in status

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Hi Sudharsan,

 

Thank you for your response.

 

I understand your idea and I was thinking in the same direction. But later in the process, Document properties will be changed from PowerApp as well(with different flow) because I need user input from powerapps(not using by send an email with option or approvals). They will attach a copy of new modified document(e.g expert's comments on pdf itself) so that designers can change the document accordingly. If experts feels that document is accurate, I'll simply change the status and assign the task to next approver.

 

If I use your suggested approach, flow will trigger every time when document property get modified(from powerapp e.g rejected). I'm thinking mandatory field get filed when new item created and I just call a trigger(When New item created)

 

Thank you,

Shub 

Hi, You can check the check-in and check-out status before running the flow. Maybe in your PowerApp check-in the file once all the fields are updated and while modifying check-out, so that the flow won't be triggered.
Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (93,508)