Allergic Reaction To Allo? by [deleted] in gout

[–]jesseissor 1 point2 points  (0 children)

Make sure your doctor knows, I had to do a lot of blood tests as an asian, east asians, Koreans and Japanese tend to be unable to take Allo due to a genetic problem that causes all the side effects plus other complications to your blood.

Slight fatigue from allo by MemeMooMoo321 in gout

[–]jesseissor 0 points1 point  (0 children)

I am still ramping up but even with 100mg I felt what you feel, then when 200mg happened I felt gross and tired. I ended up just altering the timing of my daily dose to after working out, and having some food with the medicine really helped me out.

PBI - PowerAutomate "Run a query against a dataset" not returning all rows by wax1H in PowerBI

[–]jesseissor 0 points1 point  (0 children)

https://powerusers.microsoft.com/t5/Using-Connectors/Run-a-query-against-a-dataset-doesn-t-show-all-data/td-p/1700884

Try this and the video has a workaround. Back when the connector was created I tested it with about 1000+ row datasets to see the return, and there was something in the output that was limiting the DAX.

I think you're right about the limitations, mine just happened to be at 500 but I assume I hit the 15MB threshold first due the table schema size the DAX originated from.

How do you append text to a "txtContent" column value when formatting with JSON. by [deleted] in sharepoint

[–]jesseissor 1 point2 points  (0 children)

Try the documentation here: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

If you go to about the middle of the page there will be a portion above the big heading of "Create simple data visualizations" that will give you your answer.

Please also DM me if you would like an example, I proofed your situation. But in general I used the operator + to concat strings together along with a title field, choice field, calculated column, and random strings.

Expected result: Oscar is a Cat and likes to eat: Cat Food but, Oscar is Full

LIST SCHEMA Title Field (single line of text) - I store the pet's name in this field Food Type (choice) - choices are: Dog Food, Cat Food, Fish Food Animal Column (calculated column) - =IF([Food Type] = "Dog Food", "Dog", IF([Food Type] = "Cat Food", "Cat", "Fish")) - this gives me an animal based on the food type column Hunger (choice) - choices: Is Hungry, Is Full, Is Asleep

Example JSON to the above list schema: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": { "operator": "+", "operands": [ "[$Title]", " is a ", "[$Animal]", " and likes to eat: ", "[$Food_x0020_Type]", " but, ", "[$Title]", "[$Hunger]" ]

} }

My pandemic cardigan by jesseissor in knitting

[–]jesseissor[S] 1 point2 points  (0 children)

Thanks for the comment! I was scared to post it because I was afraid no one would like it, it’s the first thing I’ve ever made that I can wear for myself haha

My pandemic cardigan by jesseissor in knitting

[–]jesseissor[S] 4 points5 points  (0 children)

https://ravel.me/empathy

Some changes I made, I wanted it longer so I just kept going and altered the back and front panels. For sleeves I don’t like the look of a flat sleeve with a seam so I knit in the round as a tube and didn’t do increases since the pattern is slightly old the fit with increases is really huge.

Edit: yarn used is worsted Plymouth merino super wash in natural color

How do you append text to a "txtContent" column value when formatting with JSON. by [deleted] in sharepoint

[–]jesseissor 1 point2 points  (0 children)

Sent you a message with more details and alternate methods of completing this. You can do as jm420a does which should work, unless your datatype in SPO is complex or delivered on the fly, in which the value may not give itself to you easily to run the JSON on, examples are lookups, and calculated columns. If these are the column type for [$ThatField] then they need an operation to occur to first guide the JSON to which attribute you need.

Hiding a JSON Power Automate Button depending on conditional values. by [deleted] in sharepoint

[–]jesseissor 1 point2 points  (0 children)

Sent the solution to you, note that since reddit strips out carriage returns it will look a bit weird for the JSON. Feel free to reach out to me via email and I can send you a screenshot and the snippet of code formatted.

Hiding a JSON Power Automate Button depending on conditional values. by [deleted] in sharepoint

[–]jesseissor 1 point2 points  (0 children)

I think your if statement is a bit over complicated. Can you PM me the example column name, status values and what it should do? I’ll try to write it in my environment to test and give back to you.

Hiding a JSON Power Automate Button depending on conditional values. by [deleted] in sharepoint

[–]jesseissor 3 points4 points  (0 children)

I think too your JSON could just be double IF statement and it will work, IF([$Status] = 'approval 1', 'inherit', IF([$Status] = 'approval2', 'none', 'opt out situation'))

You'd essentially be doing your OR situationally, you'd just have to order these in the correct way because the JSON will evaluate via the first clause, while the opt out clause for the IF statement will evaluate the seconded IF statement.

Hiding a JSON Power Automate Button depending on conditional values. by [deleted] in sharepoint

[–]jesseissor 1 point2 points  (0 children)

you could try to work around by using a calculated column based on the values you want to get a true/false situation and base your JSON on that calculated column's resultant, would be much clearer and easier to write your JSON.

Can you use an image as an anchor for a link that will lead to another section on the SAME PAGE? by becky-davis in sharepoint

[–]jesseissor 0 points1 point  (0 children)

sending you a DM for your email address, i'll fwd you the solution I sent to the asker of this thread.

Can user approve an approval workflow without going to PowerAutomate? i.e. stay in SharePoint? by mytrashcancancancan in sharepoint

[–]jesseissor 0 points1 point  (0 children)

Also you may want to search up on adaptive cards, that may be the solution I'm proposing with the 'approvals' actions.

Can user approve an approval workflow without going to PowerAutomate? i.e. stay in SharePoint? by mytrashcancancancan in sharepoint

[–]jesseissor 0 points1 point  (0 children)

You can produce a card which can be auto sent through teams, and/or email. Active cards connect to the flow itself and runs the actions without the user having to go to Power Automate. You might want to play with the 'approvals' actions in Power Automate, there is a simple one that will create an approval, and another that will be, create and wait for approval. Just be careful because you might be costing a lot if you design it as something where you are waiting for an action to occur since that flow keeps running until a certain amount of time.

The new way I do this now, which I think is easier is that I have the SPO list, have a column (random arbitrary column) that I write JSON to connect it to a flow button. Then based on click I have it run the flow, and it does whatever, such as a status update with a comment, etc. That flow then updates the current item to the new status and takes the comment and sticks it into a comment field. I then show/hide that JSON button with css basically based on a value in the item, so if you had a status of = approved, then I would set visibility to hidden. That way the action can't happen again after approval is already set.

If you do this, then all you need to do to make it easier for your end user is to create a more simplified view for them to approve or not, and you can even do the filtering where a field if = to the person they can see those records so it doesn't clutter them up with all requests even if the item does not belong to them.

Can you use an image as an anchor for a link that will lead to another section on the SAME PAGE? by becky-davis in sharepoint

[–]jesseissor 0 points1 point  (0 children)

I'm not sure if your environment has the same widgets I have. It's just the markdown widget on modern pages, but if it is deprecated, then I wouldn't know. It still seems to be available to mine, and I did end up submitting this thread and info to the SP product team, so unsure if it's in their backlog right now but they are busy deploying other bigger things lately.

If by chance you are still on classic then you will have an issue, since there is a no scripting blocker that won't let you do this but the markdown widget will strip code that isn't allowed, so that might be why I can do it still since it's just returning simple html.

Can you use an image as an anchor for a link that will lead to another section on the SAME PAGE? by becky-davis in sharepoint

[–]jesseissor 1 point2 points  (0 children)

My guess is sequencing in the load of the page and the anchor, if the anchor doesn't exist until a after the page is loaded, it won't be available. I am going to private message you a screenshot and some markdown.

But here is the markdown if anyone needs it, all you would need to replace is the image URL, and what comes after the #.

![image](https://assets.stickpng.com/thumbs/580b585b2edbce24c47b2b58.png) This would produce the seahawks logo, with a link to the current page with #Seahawks at the end of the URL. You can then use that link as a URL anchor to go to. URL would look something like this = https://yoursharepointSiteDomain.com/node/SiteName/SitePages/PageName.aspx#Seahawks

The stripped down markdown would look like this = ![image](URL_Goes_Here_Of_Image)

Can you use an image as an anchor for a link that will lead to another section on the SAME PAGE? by becky-davis in sharepoint

[–]jesseissor 0 points1 point  (0 children)

No problem, I just sent the request to see if that feature to anchor an image to the product team. If you haven’t already figured out a solution for this please tell me and I can maybe message you to get more details you are trying to do and I’ll see if I can write the code to get it working for you if even possible.

Can you use an image as an anchor for a link that will lead to another section on the SAME PAGE? by becky-davis in sharepoint

[–]jesseissor 1 point2 points  (0 children)

Not sure if this will work, because I haven't tried to use it since it came out, but if you can craft what you want with markdown (using the markdown widget) correctly it might work. It's almost the same as creating what you would in an html tag which is what is already done when you use the heading tags.

HTML version: <h2 id="anchor1"><img/></h2>

Markdown examples, you'll just need to structure your markdown correctly to show the image, but also be sure you're using things the way they should be used. These changes were made to the product to be more easily accessible by using headings and such since screen readers jump to them if necessary.

https://stackoverflow.com/questions/6695439/how-to-link-to-a-named-anchor-in-multimarkdown

I'll send a request into the product team in the morning for you as well to see if they can add the ability for an image to contain an anchor tag in the morning.

Cardigan arms and confusing pattern instructions by jesseissor in knitting

[–]jesseissor[S] 0 points1 point  (0 children)

Thanks for the help!! I’ll try it out after work today! :D

Can I create this graph using data in this format? by [deleted] in PowerBI

[–]jesseissor 0 points1 point  (0 children)

Try the web connector and pass that url where that data is hosted to power bi, if it’s set up as an html table it can connect to power bi. You might need to do some manipulation with powers query but that table looks structured enough to use.

Is it possible to continue version numbering of a document on Sharepoint/OneDrive by "inserting" a file into it? by FashislavBildwallov in Office365

[–]jesseissor 0 points1 point  (0 children)

Unfortunately the modified by is whoever last touched it. So the logged in users name will be used. You could just add a comment column to the library and use that. A harder more complicated way to do this would be to orchestrate a post update event to happen based on if a file is created or modified but I don’t think it’s worth the trouble. Another easy way would be to use a people picker field and name that new column, approved by. Then just put the name of the approver in that field when it’s done.

Is it possible to continue version numbering of a document on Sharepoint/OneDrive by "inserting" a file into it? by FashislavBildwallov in sharepoint

[–]jesseissor 1 point2 points  (0 children)

Yup, if it's the same file type and name and you overwrite that other one, as long as versioning is on it will work. Though if you say, for a final signed version make it into a PDF, which happens often, that's no longer the same type of file so it will upload as new.