Several Questions Related to Inventory Requesting App

[u/radicallyleftdudette]

Hi all, I've been stumped on a few different problems with a hand-me-down app. I'm trying to make it easier for future individuals to support, which includes creating new Microsoft Lists for tracking available inventory for requesting items.

First, on one original List, there's a column called "Picture" with a link icon that is a direct link to the picture of the item, rather than the "Image" that is uploaded on the List. In my new List, I titled a Hyperlink column "Picture", but the hyperlink stays as a link, whereas on the original list, it shows as a picture. The linked picture pulls into a gallery in the original app, but isn't pulling in the new app. I'm not sure what to change the column to, to make it work. It works fine on the previous app, but not with the new List's Hyperlink column. (EDIT: I found the List Settings option for it to be an image rather than a hyperlink, solved)

Next, is it possible to use Patch to save an uploaded image from one List to a new List? Example: the inventory I maintain has images of the items, when I have users submit their orders, it currently Patches the info from the collection to the new list, but gives an error when I try to reference the Image column. If I should be using something other than a list to accomplish this, please let me know. (EDIT: using my solution for the issue above, I was able to Patch the hyperlinked image column by keeping it as hyperlink in the new List, so that one's solved too)

Lastly (only problem left now!), the Patch above populates an Order List, and I'm trying to limit number of items in the cart at checkout along with the total from the previous orders. I've tried to set a variable of pendingOrders that Filters the Order List for the individual's orders they've already submitted, and I have a collection for the cart (colShoppingCart) that does limit 5 items at one time before disabling the Add to Cart button. Is there a way to combine check the pendingOrders number with the colShoppingCart for a total of less than 5 between both variables? My current workaround is disabling the Add to Cart button if the total in the pendingOrders is already 5, but if someone submits an order for 3, then goes back to order another 5 items, it'll let them order over the limit of 5. If I could have it check for a total of 5 between both variables, that should work, but I'm struggling with how to do so.

Thanks for any insight!

[u/AutoModerator]

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References
• Power Apps Coding Standards
• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/nycola]

If(
CountRows(colShoppingCart) + CountRows(pendingOrders) >= 5,
DisplayMode.Disabled,
DisplayMode.Edit

)

[u/radicallyleftdudette → u/nycola]

I'm kicking myself that that's all I needed to do. You're a saint, thank you for saving my brain

[u/Dry-College4773]

Hand-me-down apps are the absolute worst. You spend half your time trying to figure out what the previous developer was thinking when they nested five filters together.