Hi Steph, this is a great guide! Do you have the code for the bid amount between the arrows on the bid page @26:22? I think it wasn't mentioned in the video.
If you join my channel you would be able to download the entire file set. BUT....here you go 😻 The code between the arrows is "$"& varBid where varBid is set by the arrows on either side, either up or down by the amount determined by the art piece size. The left arrow is: If(varBid>0,Set(varBid,varBid - Value(lblIncrementAmt.Text)),0) The right arrow is: If(varBid>=0,Set(varBid,varBid + Value(lblIncrementAmt.Text)),0)
Hi Steph, your video was very helpful and i built the Auction but i have a problem with the patch function. It shows me always an error: invalid argument type. expecting one of the following number date time datetime...., even when i copy your code, it's not working and i couldn't find the Problem. Do you have an idea?
Hi Madam, How did you upload all the images in SharePoint. please let me know. I got stuck in here to proceed further. In the SharePoint list the Name column is of type "Text" right, how didi the images fit in that column. Please do clarify. Thank you.
Great video, the only thing I get stuck with an error when multiple people try to bid on the same item: Network error when using Patch function: Conflicts exist with changes on the server, please reload. Is there a way to show a message "You have been outbid", instead of the error?
This is a super helpful video. Only thing I am having a hard time grasping is how you coded the box between the Up and Down buttons on the second page. I didn’t see in the video were you went over that portion. Thank you!
The code for the down arrow is: If(varBid>0,Set(varBid,varBid - Value(lblIncrementAmt.Text)),0) and the up arrow is: If(varBid>=0,Set(varBid,varBid + Value(lblIncrementAmt.Text)),0)
@@StephMarshall I think you just gave us the code for the up and down arrows. What we are looking for here is the code for the one in between. The one that the number changes anytime you click on the up or down arrow.
Awesome video! Thank you for making this. I did not see you say anything about "Set Max Bid". How did you have that set up? Would you need a separate list to store all the user's names and max bids?
Here's a Microsoft release - www.microsoft.com/en-us/microsoft-365/blog/2023/05/09/introducing-the-microsoft-365-copilot-early-access-program-and-new-capabilities-in-copilot/
Steph, this is AWESOME! I had a need for this and came across your video It has everything I needed. You rock!!
Thank you so much! 😎
Hi Steph, this is a great guide!
Do you have the code for the bid amount between the arrows on the bid page @26:22? I think it wasn't mentioned in the video.
If you join my channel you would be able to download the entire file set. BUT....here you go 😻
The code between the arrows is "$"& varBid where varBid is set by the arrows on either side, either up or down by the amount determined by the art piece size.
The left arrow is: If(varBid>0,Set(varBid,varBid - Value(lblIncrementAmt.Text)),0)
The right arrow is: If(varBid>=0,Set(varBid,varBid + Value(lblIncrementAmt.Text)),0)
Great video!
Glad you enjoyed it
Hi Steph, your video was very helpful and i built the Auction but i have a problem with the patch function. It shows me always an error: invalid argument type. expecting one of the following number date time datetime...., even when i copy your code, it's not working and i couldn't find the Problem. Do you have an idea?
Hi Madam, How did you upload all the images in SharePoint. please let me know. I got stuck in here to proceed further. In the SharePoint list the Name column is of type "Text" right, how didi the images fit in that column. Please do clarify. Thank you.
Hi, are you referring to the images that are up for auction or images in the app?
Excellent Marshall ❤
Great video, the only thing I get stuck with an error when multiple people try to bid on the same item: Network error when using Patch function: Conflicts exist with changes on the server, please reload. Is there a way to show a message "You have been outbid", instead of the error?
super nice!
Thank you! Cheers!
Awesome! 🥳🥳
Thanks! 😁
🎬 Code Snippet
If(
!IsBlank(varItem.'Last Bidder'),
Office365Outlook.SendEmailV2(
varItem.'Current Bidder'.Email,
"Silent Auction - You've been outbid!",
"Hello " & varItem.'Current Bidder'.DisplayName & ",You have been outbid by " & User().FullName & ", the current bid is $" & (Value(LabelBidAmount.Text) + Value(lblBidAmt.Text)) & "!!!
Head back to the auction to outbid them.
",
{Cc: User().Email}
)
);
Patch(
'Art Auction Photos',
varItem,
{
Bid: (Value(LabelBidAmount.Text) + Value(lblBidAmt.Text)),
Bids: (Value(lblBidsCount.Text) + 1),
'Last Bidder': {
Claims: "i:0#.f|membership|" & If(
IsBlank(varItem.'Current Bidder'.Email),
User().Email,
varItem.'Current Bidder'.Email
),
Department: "",
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
},
'Current Bidder': {
Claims: "i:0#.f|membership|" & User().Email,
Department: "",
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
}
}
);
This is a super helpful video. Only thing I am having a hard time grasping is how you coded the box between the Up and Down buttons on the second page. I didn’t see in the video were you went over that portion. Thank you!
The code for the down arrow is:
If(varBid>0,Set(varBid,varBid - Value(lblIncrementAmt.Text)),0)
and the up arrow is:
If(varBid>=0,Set(varBid,varBid + Value(lblIncrementAmt.Text)),0)
@@StephMarshall thank you so much!
@@Eyak_8477 Were you able to get this to work? I cannot get the box between the arrows to function at all for some reason.
@@StephMarshall I think you just gave us the code for the up and down arrows. What we are looking for here is the code for the one in between. The one that the number changes anytime you click on the up or down arrow.
I found the answer . It is "$"& varBid
Awesome video! Thank you for making this. I did not see you say anything about "Set Max Bid". How did you have that set up? Would you need a separate list to store all the user's names and max bids?
It's the same list, the max bid amount was a fixed amount set by the client. on the button click for Set Max bid Set(varBid,50)
Great Video. But that timer will run to Negative numbers when set date elapses and Continue when it get to Zero
Great point! This app ended after a specific date and was taken down.
Thanks alot....when copilot would be roled out
Here's a Microsoft release - www.microsoft.com/en-us/microsoft-365/blog/2023/05/09/introducing-the-microsoft-365-copilot-early-access-program-and-new-capabilities-in-copilot/
Awesome apps,may i know what is code for text label "Label Bid Amount"?
Sure thing!
"$"& varItem.Bid
Hello, could you kindly make a video on how to make this app responsive?
I might!
Can i have your email address? I want to ask a few thing regards the steps to build similar apps like this.
Hello! If you ask your questions here I'll answer them and everyone can learn something!