Month: June 2024
VLOOKUP References to tables with new columns
Hello,
I have a question about shifting vlookup references when adding new columns to the referenced table.
Ex: I have a master data table with all my data
I have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number.
Original formula:
After the new column add:
As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31).
How should I write it so it shifts and I can add/delete columns if ever needed?
Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit.
Thanks in advance!
Hello, I have a question about shifting vlookup references when adding new columns to the referenced table.Ex: I have a master data table with all my dataI have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number. Original formula:After the new column add: As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31). How should I write it so it shifts and I can add/delete columns if ever needed? Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit. Thanks in advance! Read More
Access database query
I am trying to build a database for my law firm to log documents we are storing for clients. I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc).
What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored. I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this.
Any guidance would be very much appreciated
I am trying to build a database for my law firm to log documents we are storing for clients. I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc). What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored. I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this. Any guidance would be very much appreciated Read More
Highlighting any cell with ‘X'(text) based on a cells value in corresponding row
Hey guys,
I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials.
I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help!
Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):
https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin
So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case.
I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.
I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice.
Hope some more skilled people out there can help! 🙂
Regards,
Nicky
Hey guys,I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials. I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help! Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case. I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice. Hope some more skilled people out there can help! :)Regards,Nicky Read More
I want to Develop Unit Conversion Website like UZZA
I wnat to develop Unit Conversion website like Uzza Soft , How can devlop this with bulk creation in .net ?
I wnat to develop Unit Conversion website like Uzza Soft , How can devlop this with bulk creation in .net ? Read More
Teams Room System Autopilot deployment does not work – Error Code: 6, 0x80180014
Problem:
We are attempting to deploy our Microsoft Teams Room (MTR) systems, some of which are already in use, using Windows Autopilot in self-deploying mode. Despite following the official guide, we keep encountering errors.
https://learn.microsoft.com/en-us/microsoftteams/rooms/autopilot-autologin
Procedure:
Device: Certified Intel NUC, previously in use.
Installation: Windows 11 Pro installed.
Autopilot Import: Device imported into Autopilot.
Group Assignment: GroupTag “MTR-ConsoleName” assigned.
Dynamic Group: Device appeared in the Dynamic MTR group.
Assignments: Deployment Profile and ESP (Enrollment Status Page) assigned.
Teams Room Update App: Deployed via Intune, assigned to the MTR group, and integrated into the ESP.
LAPS: Local Administrator Password Solution (LAPS) is active.
Teams Rooms Pro Console: Device appeared and was assigned to a resource account with a Teams Room Pro license.
Error Description:
After the setup process, we consistently encounter an error during device registration for mobile management:
Error Code: 6, 0x80180014
Attempts to resolve the issue:
Deleted the device completely from Intune and Autopilot and re-added it.
Created a custom Device Restriction Policy to allow all devices in the group.
Additionally, during one attempt where the error did not occur, Teams failed to set up automatically.
Questions:
Why does error 6, 0x80180014 occur during device registration for mobile management?
Are there specific requirements or settings beyond the official guide that need to be considered?
What steps can be taken to ensure that Teams sets up automatically when the registration error does not occur?
Objective:
We aim to ensure that the MTR systems are smoothly deployed via Autopilot in self-deploying mode and that Teams sets up automatically. Thank you for your support!Teams Room System Autopilot deployment does not work – Error Code: 6, 0x80180014
Problem:We are attempting to deploy our Microsoft Teams Room (MTR) systems, some of which are already in use, using Windows Autopilot in self-deploying mode. Despite following the official guide, we keep encountering errors.https://learn.microsoft.com/en-us/microsoftteams/rooms/autopilot-autologin Procedure:Device: Certified Intel NUC, previously in use.Installation: Windows 11 Pro installed.Autopilot Import: Device imported into Autopilot.Group Assignment: GroupTag “MTR-ConsoleName” assigned.Dynamic Group: Device appeared in the Dynamic MTR group.Assignments: Deployment Profile and ESP (Enrollment Status Page) assigned.Teams Room Update App: Deployed via Intune, assigned to the MTR group, and integrated into the ESP.LAPS: Local Administrator Password Solution (LAPS) is active.Teams Rooms Pro Console: Device appeared and was assigned to a resource account with a Teams Room Pro license.Error Description:After the setup process, we consistently encounter an error during device registration for mobile management: Error Code: 6, 0x80180014Attempts to resolve the issue: Deleted the device completely from Intune and Autopilot and re-added it.Created a custom Device Restriction Policy to allow all devices in the group.Additionally, during one attempt where the error did not occur, Teams failed to set up automatically. Questions:Why does error 6, 0x80180014 occur during device registration for mobile management?Are there specific requirements or settings beyond the official guide that need to be considered?What steps can be taken to ensure that Teams sets up automatically when the registration error does not occur?Objective:We aim to ensure that the MTR systems are smoothly deployed via Autopilot in self-deploying mode and that Teams sets up automatically. Thank you for your support!Teams Room System Autopilot deployment does not work – Error Code: 6, 0x80180014 Read More
Scheduling meetings with N facilitators who change for each meeting
Hello,
I have set up a Bookings system for my company to organize presentations with my clients. However, I am encountering an issue. I need to organize meetings involving multiple clients and facilitated by several members of my team.
My problem is that the facilitators vary for each meeting of the same service. Therefore, I cannot use the option “Assign all selected staff for an appointment” because it would send invitations to too many irrelevant collaborators, and this option does not allow me to select the specific facilitators I want for a particular meeting. So this option does not suit me because my meetings are scheduled over several weeks with multiple facilitators who vary from one meeting to another, which is not possible when selecting this staff assignment option
If I choose the option “Assign any of your selected staff,” it allows me to select the specific facilitators for each meeting (which is my goal), but it creates duplicate invitations. One of the selected facilitators ends up on the invitation with all the registered clients, while the other facilitators remain in the initial invitation.
Is there a solution to this problem so that I can precisely select facilitators each time I schedule a meeting, without ending up with a single facilitator having all the clients and without having to modify my service every time ?
Thank you in advance for your help.
Hello,I have set up a Bookings system for my company to organize presentations with my clients. However, I am encountering an issue. I need to organize meetings involving multiple clients and facilitated by several members of my team.My problem is that the facilitators vary for each meeting of the same service. Therefore, I cannot use the option “Assign all selected staff for an appointment” because it would send invitations to too many irrelevant collaborators, and this option does not allow me to select the specific facilitators I want for a particular meeting. So this option does not suit me because my meetings are scheduled over several weeks with multiple facilitators who vary from one meeting to another, which is not possible when selecting this staff assignment optionIf I choose the option “Assign any of your selected staff,” it allows me to select the specific facilitators for each meeting (which is my goal), but it creates duplicate invitations. One of the selected facilitators ends up on the invitation with all the registered clients, while the other facilitators remain in the initial invitation.Is there a solution to this problem so that I can precisely select facilitators each time I schedule a meeting, without ending up with a single facilitator having all the clients and without having to modify my service every time ?Thank you in advance for your help. Read More
Conditional Access and Teams MFA problem
Hello,
Problem : We have MFA trigger set to every 24hours for laptops with exclusion made “Microsoft Teams Services” because it will kick you out of a meeting if it triggers at that time, and we cant set the time of the MFA pop up, so we just excluded Teams.
That is applied to about 80% of the company correctly, but there is 4-5 people that still get asked for MFA every 24h hours by Teams.
I cannot find any factor that is the same on those users which could explain this.
On sign in logs i can see that the Conditional access policy was applied that has Teams excluded.
Anyone have any suggestions?
Best regards
Hello, Problem : We have MFA trigger set to every 24hours for laptops with exclusion made “Microsoft Teams Services” because it will kick you out of a meeting if it triggers at that time, and we cant set the time of the MFA pop up, so we just excluded Teams.That is applied to about 80% of the company correctly, but there is 4-5 people that still get asked for MFA every 24h hours by Teams.I cannot find any factor that is the same on those users which could explain this.On sign in logs i can see that the Conditional access policy was applied that has Teams excluded.Anyone have any suggestions? Best regards Read More
Handling AVD Disconnected session
Hi Team,
We are using Azure VD, and we don’t have domain services (GP option not available). Is there any Intune Policy or any other policy that could logoff the AVD user session from the session host VM instead just disconnecting the session.
I am looking for some way to log out/off the user session once its state is disconnected or any way to populate option for session host to have ‘log out/log off from the session instead ‘disconnect’
Regards,
Hi Team, We are using Azure VD, and we don’t have domain services (GP option not available). Is there any Intune Policy or any other policy that could logoff the AVD user session from the session host VM instead just disconnecting the session. I am looking for some way to log out/off the user session once its state is disconnected or any way to populate option for session host to have ‘log out/log off from the session instead ‘disconnect’ Regards, Read More
Saved places and location alerts – Microsoft Support
Details Family Safety location features, like how to save a place to your family map and set location alerts. Location alerts are a premium feature.
Set up drive safety – Microsoft Support
An explanation of drive safety, a premium Family Safety feature. This includes where it’s available and how to enable it.
Leave family group or remove members – Microsoft Support
How to remove members from your family group when you’re on your PC, including adult and child accounts.
sensitivity analysis from monte carlo
Hi, i’m trying to reach out for help from anyone expert here. I’m having trouble to run a sensitivity analysis. I have write a script to generate monte carlo uncertainty propogation for 2 paramaters. So, i want to run sensitity analysis from the script. But, i dont know how.
Here is the script. Can anyone help me to generate sensitivity analysis please?
PoissonRatio = 0.348;
diameter = 100;
pi = 3.142;
nsamples = 100000;
for i=1 : nsamples
modulus = 191.6e3+rand(1)*10.1e3;
thickness = 0.5+0.5*rand(1);
Po (i) = (2*pi*50*210.8);
pcr (i) = (2*pi*modulus*thickness^2)/(3*(1-PoissonRatio^2)*0.5);
pRankine (i) = (Po(i)/((Po(i)/pcr(i))+1))/1000;
end
min(pRankine);
max(pRankine);
mean(pRankine);
std(pRankine);
hist(pRankine,100);
% Calculate the mean and standard deviation of the output samples
sample_mean = mean(pRankine);
sample_std = std(pRankine);
% Plot a vertical line at the mean of the output samples
line([sample_mean sample_mean], ylim, ‘LineWidth’, 2, ‘Color’, ‘r’);
% Plot a shaded region around the mean representing one standard deviation
shaded_region = [sample_mean – sample_std, sample_mean + sample_std];
patch([shaded_region(1) shaded_region(1) shaded_region(2) shaded_region(2)], …
[0 max(ylim) max(ylim) 0], ‘r’, ‘FaceAlpha’, 0.2, ‘EdgeColor’, ‘none’);
% Label the plot
xlabel(‘pRankine (kN)’);
ylabel(‘Probability Density’);
title(‘Monte Carlo Uncertainty Propagation’);Hi, i’m trying to reach out for help from anyone expert here. I’m having trouble to run a sensitivity analysis. I have write a script to generate monte carlo uncertainty propogation for 2 paramaters. So, i want to run sensitity analysis from the script. But, i dont know how.
Here is the script. Can anyone help me to generate sensitivity analysis please?
PoissonRatio = 0.348;
diameter = 100;
pi = 3.142;
nsamples = 100000;
for i=1 : nsamples
modulus = 191.6e3+rand(1)*10.1e3;
thickness = 0.5+0.5*rand(1);
Po (i) = (2*pi*50*210.8);
pcr (i) = (2*pi*modulus*thickness^2)/(3*(1-PoissonRatio^2)*0.5);
pRankine (i) = (Po(i)/((Po(i)/pcr(i))+1))/1000;
end
min(pRankine);
max(pRankine);
mean(pRankine);
std(pRankine);
hist(pRankine,100);
% Calculate the mean and standard deviation of the output samples
sample_mean = mean(pRankine);
sample_std = std(pRankine);
% Plot a vertical line at the mean of the output samples
line([sample_mean sample_mean], ylim, ‘LineWidth’, 2, ‘Color’, ‘r’);
% Plot a shaded region around the mean representing one standard deviation
shaded_region = [sample_mean – sample_std, sample_mean + sample_std];
patch([shaded_region(1) shaded_region(1) shaded_region(2) shaded_region(2)], …
[0 max(ylim) max(ylim) 0], ‘r’, ‘FaceAlpha’, 0.2, ‘EdgeColor’, ‘none’);
% Label the plot
xlabel(‘pRankine (kN)’);
ylabel(‘Probability Density’);
title(‘Monte Carlo Uncertainty Propagation’); Hi, i’m trying to reach out for help from anyone expert here. I’m having trouble to run a sensitivity analysis. I have write a script to generate monte carlo uncertainty propogation for 2 paramaters. So, i want to run sensitity analysis from the script. But, i dont know how.
Here is the script. Can anyone help me to generate sensitivity analysis please?
PoissonRatio = 0.348;
diameter = 100;
pi = 3.142;
nsamples = 100000;
for i=1 : nsamples
modulus = 191.6e3+rand(1)*10.1e3;
thickness = 0.5+0.5*rand(1);
Po (i) = (2*pi*50*210.8);
pcr (i) = (2*pi*modulus*thickness^2)/(3*(1-PoissonRatio^2)*0.5);
pRankine (i) = (Po(i)/((Po(i)/pcr(i))+1))/1000;
end
min(pRankine);
max(pRankine);
mean(pRankine);
std(pRankine);
hist(pRankine,100);
% Calculate the mean and standard deviation of the output samples
sample_mean = mean(pRankine);
sample_std = std(pRankine);
% Plot a vertical line at the mean of the output samples
line([sample_mean sample_mean], ylim, ‘LineWidth’, 2, ‘Color’, ‘r’);
% Plot a shaded region around the mean representing one standard deviation
shaded_region = [sample_mean – sample_std, sample_mean + sample_std];
patch([shaded_region(1) shaded_region(1) shaded_region(2) shaded_region(2)], …
[0 max(ylim) max(ylim) 0], ‘r’, ‘FaceAlpha’, 0.2, ‘EdgeColor’, ‘none’);
% Label the plot
xlabel(‘pRankine (kN)’);
ylabel(‘Probability Density’);
title(‘Monte Carlo Uncertainty Propagation’); matlab, sensivity analysis, monte-carlo MATLAB Answers — New Questions
I can’t install add-ons
Hello,
I am using the student version of MATLAB (R2023a) and I want to install some Arduino add-ons and everytime it fails. This is the last erro I got and it seems there is nothing wrong with the installation. I tried on another computer too and I also get a failure error.Hello,
I am using the student version of MATLAB (R2023a) and I want to install some Arduino add-ons and everytime it fails. This is the last erro I got and it seems there is nothing wrong with the installation. I tried on another computer too and I also get a failure error. Hello,
I am using the student version of MATLAB (R2023a) and I want to install some Arduino add-ons and everytime it fails. This is the last erro I got and it seems there is nothing wrong with the installation. I tried on another computer too and I also get a failure error. matlab, add-ons MATLAB Answers — New Questions
3D data plotting in matlab as a cube?
I am using following code fvc = isocaps(trc,1e-4); the problem is arises with 1e-4, for example, if my data ranges 0 – 1, if I select 1e-4 as zero it will not display the part data having zero values, how to solve it?
Following is my code and data size is 139 48 176.
fvc = isocaps(trc,1e-4); % meshgrid(1:sizes) by default, not like you care about coordinates
patch(fvc,’FaceColor’,’interp’,’EdgeColor’,’none’) %interp
colormap(jet)
colorbar;I am using following code fvc = isocaps(trc,1e-4); the problem is arises with 1e-4, for example, if my data ranges 0 – 1, if I select 1e-4 as zero it will not display the part data having zero values, how to solve it?
Following is my code and data size is 139 48 176.
fvc = isocaps(trc,1e-4); % meshgrid(1:sizes) by default, not like you care about coordinates
patch(fvc,’FaceColor’,’interp’,’EdgeColor’,’none’) %interp
colormap(jet)
colorbar; I am using following code fvc = isocaps(trc,1e-4); the problem is arises with 1e-4, for example, if my data ranges 0 – 1, if I select 1e-4 as zero it will not display the part data having zero values, how to solve it?
Following is my code and data size is 139 48 176.
fvc = isocaps(trc,1e-4); % meshgrid(1:sizes) by default, not like you care about coordinates
patch(fvc,’FaceColor’,’interp’,’EdgeColor’,’none’) %interp
colormap(jet)
colorbar; 3d plots, 3d, plotting MATLAB Answers — New Questions
Data Rate calculation in 5G NR TDD scheduling
Hi all,
Could someone please help me out in finding the data rate calculated for each UE in the 5G NR TDD/FDD scheduling example using the 5G toolbox?
Thanks in advanceHi all,
Could someone please help me out in finding the data rate calculated for each UE in the 5G NR TDD/FDD scheduling example using the 5G toolbox?
Thanks in advance Hi all,
Could someone please help me out in finding the data rate calculated for each UE in the 5G NR TDD/FDD scheduling example using the 5G toolbox?
Thanks in advance 5g nr, scheduling MATLAB Answers — New Questions
Microsoft Licenses Request
Are there any indirect providers who can assist me in providing Microsoft licenses to my customers? I am registered as a CSP Microsoft Partner and want to ensure a smooth process.
Thank you for your attention to this matter. I appreciate your prompt assistance.
Best regards,
Miftah Rizky
Are there any indirect providers who can assist me in providing Microsoft licenses to my customers? I am registered as a CSP Microsoft Partner and want to ensure a smooth process. Thank you for your attention to this matter. I appreciate your prompt assistance.Best regards,Miftah Rizky Read More
Categorization of a large, dynamic data set
I have a challenge which I can’t solve. Already tried multiple ways – makearray, byrow, etc. Nothing worked so far. Here is the challenge:
I have a large set of data (>20000 rows, dynamic). It holds a.o. segments and size of segment (a number). Let’s assume segment is in array A1# and size of segment is in array B1#. In a different table (~20 rows), all the unique segments are listed (named “Segments”). Next to this segment list, I have organized data for 3 categories (small/medium/large) for each segment. Each segment will have its own data for what is defined as small/medium/large. As such, I have 3 columns next to the segment name that holds number values for size thresholds.
In the large table, I now want to categorize each segment. Every segment (A1#) has a size (B1#) which corresponds to a category (small/medium/large) -> I.e. it needs a lookup in the category table.
I would want the formula to result in a spilled array – given the data is dynamic in nature.
Thanks for your ideas!
I have a challenge which I can’t solve. Already tried multiple ways – makearray, byrow, etc. Nothing worked so far. Here is the challenge:I have a large set of data (>20000 rows, dynamic). It holds a.o. segments and size of segment (a number). Let’s assume segment is in array A1# and size of segment is in array B1#. In a different table (~20 rows), all the unique segments are listed (named “Segments”). Next to this segment list, I have organized data for 3 categories (small/medium/large) for each segment. Each segment will have its own data for what is defined as small/medium/large. As such, I have 3 columns next to the segment name that holds number values for size thresholds.In the large table, I now want to categorize each segment. Every segment (A1#) has a size (B1#) which corresponds to a category (small/medium/large) -> I.e. it needs a lookup in the category table.I would want the formula to result in a spilled array – given the data is dynamic in nature.Thanks for your ideas! Read More
Clarification on Annual Cost and Maintenance for SQL Server with SA
Hi everyone,
I’m planning to purchase SQL Server with Software Assurance (SA). I noticed a mention of a cost of $15123, but it’s unclear whether this is a one-time payment or an annual fee. Could someone clarify the annual cost for this setup? Additionally, are there any maintenance costs that I should be aware of?
Thank you!
Hi everyone,I’m planning to purchase SQL Server with Software Assurance (SA). I noticed a mention of a cost of $15123, but it’s unclear whether this is a one-time payment or an annual fee. Could someone clarify the annual cost for this setup? Additionally, are there any maintenance costs that I should be aware of?Thank you! Read More
How can I fix Quick-Books Error UEXP
I’m encountering Quick-Books Error UEXP and need assistance in resolving it. What are the steps to troubleshoot and fix this error? Are there specific settings or updates I need to check?
I’m encountering Quick-Books Error UEXP and need assistance in resolving it. What are the steps to troubleshoot and fix this error? Are there specific settings or updates I need to check? Read More
How to build a social media assistant with Prompty and PromptFlow
How to build a social media assistant with Prompty and PromptFlow
Why Prompty.
Specification: Prompty is an asset class not tied to any language as it uses markdown format with yaml to specify your metadata. It unifies the prompt and its execution in a single package to quickly get started.
Tooling: using the Prompty extension, you can quickly get started in your coding environment and set up your configuration. It enables you to work with prompts at a high level with additional features such as metadata autocompletion, syntax highlighting, quick run and validation.
Runtime: Prompty additionally generates code for you in different frameworks e.g. LangChain, PromptFlow and Semantic Kernel. the asset class easily helps you convert to code simplifying your workflow as it is language agnostic.
Prerequisites and Authentication
To get started, you need to create a new Azure OpenAI resource on the Azure OpenAI Studio.
Once you create the resource, head over to Azure OpenAI Studio and create a gpt-35-turbo model deployment.
The first, and easiest way, to get started is by using environment variables. In your local environment, create a .env file, where you store your keys and endpoints. Your .env file, should be something like this:
AZURE_OPENAI_DEPLOYMENT_NAME = “”
AZURE_OPENAI_API_VERSION = “”
AZURE_OPENAI_API_VERSION = “”
AZURE_OPENAI_ENDPOINT =””
type: azure_openai
azure_deployment: ${env:AZURE_OPENAI_DEPLOYMENT_NAME}
api_version: ${env:AZURE_OPENAI_API_VERSION}
azure_endpoint: ${env:AZURE_OPENAI_ENDPOINT}
You can also, login to your Azure account using azd auth login –use-device-code, this will allow you to define your model configurations and update your settings.json files, allowing you to access your configurations without using environment variable.
Getting Started with Prompty
Install the Prompty extension
Right-click on the VSCode explorer and select “New Prompty.” This will create a new Prompty file in markdown format.
Configure your application metadata, in this case we will update as follows:
name: SociallyPrompt
description: An AI assistant designed to help you create engaging Twitter and LinkedIn posts
authors:
model:
azure_endpoint: azure_openai
azure_deployment: gpt-35-turbo
parameters:
max_tokens: 3000
temperature: 0.9
sample:
blog_title: LLM based development tools – PromptFlow vs LangChain vs Semantic Kernel
blog_link: https://techcommunity.microsoft.com/t5/educator-developer-blog/llm-based-development-tools-promptflow-vs-langchain-vs-semantic/ba-p/4149252
call_to_action: GitHub Sample Code at https://github.com/BethanyJep/Swahili-Tutor
post type: Twitter
Update your application instructions, use examples where necessary, for example, below is a sample instruction for our social media assistant:
You are an Social Media AI assistant who helps people create engaging content for Twitter. As the assistant,
you keep the tweets concise – remember that 280-character limit! Inject enthusiasm into your posts!
Use relevant hashtags to boost visibility for the posts. And have a call to action or even add some personal flair with appropriate emojis.
# Context
I am an AI assistant designed to help you create engaging Twitter and LinkedIn posts. I can help you create posts for a variety of topics, including technology, education, and more. I can also help you create posts for blog posts, articles, and other content you want to share on social media.
user:
{{post_type}} post for the blog post titled “{{blog_title}}” found at {{blog_link}} with the call to action “{{call_to_action}}”.
Once done click the run button to run your Prompty in the terminal
Extending functionality with Promptflow
Tracing your Flow
Resources
Our Social Media Assistant Prompty: BethanyJep/social-media-assistant-prompty (github.com)
Microsoft Build: Practical End-to-End AI Development using Prompty and AI Studio (microsoft.com)
Prompty samples: Collections | Microsoft Learn
Prompty documentations: prompty.ai
Microsoft Tech Community – Latest Blogs –Read More