User Profile
MAVOTRP
Copper Contributor
Joined 10 months ago
User Widgets
Recent Discussions
IFERROR formula still returning #N/A
Hello. I have a formula to return either 0 or the cell value * the corresponding match in Table 1: =IF(AND(ISNUMBER(MATCH(1, (Table1[Name adjusted]=A6)*(Table1[Leave Date]=$C$4), 0)), INDEX(Table1[Activity duration - For part-day availability], MATCH(A6&$C$4, Table1[Name adjusted]&Table1[Leave Date], 0))=1), 0, IFERROR(C6*INDEX(Table1[Activity duration - For part-day availability], MATCH(A6&$C$4, Table1[Name adjusted]&Table1[Leave Date], 0)), "")) The formula works when all conditions are met, it will return 0. When conditions are not met, it is still returning#N/A despite the IFERROR applied. Can anyone please provide insight as to why the IFERROR component is not working? Please let me know if additional information is required.Do Until loop creating too many dates
Hello. I have created a flow that identifies the difference of days between Start Date and End Date in a SharePoint List. The flow then checks for weekdays and adds a row into an Excel table for each individual day between theStart Date and End Date that is not a Saturday and Sunday. The main logic of the flow is working correctly where there is more than one day between the Start Date and End Date. The issue I am having is when the difference of days is 0, i.e., the Start and End Date is the same, the flow is creating multiple days and adding them to the Excel table. In the below screenshot I have created the variable varIndex and added a Compose - Day Difference step using the following expression div(sub(ticks(triggerOutputs()?['body/LeaveEndDate']),ticks(triggerOutputs()?['body/LeaveStartDate'])),864000000000). In my Do Until loop I have set the limit to varIndex is equal to the Output ofCompose - Day Difference. As you can see in the next screenshot even though theOutput ofCompose - Day Difference is 0, my Compose varDates step is composing several days and adding them to my Excel table. In this example, the SharePoint List item has Start Date 16/02/2024 andEnd Date 16/02/2024. But instead of just adding one day into the Excel table, it's creating entries from 16/02/2024 to 16/04/2024. There is another list item where it composed the same number of dates where Start Date is 08/02/2024 and End Date is 08/02/2024 Result:08/02/2024 to08/04/2024. Can anyone provide insight on why the flow is creating several days instead of one day? Hopefully I have provided enough information with the above but let me know if more info is needed. TIA.IF AND formula to check name and date then return YES, NO
Hello. I have a formula in Excel that checks if the name in cell A109 matches any of the names in the Name adjusted column of Table1. It also checks if the date in cell D105 matches the Leave Date column of Table1 for the matched name. For example, A109 matches B61 in Name adjusted column of Table1 and D105 matches G61 in Leave Date column of Table1. If there is a match return YES otherwise NO. The formula below is returning YES even when the corresponding rows in Table1 aren't a match. For example, B65 inName adjusted column of Table1 is a match to A110 however the corresponding cell for the same row in Column G, G65, is not a match to D105. Presumably because D105 is finding a match in other cells of Column G it is still returning YES. How do I adjust the below formula so that it only returns YES when the corresponding row for both Columns B and G of Table1 is a match. Example: Return YES if, Sheet 1: A109 = Name and D105 = 21/02/2024 Table1: B56 = Name and G56 = 21/02/2024 =IF(AND(IFERROR(INDEX(Table1[Name adjusted], MATCH(A109, Table1[Name adjusted], 0)), "") = A109, IFERROR(INDEX(Table1[Leave Date], MATCH(D105, Table1[Leave Date], 0)), "") = D105), "YES", "NO")JSON code to reverse display name from last name first name to first name last name
Hi all. I have a JSON code on a Person column where I am trying to reverse the display name from Last name, First name to First Name Last name however the column is displaying the JSON code rather than executing and returningFirst Name Last name. Here is my JSON code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(indexOf([$Scheduler.title], ',') != -1, concat(substring([$Scheduler.title], indexOf([$Scheduler.title], ',')+2), ' ', substring([$Scheduler.title], 0, indexOf([$Scheduler.title], ','))), [$Scheduler.title])" } Can anyone assist please? Unsure if there is a syntax error however SharePoint is accepting the code so it seems correct.
