Forum Discussion
Alvin_Gregorio
Oct 21, 2021Copper Contributor
=TEXTJOIN: Not Returning Text
Hello Everyone,
I am just now learning about the TEXTJOIN function.
I have entered my argument seemingly correctly, as it appears correct in the Function Arguments window.
But it is not appearing correctly in the worksheet cell.
In the attached file, Cell B27 is a TEXTJOIN(...)
Can anyone review and ascertain what the issue is?
Thank you, Alvin
OneHundredthProfile There is no SharePoint out of the box calendar web part available in SharePoint online modern experience.
You can create a calendar view in SharePoint online lists but unfortunately you cannot sync it with the Outlook calendar.
So, If you are looking for SharePoint out of the box options, you will have to use the classic experience calendar currently. You can also create the calendar list from SharePoint UI. Check my answer here for detailed steps: Issue with adding app option
Else, you will have to use the custom solutions like:
- Create a custom SPFx web part - you can use Microsoft Graph API calls to read the outlook data in SPFx. Check Showing a calendar as a group calendar instead of events web part and Outlook to SharePoint
- Use Power automate to update outlook calendar whenever there it item created/updated/deleted in SharePoint list
- Create Canvas Power Apps, add SharePoint and Outlook connector to show events or add/update/deleted events
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
3 Replies
Sort By
- Detlef_LewinSilver ContributorChange the cell format from Text to General. Then press F2 and ENTER.
- LonnieErvinCopper ContributorThis worked. Thanks Detlef
- Alvin_GregorioCopper ContributorThank You. That works.
I wish I knew why. But Thanks Detlef. -Alvin