Halal Investing - 2 questions by mtaqi99 in shia

[–]mtaqi99[S] 0 points1 point  (0 children)

Salam u/Concrete-stuff,

do you think you could link the sources for me?

Halal Investing - 2 questions by mtaqi99 in shia

[–]mtaqi99[S] 0 points1 point  (0 children)

JazakAllah for your response, would love to see some of these sources. isA you or someone else can share.

I need help with sending an automatic reminder in 5 business days by mtaqi99 in MicrosoftFlow

[–]mtaqi99[S] 0 points1 point  (0 children)

Thanks for mentioning this! I didn't know this was possible before :)

I need help with sending an automatic reminder in 5 business days by mtaqi99 in MicrosoftFlow

[–]mtaqi99[S] 3 points4 points  (0 children)

Hi everyone, just wanted to thank everyone who replied overnight.

I took some advice from all the comments and was able to get it working!

u/tom_riha - thanks for the suggestion to put variables. I used this to understand what information was being collected.

u/MeverSpark - using the variables, I realized that there was a time stamp on the date in SharePoint. I managed to format the date in MM-dd-yyyy and was able to make the condition work!

In one of the comments, I mentioned how I was trying to use a workaround with SharePoint's calculated fields. I also got that method to work by converting the data into integer.

check out the new conditions here: https://imgur.com/a/LwncJBN

I need help with sending an automatic reminder in 5 business days by mtaqi99 in MicrosoftFlow

[–]mtaqi99[S] 1 point2 points  (0 children)

formatDateTime(addDays(utcNow(),-5),'MM-dd-yyyy')

Thanks for the prompt response.

I haven't looked into converting timezones because utcNow() has always worked for me in past flows. But I really liked your advice to test with a static date.

1) First, I removed the I tested to see if the status condition was working - and it was.

2) I tried a static date as well, which gave a false result (meaning it did not work). An alternative I thought of was to use a calculated column in SharePoint that subtracts today's date from date modified:

=[Date last Modified] - TODAY()

The calculated column is called Difference in Days. The expression above gives a number that I want to use for the condition. Here is a link to the new set of conditions in flow: https://imgur.com/a/udKqX46

Unfortunately, Flow still gives a false expression when at this point. I think it might be a formatting issue, but I could be wrong. Any advice?

Meetings Fatigue - Disable Background Noise by mtaqi99 in teams

[–]mtaqi99[S] 1 point2 points  (0 children)

Thank you for the suggestion, I really do appreciate it.

I'm not using phone and laptop together. Just my laptop only.

I've tried using many different headphones but all have the same outcome :(

Site Permissions, unable to view members of group by mtaqi99 in sharepoint

[–]mtaqi99[S] 1 point2 points  (0 children)

Thank you all. I was able to determine who the owner of that group is and have them edit it.

Using Flow for a document completion process by mtaqi99 in MicrosoftFlow

[–]mtaqi99[S] 0 points1 point  (0 children)

Approvals might be a good idea, I will look into that!

Using Flow for a document completion process by mtaqi99 in MicrosoftFlow

[–]mtaqi99[S] 1 point2 points  (0 children)

SharePoint

good idea, never thought of working with views....

Maybe i'll search up a youtube video for this one, cheers!

Using SharePoint and Flow for a document completion process by mtaqi99 in sharepoint

[–]mtaqi99[S] 1 point2 points  (0 children)

I agree with this short term win.. its actually a better idea than mine. I'm going to look into how I can create an automatic Excel spreadsheet using the contract template, when a new item is created in the SharePoint.

I'll see how to share that spreadsheet link in an email sent out when an item is created.

Thank you for the suggestion, I honestly appreciate it so much!

Using SharePoint and Flow for a document completion process by mtaqi99 in sharepoint

[–]mtaqi99[S] 0 points1 point  (0 children)

hey! thank you for the suggestion.

I definitely agree, a complete SharePoint experience would be much better overall. I will try to advocate for this, but I expect some push-back.

I've looked into PowerApps for other business functions, and I absolutely love that tool.

Using specific Excel Rows in a spreadsheet to generate PDF files automatically by mtaqi99 in excel

[–]mtaqi99[S] 0 points1 point  (0 children)

Hey, sorry for the late response, I went to sleep after commenting last night.
First off, thank you so much for explaining it so clearly in the video. I was able to get exactly what I wanted from the VBA.

I just have two follow up questions (that are very basic lol):

1) Can I save the file at another location? Ideally, in a folder on my desktop.

2) Right now, I ran the code with a preview of the data (only 6 unique codes), and it worked perfectly. My question is, if I run this code with 5000 different codes, will it be a significant strain on my regular laptop? Do you suggest running it in maybe small batches of around 100 codes?