Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

User Profile

Active_Array

Copper Contributor

Joined 3 years ago

8 Posts

View All Badges

User Widgets

Recent Discussions

Re: Power Automate for Date Difference using SharePoint Column Values
I changed the Get Items to Get Files (Properties only) as it is a document library. The OData filter seems to be having issues though, any ideas what might be causing this: **** The expression "Contract End Date ge '2022-10-14T01:58:04.5678018Z'" is not valid. Creating query failed. clientRequestId: 06047386-18e5-4c44-a390-604df8f520a9 serviceRequestId: 06047386-18e5-4c44-a390-604df8f520a9 ****
Oct 14, 2022 Place Power Apps and Power Automate in SharePoint
9.8KViews
0likes
1Comment
Re: Power Automate for Date Difference using SharePoint Column Values
This is fantastic and looks to be exactly what is needed. I'm tied down for a little bit but will test this out later this week. I'm going to mark this answer in the meantime but will reach out if anything pops up during testing. I really appreciate the detailed response, thank you kindly.
Oct 11, 2022 Place Power Apps and Power Automate in SharePoint
9.9KViews
0likes
0Comments
Power Automate for Date Difference using SharePoint Column Values
Hi everyone, I have a SharePoint document library with columns: "End Date": A date column. "Renewal Notice": A choice column with options: "7 Days" "14 Days" "3 Months" The goal is to check the end date, calculate the amount of days from today to the end date, compare the result to the renewal notice option, and if it matches send a notification email to a predefined email address. I found a date difference expression for Power Automate: div(div(sub(ticks(outputs('End Date')),ticks(outputs('Today'))), 10000000), 86400) I'm unsure how to use the value from SharePoint in this expression. If I attempt the column name "End Date" it throws an error. Maybe I need to compose a variable first, but still unsure of how that would fit into the expression. Maybe my syntax is incorrect or perhaps another avenue must be used entirely. So to elaborate the flow: 1. Runs daily at 1am 2. Pulls the values from the document library 3. Calculates the amount of days from today to the end date 4. Compares if result is equal to the amount in Renewal Notice. (May need to change choice values from string to integers only which is fine) 5. If equal, send email notification. Else do nothing. Any help is greatly appreciated. Thanks, AA
Solved
Oct 05, 2022 Place Power Apps and Power Automate in SharePoint
Microsoft Flow
sharepoint
10KViews
0likes
4Comments
Re: No Dynamic Content Available
RobElliott : Apologies, I should have included the trigger in the previous post. Yes, the "When a file is created or modified (properties only)" trigger is what the action is currently linked to:
Jun 20, 2022 Place Power Apps and Power Automate in SharePoint
11KViews
0likes
3Comments
No Dynamic Content Available
Hi everyone, I'm new to Power Automate and my use case for this flow is to send a notification email when a SharePoint document library column changes state. I understand the steps and logic based on tutorials but where videos and guides all end up having "ID" available to them, I get "No Dynamic Content Available": I saw similar posts on the forums but they didn't address this issue specifically. Is there something preventing my flow from getting this data? Any help is greatly appreciated. Thanks, AA
Jun 17, 2022 Place Power Apps and Power Automate in SharePoint
Microsoft Flow
sharepoint
12KViews
0likes
5Comments
Prevent Custom Document Set from Inheriting Document Library Columns
Hi all, I'm new to content types, but I've got the overall hang of it. Essentially, I've created a new site content type "Contract Set" with Document Set as the parent. I've enabled content type management on the library where it will be used and I can successfully use it. My issue is that I was expecting the contract set to use the metadata/columns I assigned it: Name, Description, etc., but when I go into the contract set, it is listing all of the parent document library columns instead. My goal is to package sets of documents into a content type that can retain metadata at the library level but within the content type itself, have a separate set of columns different from the document library. Any help is greatly appreciated. Thanks, AA
Solved
Jun 10, 2022 Place SharePoint
SharePoint Online
1.1KViews
0likes
1Comment
Re: SharePoint Content Type and Document Template Form
Any thoughts on this? It's basically the form won't load to enter metadata before the document is created. How can I trigger the form to load again? I've recreated the form in PowerApps, but I'm not sure how to the trigger the form to load when selecting the document template/content type from the "New" button in the library. Thanks, AA
Apr 28, 2022 Place SharePoint
1KViews
0likes
0Comments
SharePoint Content Type and Document Template Form
Hi everyone, We migrated from 2013 to SPO using ShareGate. Everything looks pretty good for the most part. We have a library called "123". Three content types are associated with the library and were brought over with it: CTA, CTB, CTC. When I previously selected New Document>CTA in 2013, a form would appear asking me to enter the metadata: Name, Year, Month, etc. (All metadata associated with the content type). I would enter this information and click "Save" and then WordWebApp would load. After saving, the document would be located in the library with all associated metadata entered on the form presented during creation. In SharePoint Online (SPO), everything looks similar in the library (Modern view now), but when I select New>CTA it doesn't present the form to enter the metadata. It loads Word on the web and throws: "The document you are trying to open is a template. Would you like to open and edit as a standard document?" If I select "No", nothing happens and Word on the web stays blank with no UI. If I select "Yes", it loads Word on the web into a blank document but after saving, none of the metadata is saved for the record in the library. I've fired up PowerApps and edited the form and all looks fine, I just can't get it to present at the creation of the document content type using "New" in the document library. Any ideas how to get that linked back up? Thanks, AA
Apr 07, 2022 Place SharePoint
SharePoint Online
1.1KViews
0likes
1Comment

Groups

Recent Blog Articles

No content to show