User Profile
MichaelMr
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Lists calculated column - Last 3 months without the current month (if not complete)
I think I advanced a bit unsing the formula =IF(AND(usedtest="used",(DATEDIF([used date],((TODAY()-(DAY(TODAY())))),"D"))<=90),1,0) to subtract the amount of days in this months from today, but unfortunately it returns for the field that contains a date of the current month the #num! error. Any idea for this?Lists calculated column - Last 3 months without the current month (if not complete)
Hi, I have a calculated column in lists that checks a column if the is the word " used" in it and then looks for all fields with "used" in the last 3 months. =IF(AND(used="used",(DATEDIF([used date],(TODAY()),"D"))<90),1,0) Is there a was to look for the last 3 complete months? For example: Today is 11 of February, so February is not completed. Because of that I want to have the months November, December and January. When February is completed then, Dezember, January and February, ... I tried=IF(AND(used="used",(DATEDIF([used date],(TODAY()-Day(TODAY()),"D"))<90),1,0) to subtract the current day from today but this gives me the #NUM! error for a field where the date in the "used date" column is february 9th.Lists If AND calculation
Hi, I have a list in microsoft lists containing a number of columns. One (used ind) is an indicator if a product was used or not (used=1, nor used=0). Another column has the date the product was used in it (used date) I want to calculate how much products were used per month based on the numbers of the last three months. My idea was to use the (used ind) column as one condition that has to be true (because there are also unused products on the list) and the other condition as a DATEDIF function: DATEDIF([used date],TODAY(), "D")<90 <90 because it only should be the products used in the last 3 months. =IF(AND([used ind]=1; DATEDIF([used date], TODAY(),"D")<90); 1;0) The 1 and 0 at the end is only for testing to better see if the formula works, otherwise it shoud be SUM(used ind)/3 Unfortunately it is not working, when I try to save the formula ist gives me the error "syntax error or not supported". Can someone help me with this?Re: Flow changes "modified by" column
RobElliott Hi Rob, thank you. That solved the problem. One additional question: The flow works fine as long as the original "modified by" column is visible in the list. If I hide the "modifiedy by" colum the flow runs without error but nothing is entered in the new "ChangedBy" column. How can I solve this?Re: Flow changes "modified by" column
RobElliott Hi Rob, of course: first step is to set the trigger, second one is the step from your post, third step to create a timestamp for my "date used" column, then the conditions: "used" column hast to be "used", "date used" column has to be empty, and the condition from your post "... has changed"Re: Flow changes "modified by" column
Hi Rob, I tried your solution, thank you ver much for that. Unfortunately the flow return an error: "Invalid format for version input value\r\nclientRequestId: c2592141-eca8-438e-8c1e-ef7d587f5703\r\nserviceRequestId: c2592141-eca8-438e-8c1e-ef7d587f5703" Do you know what to do?Re: Flow changes "modified by" column
Hi Rob, thank you for your answer. How would I do that? I am quite new to power automate. Can I combine this with the flow that ckecks if the field value is "used" and puts the current date to the date column? Perhaps with a parallel branch --> get item "mydiefied by" field and then?Flow changes "modified by" column
Hello, I have flow that automatically runs if a certain column is changed in a list. The value of the field gets changed from "in stock" to "used" and triggers the flow that enters the current date into another column. Unfortunately this also changes the "modified by" column back to my name because it it "my" flow that runs and the name of the person that changed the used/instock field gets overwritten. Is the a way the keep the name of the person that changed the used/in stock field?Create "report" sharepoint list from other sharepoint lists
Hi, I have several sharepoint lists. In these lists there is a column "product" containing two different types of products. Also there is a yes/no column for indicating if the product was used or not. I want to create another list linked to the different product lists (product list customerA, product list customerB, ...) where I can easily see "customer A has 6 of product A left in his stock (because 10 are on the list, 4 were used). Same for product B, and all other customers together in one list as an overview. I tried to used additional columns that transfer the columns "used" and "product" into easier format: If used=true, 1,"" and so on. This works, I have a column (counttotal) with 1 in it where product A and used "no" are both true. Unfortunately I do not now how to transfer this to another list to get an good overview like: customar A, product A, sum of amount of 1s in the colum counttotal Can someone help me with this? Kind regards, Michael
