Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
pkumarsharma
Regular Visitor

Power Query twitter post splitter

Hi All

 

I want to create an automation of my public post in twitter. Below is a sample of my posts to be shared. Due to the character limit of 280 i have to break this post in parts. Could someone help to split this post column dynamically so it breaks the post at lets say at an approx break of 250 characters but without breaking the word.

Many thanks in advance.

 

PostPost Length
Veganuary
Throughout the year, Veganuary encourages and supports people and businesses alike to move to a plant-based diet as a way of protecting the environment, preventing animal suffering, and improving the health of millions of people.
 #CAREFORWELFARE #Veganuary
https://veganuary.com/
291
World Braille Day
International World Braille Day is celebrated yearly in recognition of the birth of Louis Braille, born on January 4th, 1809.
 #CAREFORWELFARE #WorldBrailleDay
https://www.un.org/en/observances/braille-day
224
International Day of Education
The United Nations General Assembly proclaimed 24 January as International Day of Education, in celebration of the role of education for peace and development. The right to education is enshrined in article 26 of the Universal Declaration of Human Rights. The declaration calls for free and compulsory elementary education. The Convention on the Rights of the Child, adopted in 1989, goes further to stipulate that countries shall make higher education accessible to all.
 #CAREFORWELFARE #InternationalDayofEducation
https://www.un.org/en/observances/education-day
597
World Leprosy Sunday
The last Sunday in January is World Leprosy Day. It is a great opportunity to raise our voice on behalf of those affected by leprosy.
 #CAREFORWELFARE #WorldLeprosySunday
https://www.leprosymission.org.au/get-involved/world-leprosy-sunday/
261
World Neglected Tropical Diseases Day
On 31 May 2021, the World Health Assembly (WHA) recognized 30 January as World Neglected Tropical Disease (NTD) Day through decision WHA74(18). This decision formalized 30 January as a day to create better awareness on the devastating impact of NTDs on the poorest populations around the world. The day is also an opportunity to call on everyone to support the growing momentum for the control, elimination and eradication of these diseases. Global NTD partners had marked the celebration in January 2021 by organizing various virtual events and also by lighting up landmark monuments and buildings.
 #CAREFORWELFARE #WorldNeglectedTropicalDiseasesDay
https://www.who.int/campaigns/world-ntd-day
734
RedFeb
This coming February, we invite you to wear RED for someone close to your heart. Heart disease is Australia’s leading cause of death affecting families and communities around the country.  Can you help us fund much needed life-saving breakthroughs to help us keep families together for longer? Help us make breakthroughs happen and reduce the devastation heart disease causes families and communities.
 #CAREFORWELFARE #RedFeb
https://www.heartresearch.com.au/redfeb/
475
Ovarian Cancer Awareness Month
Educate. Only 31% of Australians know that ovarian cancer has the poorest survival rate of any female cancer in Australia. This devastating disease suffers from a lack of awareness and progress, we will continue to spread evidence based information every Australian should know about this disease. Advocate on behalf of those impacted by ovarian cancer for more research funding, better laws and policies, greater access to affordable treatment options and ultimately better outcomes for all those affected. Elevate the voices of women impacted by this disease by sharing their stories, their real life experiences and getting these stories in front of as many eyes and ears as possible.
 #CAREFORWELFARE #OvarianCancerAwarenessMonth
https://www.ovariancancer.net.au/page/155/ovarian-cancer-awareness-month
838
NSW Seniors Festival
NSW Seniors Festival is the largest festival for seniors in the Southern Hemisphere, reaching up to 500,000 seniors each year. If you are over 60, NSW Seniors Festival gives you the chance to make new friends or get together with old ones at an array of local community events, many which are free or heavily discounted.
 #CAREFORWELFARE #NSWSeniorsFestival
https://www.seniorsfestival.nsw.gov.au/
419
Febfast
Give up alcohol, sugar or a vice of your own and stand with young Australians experiencing alcohol or other drug issues.
 #CAREFORWELFARE #Febfast
https://febfast.org.au/
179
HeartKids Awareness Month
February is HeartKids Awareness Month. HeartKids is trying to raise awareness and funds in Australia about Childhood Heart Disease (CHD), which is one of the biggest killers of children under the age of one.
 #CAREFORWELFARE #HeartKidsAwarenessMonth
https://www.heartregistry.org.au/2012/02/open-your-heart-for-heartkids-in-feb/
355
World Wetlands Day
It is urgent that we raise national and global awareness about wetlands in order to reverse their rapid loss and encourage actions to conserve and restore them. World Wetlands Day is the ideal time to increase people’s understanding of these critically important ecosystems. “Revive and restore degraded wetlands” is the theme for 2023 highlighting the importance of wetlands’ restoration, since well-restored wetlands can provide many of the services performed by the original natural wetland. An urgent call to take action and to invest financial, human and political capital is this year’s appeal to save the world’s wetlands from disappearing altogether — and to restore those we have already lost.
 #CAREFORWELFARE #WorldWetlandsDay
https://www.un.org/en/observances/world-wetlands-day
810
World Cancer Day
World Cancer Day is a chance to raise our collective voices in the name of improving general knowledge around cancer and dismissing misconceptions about the disease.
 #CAREFORWELFARE #WorldCancerDay
https://www.worldcancerday.org/about/2022-2024-world-cancer-day-campaign
289
Feeding Tube Awareness Week
The mission of Feeding Tube Awareness Week is to promote the positive benefits of feeding tubes as lifesaving medical interventions. The week also serves to educate the broader public about the medical reasons that children and adults are tube fed, the challenges that families face, and day-to-day life with tube feeding.
 #CAREFORWELFARE #FeedingTubeAwarenessWeek
https://www.feedingtubeaware.com.au/
431
Tinnitus Awareness Week
The impact of tinnitus can be devastating. In 2017, the International Tinnitus Journal reported that 45% of tinnitus sufferers experience anxiety and 33% have major depression. Yet, despite its ubiquity, tinnitus is poorly understood and frequently underestimated as a cause of suffering and distress. Tinnitus Awareness Week, takes place from 6 – 12 February 2023, with our Tea for Tinnitus fundraising event on 9 February.
 #CAREFORWELFARE #TinnitusAwarenessWeek
https://www.tinnitusaustralia.org.au/tinnitusawarenessweek/
549
International Day of Zero Tolerance to Female Genital Mutilation (WHO)
The International Day of Zero Tolerance to Female Genital Mutilation, on 6 February each year, is a time to make the world aware of female genital mutilation (FGM). According to data from the World Health Organisation (WHO), an estimated 120 to 140 million women have been subject to this harmful practice and 3 million girls continue to be at risk each year. FGM is recognised internationally as a violation of human rights.
 #CAREFORWELFARE #InternationalDayofZeroTolerancetoFemaleGenitalMutilation(WHO)
https://www.un.org/en/observances/female-genital-mutilation-day
641
Safer Internet Day
Safer Internet Day is a global event that brings together communities, families, schools and organisations from more than 200 countries to help create safer online spaces. This worldwide initiative is celebrating 20 years in 2023, making it a great time to reflect as well as look forward. 
 #CAREFORWELFARE #SaferInternetDay
https://www.esafety.gov.au/newsroom/whats-on/safer-internet-day-2023
414
World Pulses Day
#WorldPulsesDay #LovePulses Recognizing their value, on 20 December 2013, the UN General Assembly adopted a resolution (A/RES/68/231) proclaiming 2016 as the International Year of Pulses (IYP). The celebration of the year, led by the Food and Agriculture Organization of the United Nations (FAO), increased the public awareness of the nutritional and environmental benefits of pulses as part of sustainable food production.
 #CAREFORWELFARE #WorldPulsesDay
https://www.un.org/en/observances/world-pulses-day
525
International Day of Women and Girls in Science
The United Nations have proclaimed February 11 the International Day of Women and Girls in Science aiming to ensure full and equal access to and participation in science for women and girls.
 #CAREFORWELFARE #InternationalDayofWomenandGirlsinScience
https://www.un.org/en/observances/women-and-girls-in-science-day
363
International Day for the Prevention of Violent Extremism as and when Conducive to Terrorism
In its resolution 77/243, the General Assembly decided to declare 12 February the International Day for the Prevention of Violent Extremism as and when Conducive to Terrorism, in order to raise awareness of the threats linked to violent extremism, as and when conducive to terrorism, and to enhance international cooperation in this regard.
 #CAREFORWELFARE #InternationalDayforthePreventionofViolentExtremismasandwhenConducivetoTerrorism
https://www.un.org/en/observances/prevention-extremism-when-conducive-terrorism-day
616
World Radio Day
On World Radio Day 2023, UNESCO highlights independent radio as a pillar for conflict prevention and peacebuilding. An armed conflict between countries or groups within a country may also translate into a conflict of media narratives. The narrative can either increase tensions or maintain conditions for peace.  In reporting and informing the general public, radio stations shape public opinion and frame a narrative that can influence domestic and international situations and decision-making processes. Increasing radio’s journalistic standards and capacity should be considered as an investment in peace.
 #CAREFORWELFARE #WorldRadioDay
https://www.un.org/en/observances/radio-day
701
Sweetheart Day
HeartKids Australia is launching Sweetheart Day on 14 February to raise awareness of childhood heart disease and encourage donations to continue our work in providing support, advocacy, growing awareness and enabling further research into CHD.
 #CAREFORWELFARE #SweetheartDay
https://www.sweetheartday.org.au/
325
National Condom Day
National Condom Day is celebrated each year to remind us that one of the easiest ways to look after your health, and the health of your sexual partners, is to use a cheap, readily available form of contraception that also protects against sexually transmissible infections (STIs).
 #CAREFORWELFARE #NationalCondomDay
https://medicine.unimelb.edu.au/cersh/shout-project/campaigns/national-condom-day
419
World Day of Social Justice
The General Assembly recognizes that social development and social justice are indispensable for the achievement and maintenance of peace and security within and among nations and that, in turn, social development and social justice cannot be attained in the absence of peace and security, or in the absence of respect for all human rights and fundamental freedoms.
 #CAREFORWELFARE #WorldDayofSocialJustice
https://www.un.org/en/observances/social-justice-day
489
International Mother Language Day
International Mother Language Day recognizes that languages and multilingualism can advance inclusion, and the Sustainable Development Goals’ focus on leaving no one behind.  UNESCO encourages and promotes multilingual education based on mother tongue or first language. It is a type of education that begins in the language that the learner masters most and then gradually introduces other languages. This approach enables learners whose mother tongue is different from the language of instruction to bridge the gap between home and school, to discover the school environment in a familiar language, and thus, learn better.
 #CAREFORWELFARE #InternationalMotherLanguageDay
https://www.un.org/en/observances/mother-language-day
762
Summer’s Day
On this day each year stop and remember all the children who lost their lives as a result of an unintentional injury, and acknowledge those children and families living with the consequences of preventable injury.
 #CAREFORWELFARE #Summer’sDay
https://www.summersday.com.au/
288
Rare Disease Day
Rare Disease Day is the globally-coordinated movement on rare diseases, working towards equity in social opportunity, healthcare, and access to diagnosis and therapies for people living with a rare disease.
 #CAREFORWELFARE #RareDiseaseDay
https://www.rarediseaseday.org/countries/australia/
309
Melanoma March
Melanoma March celebrates Melanoma Institute Australia’s major annual fundraising campaign. Each Melanoma March brings together melanoma patients, their families, and local communities to raise awareness and funds for research to reach our goal of zero deaths from melanoma – a goal we believe we can reach this decade.
 #CAREFORWELFARE #MelanomaMarch
https://melanomamarch.org.au/cms/about
406
March Into Yellow
March is Endometriosis Awareness Month. March into Yellow encourages our broader community to show their support for the invisible illness by adorning themselves in the colour yellow. It is also a fun way to raise funds for Endometriosis Australia who support endometriosis education and research.
 #CAREFORWELFARE #MarchIntoYellow
https://www.marchintoyellow.org.au/
386
The March Charge
The March Charge is a fun, personal fitness challenge that has an enormous impact on how cancer is researched and treated. Just by walking or running for Cancer Council this March, and by raising funds you can help us Charge ahead with research and support services. Choose to Charge solo or get your friends, family, or colleagues together and do it as a team – it’s up to you.
 #CAREFORWELFARE #TheMarchCharge
https://www.cancer.org.au/the-march-charge
472
1 REPLY 1
m_dekorte
Super User
Super User

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Users online (2,945)